Viewing 15 posts - 34,441 through 34,455 (of 49,552 total)
You have to enter a key before you can activate it. There's a couple of weeks grace period, iirc.
January 25, 2010 at 6:35 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 25, 2010 at 6:16 am
Gianluca Sartori (1/25/2010)
Did you use your crystal ball, Gail? 🙂Sorry for the broken link, I'll fix it.
Didn't need to (and I think Grant has the crystal ball this week). I...
January 25, 2010 at 6:15 am
Fozzie (1/25/2010)
GilaMonster (1/25/2010)All I find that prefixing stored procedures does is make it harder to locate them and navigate to them in Object Explorer
If they've all been prefixed with...
January 25, 2010 at 6:13 am
Run the query with the 'include actual execution plan' option on and you'll be able to see exactly what order the operations are done.
January 25, 2010 at 6:04 am
I expect the link is supposed to go here: http://www.sqlservercentral.com/Forums/Topic852906-338-1.aspx
It's our PhD candidate again.
January 25, 2010 at 6:03 am
dhamilton-905368 (1/25/2010)
I do believe that most DATABASES (something most people don't do!) should be prefixed with a "db"
Why?
most tables should be prefixed with a "tbl"
Why?
and most stored procedures (which I...
January 25, 2010 at 3:30 am
Raghavender (1/25/2010)
SQL server has special mechanism which resolves the dead lock issue automatically by itself only.
It does, but that doesn't mean that the root cause should not be fixed.
January 25, 2010 at 3:12 am
I think the error messages are very clear....
sudhakara (1/25/2010)
January 25, 2010 at 3:09 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
January 25, 2010 at 3:08 am
I'm assuming you didn't read that article.
Ok, so based on that sample data, what do you want the query to return. (actual values please, not a description)
January 25, 2010 at 1:06 am
I'm assuming you didn't read that article. Table definitions, sample data and desired output please.
January 25, 2010 at 12:38 am
UPDATE Test SET RealRank = 1
WHERE GroupID IN (SELECT GroupID FROM dbo.Test WHERE [Rank] = 1)
Thanks for the sample data. In future could you perhaps leave off the database...
January 25, 2010 at 12:17 am
Why are you using a temp table?
Just a comment, there's no use in putting an Order By on an insert, unless the target table has an identitiy
January 25, 2010 at 12:13 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If may also be worth reading http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/ and...
January 25, 2010 at 12:07 am
Viewing 15 posts - 34,441 through 34,455 (of 49,552 total)