Next PASS Summit is Nov 6-9, 2012
After enjoying the entirely reasonable weather in Seattle in October this year we’ll return to our more traditional time frame...
2011-10-19
541 reads
JOIN IN SQL FAQ
1) What types of JOINS exist?
Inner Joins
Outer Joins (LEFT JOIN, LEFT OUTER JOIN, RIGHT JOIN, RIGHT OUTER JOIN, FULL...
2011-10-19
1,464 reads
Using sys.dm_exec_requests to find a blocking chain
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,178 reads
Rat Sues Corn! Rather, rat accuses corn of thought-theft! Or something!
Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...
2011-10-18
681 reads
October 2011 SQL Server 2008 Diagnostic Information Queries
Since Microsoft has been so busy releasing Cumulative Updates for both SQL Server 2008 and SQL Server 2008 R2 over...
2011-10-18
1,686 reads
Dropping a database – such a simple thing!
G’day,
I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect.
Well,...
2011-10-18
4,418 reads
ColoradoSQL. in October
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-10-18
1,245 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!! We had to reschedule the October meeting due to unforeseen circumstances. The only change is the date of the...
2011-10-18
8 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!!
We had to reschedule the October meeting due to unforeseen circumstances....
2011-10-18
508 reads
SQL Server 2008 SP3 CU1
Microsoft has been busy getting SQL Server Cumulative Updates released over the past couple of days. The latest release is...
2011-10-18
715 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