NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select...
2011-09-27
775 reads
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...
2011-09-27
1,483 reads
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears...
2011-09-27
401 reads
Missing indexes
One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....
2011-09-27
1,417 reads
September 2011 SQL Server 2008 Instance Level Diagnostic Queries
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,248 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,551 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
9 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
12 reads
SQL Server – Creating and using Dump Devices for Backups
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using...
2011-09-26
1,330 reads
Recovery Models
In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases...
2011-09-26
2,869 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
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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