Viewing 15 posts - 3,286 through 3,300 (of 7,484 total)
Jeff Moden (8/2/2013)[hrI guess it depends on what you consider to be a "small performance difference". On only a million rows, the difference between 4.9 and 9.2 seconds might...
August 4, 2013 at 10:15 am
Maybe I'm committing an egregious social error by raising something technical in this forum, but sometimes I thing deprecation lists are at least as political as technical, besides which the...
August 4, 2013 at 9:40 am
Steve Jones - SSC Editor (8/2/2013)
August 2, 2013 at 1:46 pm
Nice to see a question on locking - it would be good if technical internals stuff like this turned up more often in QOTD.
The lesson to be taken from the...
August 2, 2013 at 7:13 am
Erland Sommarskog (8/1/2013)
L' Eomot Inversé (2013-07-31)
August 1, 2013 at 12:06 pm
PHYData DBA (8/1/2013)
Also from MSDN article http://msdn.microsoft.com/en-us/library/ms190476(v=sql.110).aspx
Length for a numeric data type is the number of bytes that are used to store the number. Length for a character string or...
August 1, 2013 at 11:50 am
PHYData DBA (8/1/2013)
Hugo Kornelis (8/1/2013)SELECT LEN(@var) implicitly converts @var to string, because that's the only data type supported for LEN. This conversion is independent of the clients' Windows locale setting,...
August 1, 2013 at 11:36 am
Nemeaux (7/31/2013)
So what do you all think about database names as short as 5 characters in length? Which is a standard that is mandated where I work?
Sounds crazy to me,...
July 31, 2013 at 5:05 pm
laurie-789651 (7/31/2013)
July 31, 2013 at 4:52 pm
Erland Sommarskog (7/31/2013)
July 31, 2013 at 4:37 pm
GilaMonster (7/31/2013)
L' Eomot Inversé (7/31/2013)
and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP;
http://msdn.microsoft.com/en-us/library/ms187332.aspx
DBCC CHECKFILEGROUP (Transact-SQL)
Checks the allocation and structural integrity of all tables and indexed views...
July 31, 2013 at 4:26 pm
It's a good question.
It's a bit shocking to see that so far out of just over 600 people about 55 people picked the non-existent and utterly implausible DBCC CHECKCACHE, and...
July 31, 2013 at 9:22 am
PHYData DBA (7/30/2013)
thierry.vandurme (7/30/2013)
Hi Philipthat indeed explains it. Thx a lot! I was almost losing my mind over this 🙂
Chrz
Thierry
Thierry,
That explanation is not correct for TSQL. Style does not...
July 30, 2013 at 1:44 pm
SQLRNNR (7/29/2013)
Jeff Moden (7/29/2013)
July 30, 2013 at 5:18 am
Viewing 15 posts - 3,286 through 3,300 (of 7,484 total)