Viewing 15 posts - 3,286 through 3,300 (of 7,483 total)
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
Nice question. Pity there was no reference in the explanation to anything that supported the answer 12 rather than 14, but as it's shown up in the discussion I...
July 30, 2013 at 5:08 am
Viewing 15 posts - 3,286 through 3,300 (of 7,483 total)