Tag Archives: system functions
-
Which user function do I use?
2June 24, 2015 by Kenneth Fisher
Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
Continue reading -
Extending your metadata with Extended Properties
9May 18, 2015 by Kenneth Fisher
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
Continue reading -
Who’s using that database?
1March 9, 2015 by Kenneth Fisher
A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
Continue reading -
TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?
1January 13, 2015 by Kenneth Fisher
I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this …
Continue reading -
Does a clustered index sort the rows within a page
Leave a commentDecember 15, 2014 by Kenneth Fisher
This is just something I was curious about. I ran my tests and got an answer and now I thought …
Continue reading -
Putting sp_ at the beginning of your stored procedure.
1November 24, 2014 by Kenneth Fisher
Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
Continue reading -
Changing configuration settings with sp_configure
5September 22, 2014 by Kenneth Fisher
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
Continue reading -
What are trace flags?
2September 11, 2014 by Kenneth Fisher
Trace flags are one of those things that I’ve heard about more and more over the last five or six …
Continue reading -
More than sp_help
5August 14, 2014 by Kenneth Fisher
If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
Continue reading