In two minds about this myself. Yes, it would certainly be handy to have these conversion functions in SQL server, but on the other hand, the old mantra of "do...

Nakul Vachhrajani (7/13/2012)

The maximum supported number of logical processors by SQL Server 2008 R2 is 256 logical processors (which is a limit in-turn imposed by the operating system - Windows...

A thread five years old is considered recent? :blink:

Because the "n" means the string is Unicode, so it has two bytes per character; DATALENGTH returns the...

Is there a reason you set a retention period of only 180 minutes? It doesn't give you a lot of leeway if the connection between the primary and secondary servers...

In my experience the DTA tends to recommend covering indexes for practically every query, and if you were to follow its instructions to the letter, you'd end up with a...

Hugo Kornelis (7/11/2012)

In my opinion, it is LEN() that has the strange behaviour here, because it returns the length of the padded version of the string instead of the length...

I'm pretty sure the way Developer is licensed is per user--so you'd need a separate $50 license for each developer, regardless of whether they're all accessing the same instance. However,...

I thought the 4th one would be 8 at first, but since 7, 7, 8, 8, 14, 80 wasn't an option had to go by a process of elimination to...

Pretty confident the answer would be an error, but I had to go and test it because the question specified SQL 2012 and I thought they might have changed it!...

What does that have to do with the clustered index key, though? You certainly can't cover every possible query with the clustered index (unless you have an incredibly simple database),...

The other thing you could do is to set the cell format for the appropriate column *before* pasting the data in. If Excel thinks the column is a text column...

crazy4sql (7/5/2012)Also if you looking for the day of that particular date then you can use day().

For ex, day(getdate()) will return 5 which means Thursday. This counting starts from 0...

I was a programmer long before I had anything to do with SQL. I started coding in BASIC on a ZX Spectrum 30-odd years ago. I've done Pascal, C, C++,...

GilaMonster (7/4/2012)

For seeking, for range scans, for supporting an order by. Not ever for returning rows in the index order without an order by specified. That was quoted a bit...