Viewing 15 posts - 2,416 through 2,430 (of 3,348 total)
When will people ever learn about date formats?
The correct answer ("depends on the locale settings") was not listed, so I had to throw a coin to choose between theory a...
March 18, 2011 at 8:08 am
Durai, what are you using as the client? SSMS supports this since version 2005 (maybe even earlier). I don't know about the other tools.
February 15, 2011 at 5:54 am
michael.kaufmann (2/15/2011)
February 15, 2011 at 4:15 am
I don't know if the explanations in BOL are correct or not, but here is the deal.
The ANSI standard says that double quotes should be used to delimit identifiers, and...
February 15, 2011 at 4:04 am
Mike Dougherty-384281 (2/11/2011)
Would you care to voice an opinion on whether this kind of heavy-handedness is a good idea?
I see no problem wirth it. I would if I could not...
February 11, 2011 at 11:40 am
sknox (2/11/2011)
which shows that SQL Server 2008+ has a hardcoded process at startup that attaches the resource database from the same...
February 11, 2011 at 9:45 am
UMG Developer (2/10/2011)
I'm surprised at the number of people that thought DataDude was the name that hadn't been used, that is what I had heard it...
February 10, 2011 at 11:50 am
Nadrek (2/10/2011)
Rayven (2/7/2011)
Agencies can be sods. I interviewed a guy for one position and when I asked him about his experiences with one...
February 10, 2011 at 11:48 am
UMG Developer (2/8/2011)
Thanks for the question, I haven't used SQLCMD mode before, do many people use it?
I develop an application that generates SQL scripts. These scripts should be tested on...
February 8, 2011 at 5:07 pm
Toreador (2/7/2011)
I wonder why they are withrawing this procedure?
If I have to make a guess, it is probably because over the past years, there has been a consistent move away...
February 7, 2011 at 5:52 am
Frankly, I am a bit surprised by this editorial. I'll just be blunt and say that it could -no, should- have been shortened to just the first and most of...
February 7, 2011 at 5:33 am
SanDroid (2/4/2011)
Does the Tran Log always get truncated after a checkpoint occurs,...
February 4, 2011 at 8:02 am
Good question, but the explanation is overly simplistic. There are other reasons for a checkpoint to not clear a VLF.
I chose the correct answer because I considered the scenario of...
February 4, 2011 at 1:30 am
SanDroid (2/3/2011)
There really isn't the concept of a clustered index that determines the physical order of records. Internally, Oracle uses a multi-part identifier called a ROWID to...
February 3, 2011 at 2:20 pm
Viewing 15 posts - 2,416 through 2,430 (of 3,348 total)