2004-10-05
2,335 reads
Randomise the order of a SELECT
I have a set of data that I need to display in a random order each time I displayed it. There are several ways to do this, for example using a CURSOR to add each record to a temp table with a GUID, but a quick and dirty way to do this is to use […]
2002-05-16
488 reads
Blogs
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Forums
Read Only Files
Comments posted to this topic are about the item Read Only Files
Why A Query May be Faster the Second Time it Runs
Comments posted to this topic are about the item Why A Query May be...
OLE DB 0x80004005 connection error trying to run SQL HA Maintenance Plans
Hi, I'm getting a connection error when I try to run even the most...
Ask SSC