Tag Archives: microsoft sql server
-
Database snapshots
4June 22, 2016 by Kenneth Fisher
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
Continue reading -
Help! My backup file has doubled in size.
2June 16, 2016 by Kenneth Fisher
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
Continue reading -
Comparing two query plans
3June 14, 2016 by Kenneth Fisher
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
Continue reading -
I need help with DBCC
2June 6, 2016 by Kenneth Fisher
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
Continue reading -
Using LEN wrong.
4June 2, 2016 by Kenneth Fisher
I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
Continue reading -
Master_Views: master_objects, master_tables, etc
1May 23, 2016 by Kenneth Fisher
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of …
Continue reading -
RAID your backups
6May 16, 2016 by Kenneth Fisher
Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. …
Continue reading -
Comparing the contents of two tables
16May 12, 2016 by Kenneth Fisher
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the …
Continue reading -
Grant Deny Revoke
3May 4, 2016 by Kenneth Fisher
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them. …
Continue reading -
Remove files from a filegroup
Leave a commentMay 2, 2016 by Kenneth Fisher
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve …
Continue reading
SQL Studies 