SQL Server with Mr. Denny:

November, 2007

1

November 30, 2007  8:00 AM

New Article: Tricks to increase SQL Server query performance



Posted by: Denny Cherry
Article, T/SQL, Temp Tables

I've published a new tip over on SearchSQLServer.com entitled "   Bookmark and Share     0 Comments     RSS Feed     Email a friend

November 28, 2007  7:38 AM

What’s up with the N in front of string values?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

If 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

Should I be using uni-code data types?



Posted by: Denny Cherry
Data Types, SQL, Uni-code

The 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 21, 2007  7:00 AM

Thanksgiving is tomorrow, spend the day with family.



Posted by: Denny Cherry
Family

I know that this is normally a technical blog, but with the US Thanksgiving day holiday coming tomorrow I wanted to be sure to point out that time needs to be made out of our busy work schedules to make sure that we spend time with our families.  It's very important that we find a good balance...


November 19, 2007  8:00 AM

Microsoft Announces SQL Server 2008 November CTP



Posted by: Denny Cherry
Beta, SQL, SQL Server 2008

Microsoft 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

New tip published: Update SQL Server table statistics for performance kick



Posted by: Denny Cherry
Article, SQL, Statistics, T/SQL

I've published a new tip over at SearchSQLServer.com entitled Update SQL Server table...

Bookmark and Share     0 Comments     RSS Feed     Email a friend


November 14, 2007  8:00 AM

Make sure that your environmentals are setup correctly



Posted by: Denny Cherry
DataCenter

When you setup your data center, something that seams to be getting overlooked these days is the data center environmentals.  We all know that we need batteries and a generator for the power to keep the servers online, and that we need AC to keep them cool.  But I've seen a disturbing number of...


November 12, 2007  7:32 AM

What’s the benefit of 64bit?



Posted by: Denny Cherry
Processor architecture

There are a several benefits of moving to 64bit hardware. 64bit hardware supports more CPUs than 32bit hardware. In addition the 64bit hardware can access way more memory than 32bit hardware. 64bit hardware can use up to 2 TB of data, while 32bit hardware will typically max out at 64 Gigs. What...


November 7, 2007  8:13 AM

Making time for the family.



Posted by: Denny Cherry
Family

Working in IT can be a fun and exciting career, however it can also be an extremely demanding one.  When working in IT you have to find a balance between work and family.  Without finding that balance you'll end up with either a very unhappy employer or a very unhappy family. Myself I am very...


November 5, 2007  8:00 AM

What is the BACKUPTHREAD wait type?



Posted by: Denny Cherry
Recovery, SQL

If 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...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: