Monthly Archives: June 2013

2 comments on stored procedures

Stored procedures are compiled (the first time they are run) and therefore should execute faster than the raw t-sql code.  They also allow the use of variables, so that the same stored procedure can be reused: SELECT DISTINCT City FROM Person.Address where StateProvinceID=80; and write a … Continue reading

Posted in Uncategorized

SQL version

I have a little list – of MS SQL servers and what to get some general data on them.  There are various collections of scripts to run and stored procedures/DMVs to get that data, but won’t you know – not … Continue reading

Posted in Uncategorized

update noteproperty

i  have a powershell script… well, i have several, but … that builds an object based on the output from a SQL query.  That seems to fail nicely if the sql statement does not return an indexed reader.  I mean … Continue reading

Posted in Uncategorized