Variables, Literals, Procs and Stats

This post by US PFE Susan Van Eyck goes through considerations when developing stored procedures using local variables and literals, and their effect on the query plan / performance.   I ran across a very interesting blog post by Kendra Little this week about the perils of troubleshooting – or developing – stored procedure using…

0

Previewing file content

Windows Explorer is a common tool for anyone working in the Windows environment and sometimes being able to quickly view the content of a part of a file is all that is needed so enabling Windows Explorer Preview Pane can be quite useful. We can see below, the contents of the csv file selected on…


Keeping your important files safe and secure

We all have important files of some sort or another but do we all look after them correctly? Ensuring their security using NTFS ACLs might be the process used by many. Some will add a Read Only marker on the files that are for reference only (ISO’s, backups etc) but do you do anything else…


Somewhere to put that data while your script runs

Ever writing a script and want to quickly place some data in a file while in the middle of your process? Try out [System.Io.Path]::GetTempFileName(). This method gives you a file with a random, unused file name in your local temp folder where you can write out interim information without worrying about testing whether the file…


How to find out what you need to know

For as long as I can remember I have come across problems where I need to know the range of valid options for a setting so that I can make an appropriate change, but I haven’t know the right values to use. For  example – If you wanted  to change the powerplan of your computer…


Fill Factor and Data Compression

Another post by our excellent US PFE Susan Van Eyck goes though Fill Factor and Data Compression!   I got a pair of interesting questions from a colleague this week: If you’re using fill factor then enable data compression, is the fill factor still enforced? If you aren’t using fill factor and enable data compression…

2

Microseconds Or Milliseconds

  While working with a customer on creating some Extended Event to collect performance trace, I was if asked if the duration is in microseconds or milliseconds. Thinking to myself, “well in SQL 2005 and later it is in microseconds”, although the Profiler UI has an option to display the value in either milliseconds or microseconds. …

0

You really need to look out for msdb security

So msdb, we don’t really think about it that much right? We know it holds the metadata for our Jobs and Schedules, also some good info on page corruptions, as well as backups, and much more. But how often do we think about it’s security? You may already know that the Guest user is enabled…


Troubleshooting Using Ring Buffers

Working at a customer site, and I happened to notice that the Exception ring buffer contained a lot (and I mean A.L.O.T.) of errors. Ring Buffers were introduced in SQL 2008, and contain a fixed size cycle of records for the ring buffer they pertain to. Now… note – sys.dm_os_ring_buffers is a DMV which is…


Advantages and Annoyances of Filtered Indexes

This weeks great post by our US Senior PFE Susan Van Eyck talks about the wonders of filtered indexes! Check it out!   Today’s Byte is about the advantages and annoyances of filtered indexes.  We’ll talk about What they are Where (and why) they’re useful How to create one How to convince the optimizer to…

0