Viewing 15 posts - 151 through 165 (of 199 total)
A good QotD.
In the interest of developing the discussion I'd put my 2 cents down as: if you have a convenient disk location a raw file destination+source is likely easier...
March 3, 2010 at 11:38 pm
benkoskysa (3/3/2010)
... I used a database where the sys.master_files table was empty...
Well, it can't be empty. At the very least you can expect 8 rows from a brand-spankin' new...
March 3, 2010 at 11:30 pm
Hmmm. Either assume the pseudo code has a typo and choose the "right" answer, or take the question literally and choose the "wrong" answer. A 50/50 chance. I'm...
February 25, 2010 at 11:34 pm
ISNUMERIC is more general than CONVERT. The following is also valid (in 2008):
SET @PrincipalAmount = '100e2'
It will convert to float, but not money. With the QotD I was...
February 22, 2010 at 12:32 am
carl.anderson-1037280 (2/11/2010) In our data warehouse, all of our indexed tables use at least one clustered index (as per DBA mandate).
Carl Anderson
Data Architect
Northwestern University EDW
Not sure about a...
February 14, 2010 at 6:48 pm
Very nifty datatype to know if you ever need to store an object name.
S.
February 11, 2010 at 11:15 pm
A good question to remind us of something we all might forget: WHERE isn't just used after FROM.
S.
February 10, 2010 at 11:07 pm
There's so much that has an impact in answering a query about "dev's as DBA's" that there really is no straight answer. I've found that companies need to grow...
February 10, 2010 at 7:11 pm
An interesting question, but a very roundabout way of asking "Does SQL Server 2005 support OPTION (...) hints within Views?" 😉
S.
February 9, 2010 at 11:09 pm
Triggers are for INSERT, UPDATE, or DELETE only.
That is true, but not (I think) the purpose of today's QotD.
DELETE operates on the individual rows of a table, whereas TRUNCATE operates...
February 8, 2010 at 7:18 pm
Ah, a straight out knowledge question! You either know it or you don't. But I'm glad to have had my understanding of report snapshots pointed a little more...
February 3, 2010 at 6:45 pm
I thoroughly enjoyed this question. After the raft of recent questions with debatable answers, this had no 'trick' and tested several concepts, ie:
1) Temp tables can be referenced by...
February 3, 2010 at 6:33 pm
As soon as I saw the question I thought it would be contentious. But my default out-of-the-box SQL 2005/2008 model db defaults to 3+1, ie: 4. I set...
January 21, 2010 at 12:10 am
There's been a bit of a biff about QoD answers lately, but there is really only one answer today as "this is an exception" will be output and only one...
January 20, 2010 at 12:39 am
Hi All,
Some further information: changing the witness on the new pair also updates the witness on the old, non-existant pair. Is there any way that SQL Server 2005 can...
November 3, 2009 at 12:19 am
Viewing 15 posts - 151 through 165 (of 199 total)