April 24, 2008 12:23 PM
Posted by: Denny Cherry
ERRORLOG,
sp_who3,
SQLThat "s" is new in SQL Server 2005. It means that the SPID is a system process. For example my database is having a problem with tempdb running out of space for no reason. When I look in the log I see that SPID 118s is the offending SPID. When I watch SPID 118 using
April 21, 2008 9:00 AM
Posted by: Denny Cherry
DELETE statement,
SQLWhen you have data in your table that you need to remove the DELETE statement is the way to do that. Using the DELETE statement without any WHERE clause will remove all the data from your table. The WHERE clause works the same way as the WHERE clause for SELECT and UPDATE...
April 17, 2008 8:00 AM
Posted by: Denny Cherry
Compliance,
DataManagement,
Encryption,
SQL Server 2008While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I'm not sure how useful it actually is. It's touted as giving you data encryption of the entire database without any code change.
What this actually means is that if someone...
April 14, 2008 10:00 AM
Posted by: Denny Cherry
In Person Events,
Service BrokerThe NJ SQL Server User Group has been kind enough to invite me to come speak to them about SQL Server Service Broker.
I'll be speaking up there on August, 19,...
April 11, 2008 3:00 PM
Posted by: Denny Cherry
Back To Basics,
sp_change_users_login,
SQLThe sp_change_users_login procedure has a specific purpose. It's used to identify and correct users within a database which do not have a corresponding logins.
You can specify the value of Report for the @Action input parameter to see any users which do not have a corresponding login. This...
April 11, 2008 12:00 PM
Posted by: Denny Cherry
Back To Basics,
LOGIN,
USERUsually Logins and Users are words which are interchangeable with each other. However in Microsoft SQL Server they are very different things. Because everyone assumes that they are the same thing, it can get a little confusing.
Logins are created at the database server instance level, while...
April 11, 2008 5:00 AM
Posted by: Denny Cherry
Back To Basics,
Functions,
SQLFunctions are create little blocks of code. They are fantastic for converting data from one format to another, or for looking up other values based on a lookup. However this comes at a price. That price is CPU power. Doing all these additional lookups can cause extra strain on the database...
April 10, 2008 8:00 PM
Posted by: Denny Cherry
Back To Basics,
SQL,
SQL Server stored proceduresStored procedures are extremely useful objects. Not only do they store T/SQL scripts for later execution, but they also provide us with an extremely important security barrier between the user interface and the database. The security barrier is used to prevent the users from needing SELECT,...
