November 28, 2007 7:38 AM
Posted by: Denny Cherry
Data Types,
SQL,
Uni-codeIf you have looked at pretty much any Microsoft provided T/SQL code you have probably seen an N in front of a string value when setting a variable much like this.
SELECT *
FROM...
November 26, 2007 7:35 AM
Posted by: Denny Cherry
Data Types,
SQL,
Uni-codeThe path that Microsoft is going says yes. They are moving all there samples and defaults to using uni-code. In reality uni-code may not be needed in your environment. If you are storing only Latin characters (the US alphabet characters) then you probably don't need to store uni-code...
November 19, 2007 8:00 AM
Posted by: Denny Cherry
Beta,
SQL,
SQL Server 2008Microsoft announced at TechEd in Barcelona, Spain that the SQL Server 2008 November CTP would be made available this month. Read more here.
---> Update...
Microsoft...
November 15, 2007 7:23 PM
Posted by: Denny Cherry
Article,
SQL,
Statistics,
T/SQLI've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...
November 5, 2007 8:00 AM
Posted by: Denny Cherry
Recovery,
SQLIf you have ever seen the BACKUPTHREAD wait type in the sysprocesses table or sp_who2 output and wondered what it is, I have found the answer.
The basic explanation is "Used when waiting for a backup thread to complete. Wait time may be very long (minutes, hours)." Basically what this means...
October 31, 2007 6:09 AM
Posted by: Denny Cherry
Service Broker,
SQLService Broker is a transaction message queueing system build into Microsoft SQL Server. It provides you with in order, guaranteed single read, message processing that is handled and managed with T/SQL code. This makes it extremely easy to send and process messages either within a single...
October 29, 2007 8:00 AM
Posted by: Denny Cherry
Execution Plan,
SQLTake your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it. It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.
October 25, 2007 6:03 PM
Posted by: Denny Cherry
Article,
SQL,
Statistics,
T/SQLMy next tip on SQL Server Statistics has been published on SearchSQLServer.com entitled
October 24, 2007 5:09 AM
Posted by: Denny Cherry
DataManagement,
sp_who3,
SQL,
T/SQLI've published this before over on tek-tips.com, but I figured that I'd republish it here as well. I've written an update for sp_who2 which I call sp_who3. It can be most useful when trying to diagnose slow running queries as it can provide a wealth of information in a single...
