Viewing 15 posts - 646 through 660 (of 928 total)
Somebody is about to submit an astounding piece of homework http://www.sqlservercentral.com/Forums/FindPost1244144.aspx
January 31, 2012 at 2:48 am
Loundy (1/31/2012)
Alternatively you could use the sql MERGE statement to MERGE table1 into table2, then MERGE table2 into table3 then MERGE table3...
January 31, 2012 at 2:37 am
Specifically you need to look at INNER JOIN, and the ID column is what you would use in the 'ON' part of that command.
Seriously, read up on this area (you...
January 31, 2012 at 2:34 am
You need to read about JOIN - http://msdn.microsoft.com/en-us/library/ms191517.aspx and look at the column that each table has in common.
January 31, 2012 at 2:14 am
I'm about to register for PASS 2012 (I have to register now as I'm paying for myself and it doesn't get cheaper as it gets nearer) and I was wondering...
January 26, 2012 at 1:35 am
Count the number of '(' and ')' that you have in those statements. You have 6 '(' but only 5 ')'. It is complaining about the '100,' so try '100),'...
January 18, 2012 at 1:44 am
You might have a misunderstanding of what the Log file contains. From the way you asked your question I think you believe the Log backup contains the state of the...
January 13, 2012 at 2:25 am
Very similair to Gail's description, but with pictures:
December 28, 2011 at 4:24 am
The Night Before Startup
'Twas the night before startup
and all through the house
not a program was working,
there clicked not a mouse
The users were nestled all snug...
December 23, 2011 at 5:23 am
A good start for these questions is the 'Stairways' series on Transaction Log Management:
December 12, 2011 at 7:09 am
You two are far more devious than I - but now I'm wondering...
December 7, 2011 at 3:57 am
If I recall correctly, one of the finalists wants to be in space because, as a six-year old he said such a thing and was laughed at by his teacher....
December 7, 2011 at 3:09 am
Search for 'Business Days' on this site - it produces a large list of articles tackling this problem in a variety of ways.
December 7, 2011 at 2:23 am
Fascinating question Hugo, thank you.
I had to re-read 'Formatting Your FROM Clause' in the first volume of 'MVP Deep Dives' to answer it. Knowing where to find the answers is...
December 6, 2011 at 8:49 am
alaguganesha1983 (11/30/2011)
T-SQL , Stored Procedures & Performance Tuning:I need clear idea and good example for the above topic i mentioned.
help me with this please.
That's quite a request you've made there...
November 30, 2011 at 1:41 am
Viewing 15 posts - 646 through 660 (of 928 total)