Archives: September 2014
One of the options you had when installing your instance was setting some default file locations.
- Defaut data file location
- Default log file location
- Default backup file location
If you are new to installing SQL Server (and even if you aren’t) you might very well have skipped past these… Read more
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how truly useful they can be. To that end here is all that I can remember about batch files (basically a text file that ends with .bat). Everyone seemed to like… Read more
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that I realized that the existence of sp_configure is probably not universal knowledge. I was truly shocked. For some reason I had thought that DBA’s were born with this knowledge. As… Read more
Triggers are very useful tools but can easily cause all sorts of headaches. In fact I would generally advise… Read more
Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick.
Trace flags are one of those things that I’ve heard about more and more over the last five or six years. But only in the past year or so have I started to understand what they are and how to use them. I want to start out by saying that… Read more
It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host picks a subject and we all blog about it. It was originally started by Adam Mechanic (b/t) almost 5 years ago. This month Sebastian Meine ( Read more
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop an instance, pause an instance. Start, stop, pause. Wait just a minute! Is this SQL Server or an mp3? (I just want to point out I started with a record,… Read more
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are the best information about what a query is doing and so how to improve it. However there are a couple of little commands that can be a big help too.… Read more