Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,144 reads
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals. Today’s topic is one of particular interest to me as...
2012-12-17
10 reads
On the Fifth Day…
Today we will have a quick change of pace. This will be less about maintenance and more about internals.
Today’s topic...
2012-12-17
1,085 reads
SQL Server Training in 2013–SQL Server 2012 New Features
As we approach the end of 2012 – The release year for SQL Server 2012 many of you as we approach...
2012-12-17
960 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for one of our favorite databases. That database being the...
2012-12-16
9 reads
On the Fourth Day…
We have come to the fourth day in this mini-series. So far I have laid down some under-carriage maintenance for...
2012-12-16
891 reads
PASS Data Arch VC presents: Intro to Master Data Services by James Serra
Please join this Thursday Dec 20th 2012 at noon central for Business Intelligence expert/consultant James Serra talking Master Data Services....
2012-12-16
534 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks...
2012-12-16
839 reads
SQL Server Quickie #5 – Bookmark Lookup Deadlocks
Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus
talks about Bookmark Lookup Deadlocks in...
2012-12-16
1,515 reads
On the Third Day…
Mais Oui! But of course, we must have some french hens for today! Today we have the third day of pre-Christmas. And as was mentioned we have more undercarriage...
2012-12-15
9 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers