SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Showing posts with label
Functions
.
Show all posts
Showing posts with label
Functions
.
Show all posts
Monday, February 20, 2017
The strange case of the missing indexes....
›
This past week I needed to run some queries on production to verify there were indexes added on a table. There were several scripts that n...
Thursday, May 08, 2008
How to log when a function is called?
›
This question came up today and here is one way of doing it. It requires running xp_cmdshell so this is probably not such a good idea. The ...
Tuesday, October 02, 2007
How to find out the recovery model for all databases on SQL Server 2000, 2005 and 2008
›
How do you find out the recovery model for all the databases on your SQL Server box? On a SQL Server 2005/2008 box you can use the sys.datab...
Monday, August 20, 2007
Do you know how NULLIF and non-deterministic functions work?
›
Run this first CREATE TABLE #j (n varchar (15)) DECLARE @a int SET @a = 1 WHILE @a BEGIN INSERT #j SELECT NULLIF ( REPLICATE ( '1...
›
Home
View web version
