Las Vegas February 2013 UG
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t...
2013-02-12
606 reads
SQL RNNR
Las Vegas February 2013 UG
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t know what that is, you should go check out...
2013-02-12
Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a...
2013-02-12 (first published: 2013-02-11)
1,638 reads
Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your...
2013-02-11
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server?
Are you wondering when...
2013-01-30 (first published: 2013-01-24)
4,190 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
4 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,230 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
995 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces and with some regulars. In total, we had 22...
2013-01-15
2 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
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...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
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-...
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