Viewing 15 posts - 3,166 through 3,180 (of 7,484 total)
Koen Verbeeck (9/3/2013)
ChrisM@Work (9/3/2013)
Jan Van der Eecken (9/3/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level...
September 3, 2013 at 5:54 am
Rune Bivrin (9/3/2013)
L' Eomot Inversé (9/3/2013)
Rune Bivrin (9/3/2013)
Or even try this, where NEWID() is completely eliminated from...
September 3, 2013 at 5:32 am
Rune Bivrin (9/3/2013)
Or even try this, where NEWID() is completely eliminated from the second query.
-- 1
SELECT ROW_NUMBER()...
September 3, 2013 at 3:44 am
Nice clear and easy question (assuming the last option "no difference" means "no difference in what they the language specification says they return" - if it means what it actually...
September 3, 2013 at 3:37 am
The most common cause of this error, in my experience, is that someone has failed to mark a trigger "not for replication" that needed to be so marked. The...
September 2, 2013 at 3:47 pm
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
I like...
August 31, 2013 at 9:58 am
The description od what is calculate says number of times a city is visited is calculated; the sample data and expected results are completely different from this; for example a...
August 30, 2013 at 6:18 pm
If this is a more general thing than just the one case, maybe something like
SELECT
MIN([NAMES]) AS [NAMES], [NUMBER]
FROM
( SELECT [CV].[dbo].[T40]
...
August 30, 2013 at 3:45 pm
Brandie's right. You have to understand what the nontechnical people do, what their concerns are, what there culture is, so that you can express your technical information in terms...
August 30, 2013 at 2:22 pm
Brandie Tarvin (8/29/2013)
K. Brian Kelley (8/29/2013)
August 30, 2013 at 2:15 pm
SQLRNNR (8/28/2013)
In addition, another vote for taking greater care and caution when attempting to do a restore.
The server trigger may work, but I agree with...
August 30, 2013 at 2:09 pm
The reason that you are getting duplicate IDs is that at least one of your tables has more than one row with a given ID_NUM and some of the other...
August 30, 2013 at 2:00 pm
Brandie Tarvin (8/30/2013)
Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now...
August 30, 2013 at 12:43 pm
Viewing 15 posts - 3,166 through 3,180 (of 7,484 total)