Browse by Tags
All Tags »
Tips and Tricks (
RSS)
The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves...
This one is mainly a personal reminder but I hope it helps somebody else too. Let's say you have a table that covers something like currency exchange rates with columns for the start and end dates of the period each rate was applicable. Now you need...
Today I tripped over a problem that was new to me. I wanted to find out, in SQL, whether a folder existed in the file system. I knew about using xp_fileexist to check for existence of a file but what about a folder? Well, it doesn't work on a folder...
Just found the answer to something that has been irritating me slightly for ages: how to give a user access to a report without giving them access to all the other reports in the folder. We have folders that are based on the roles people perform in the...
If you highlight the name of an object in a query window in SQL Management Studio and press Alt+F1 you instantly get a set of results showing almost everything you could want to know about the object: columns, parameters, datatypes, constraints, indexes...