How to check if powershell is running as administrator with elevated privileges
In case it's not clear from the title, I am referring to...
2023-09-06 (first published: 2023-08-14)
532 reads
Another option is coming to gain extended support for SQL 2012
If you still have SQL 2012 servers, you are probably aware that support...
2023-09-04 (first published: 2023-08-17)
268 reads
protocols enabled in a SQL Server instance
There are number of ways you can find out what protocols are enable in a SQL Server...
2023-09-01 (first published: 2023-08-31)
177 reads
Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell
For a very important client, I currently manage over 200 SQL...
2023-08-29
17 reads
A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs
As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...
2023-08-16 (first published: 2023-07-31)
888 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-13 (first published: 2023-08-12)
2,098 reads
Remotely Copy Files To Multiple Destinations Using PowerShell
Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...
2023-08-12
29 reads
A high level view of the most costly queries by CPU
I want to see at a high level i.e at batch or stored procedure level, not at the individual...
2023-07-31 (first published: 2023-07-13)
1,234 reads
Just to reiterate what's in the title of this post, what I mean is that the CLUSTERED COLUMNSTORE indexes are not ordered, while NONCLUSTERED COLUMNSTORE created indexes are on...
2023-07-24 (first published: 2023-07-05)
532 reads
Tracking the Inaccurate Cardinality Estimates
When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release of SQL...
2023-07-20 (first published: 2023-07-19)
368 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