SQL Server with Mr. Denny:

DNS


November 28, 2007  7:38 AM

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

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, Firewalls, Migration, Reporting

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?

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, Firewalls, Reporting, Wireless

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


October 18, 2007  6:18 PM

Excellent Lock Pages in Memory Blog

Denny Cherry Denny Cherry Profile: Denny Cherry
DNS, i5

Bob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.


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: