Identity columns are all over the place. Probably 80-90% of the tables I see have them and they are almost ... Continue reading
2019-11-29 (first published: 2019-11-20)
1,090 reads
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be ... Continue reading
2019-11-18
33 reads
Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the ... Continue reading
2019-11-25 (first published: 2019-11-14)
1,134 reads
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and all. Wayne Sheffield (blog|twitter) is our ... Continue reading
2019-11-21 (first published: 2019-11-12)
448 reads
I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading
2019-11-07
100 reads
This week is the PASS Summit and it has me thinking about all of the amazing work done in our ... Continue reading
2019-11-06
6 reads
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading
2019-11-04
30 reads
We need to have processes and rules. They are important to any business. That said, exceptions are also going to ... Continue reading
2019-11-07 (first published: 2019-10-30)
404 reads
I’m a DBA. Data types are kind of important to me. I mean I know they are important to developers ... Continue reading
2019-10-28
121 reads
I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and ... Continue reading
2019-10-23
456 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