Tag Archives: SQL Server
-
SELECT FORMAT(COUNT(1),’N’) FROM TableName WITH (NOLOCK);
9December 26, 2023 by Kenneth Fisher
Alternate title: How do I tell how far I am on that command? This little command (frequently with a WHERE …
Continue reading -
What account is xp_cmdshell using?
3May 25, 2021 by Kenneth Fisher
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. …
Continue reading -
What is the CONTROL permission?
1January 19, 2021 by Kenneth Fisher
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: …
Continue reading -
Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!
4April 1, 2014 by Kenneth Fisher
Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move …
Continue reading
SQL Studies 