Tampa Code Camp is December 2, 2008
In recent years this event has been held in July, but this year they ran into problems when the planned...
2008-09-17
451 reads
In recent years this event has been held in July, but this year they ran into problems when the planned...
2008-09-17
451 reads
Cross functional teams sounds a lot like a buzzword, and maybe it is to a degree - but still worth talking...
2008-09-16
562 reads
We experimented with some video training back in 2004/2005 on SSC, but we just didn't have the time/energy to pursue...
2008-09-15
568 reads
Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are...
2008-09-14
477 reads
One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows,...
2008-09-14
525 reads
One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing'...
2008-09-11
1,250 reads
It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write...
2008-09-10
415 reads
One of the less used commands in T-SQL, the UNION command can come in very handy in a number of situations. SQL Server expert trainer, Andy Warren, discusses how you can use UNION.
2008-09-10
10,676 reads
PASS asked all speakers to update their blogs with news about the event (a good idea), so here's my post!
I'll...
2008-09-10
382 reads
I'm a couple weeks last posting this, but wanted to get my notes down anyway for future use. The goal of...
2008-09-09
463 reads
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
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...
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