Are Indexes Actually Changes to the System?
Is an index change equivalent to a code change? Steve Jones asks the question and has a few thoughts.
2018-10-02
159 reads
Is an index change equivalent to a code change? Steve Jones asks the question and has a few thoughts.
2018-10-02
159 reads
With the need to remove older data, Steve thinks natural keys may be obsolete.
2018-10-01
211 reads
With lots of news coming out of Ignite, Steve talks about a few of the changes.
2018-10-01
44 reads
Do we need the right tool or just a tool? A guest editorial from Andy Warren gives a few thoughts on getting things done effectively.
2018-09-28
53 reads
Thanks for improving the string or binary data truncated error message.
2018-09-27
170 reads
Data classification may not be fun or even interesting, but it is necessary.
2018-09-26
67 reads
2018-09-24
69 reads
2018-09-24
137 reads
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
2023-07-05 (first published: 2018-09-21)
278 reads
2018-09-20
52 reads
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Comments posted to this topic are about the item Create an HTML Report on...
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Hi everyone I am getting an error when I create the index but I...
I have two calls to the GENERATE_SERIES TVF in this code:
SELECT TOP 10 gs.value FROM GENERATE_SERIES(1, 10) AS gs ORDER BY NEWID () OPTION (RECOMPILE); go DECLARE @a int = 10; SELECT TOP (@a) gs.value FROM GENERATE_SERIES(1, @a) AS gs ORDER BY NEWID () OPTION (RECOMPILE);In the actual query plans, what is the estimated number of rows for each batch in SQL Server 2022? See possible answers