(Koen Verbeeck) I have a data set about durations that I want to plot in a graph. I need to display the minimum, maximum, average and other statistical information in a convenient way. How can I do this using SQL Server Reporting Services (SSRS)?
Tag: sql server
Azure SQL Database Auditing
(Marcin Policht) Contemplating migration of on-premises systems to Microsoft Azure commonly raises security and confidentiality concerns since it is associated, at least to a certain degree, with relinquishing some of the oversight inherent to fully managed environments.
ROW_NUMBER SQL Server
(Derek E Wilson) SQL Server includes several Ranking Functions that can be called in T-SQL. One of these is the Row_Number() function. You can use this function to return a sequential number in your result set that begins at 1.
Create a clustered index and a primary key on existing tables
(Jen McCown) It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference available.
Microsoft SQL Server and the Big Data Play
(Kevin Kline) When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider one of three strategies. In the first strategy, which I won’t be addressing today, you might choose to tackle your big data architecture by pushing your relational datab
Does a clustered index sort the rows within a page
(Kenneth Fisher) This is just something I was curious about. I ran my tests and got an answer and now I thought I would share.
Reading The Power Query Trace File–With Power Query
(Chris Webb) In the September 2014 update of Power Query a new piece of functionality was added: the ability to turn on tracing. There’s no documentation about what the trace files actually contain anywhere (it’s clearly intended to be used only by Microsoft to help them diagnose problems) but I cou
Returning Sorted Record Sets Using the ORDER BY Clause
(Greg Larsen) Having your data returned to you in some meaningful sorted order is important sometimes. If you don’t tell SQL Server you want to order the results of a SELECT statement then there is no guarantee that your result set will come back in a particular order.
General facts of SQL SERVER – part 2
General facts of SQL SERVER – Part 2 Three – tier (3 – tier) structural design As soon as one starts executing difficult commercial way outs in a two – tier (2 – tier) structural design, the tier that implements the corporate guidelines turns out to be overloaded. As an outcome, it needs extra period of time to accomplish the...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Setup a Memory Quota for SQL Server Memory Optimized Databases
(Daniel Farina) You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip I will explain how to proceed.