SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,079 reads
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,079 reads
One of the challenges you face with SQL Server database mirroring is making sure that all of the databases that...
2012-03-27
10,047 reads
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...
2012-03-21
1,368 reads
If you ever find yourself having to setup database mirroring between different, untrusted Windows Domains, one of the most common...
2012-03-21
1,493 reads
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,253 reads
Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...
2012-03-20
1,798 reads
Even though SQL Server Database Mirroring is deprecated in SQL Server 2012, it is still a very useful HA/DR technique...
2019-04-02 (first published: 2012-03-12)
6,545 reads
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,078 reads
Yesterday, Intel finally released the much anticipated Xeon E5-2600 family of processors, also known as Sandy Bridge-EP. This is a...
2012-03-07
1,225 reads
Pretty much right on schedule, Frank Delattre has released CPU-Z 1.60, which has support for some new and upcoming processors...
2012-03-04
830 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