SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s...
2012-07-11
1,273 reads
SQL RNNR
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say...
2012-07-11
8 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2012-07-02 (first published: 2012-06-25)
4,453 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
5 reads
Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,266 reads
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
1 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that...
2012-05-18
861 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that trend. I do have a good excuse for...
2012-05-18
2 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
852 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
4 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers