Viewing 15 posts - 40,726 through 40,740 (of 49,571 total)
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic666149-24-1.aspx
February 28, 2009 at 6:01 am
sudhakara (2/28/2009)
hi thnks ur reply but not able to access this link ..can u give me the correct one ?
Works fine for me.
February 28, 2009 at 5:56 am
kevinsql7 (2/27/2009)
Thanks. I had to put the tablename in single quotes.
Yup. The example I posted was with a variable as a parameter. A string literal would go in quotes
February 27, 2009 at 12:50 pm
DBCC UPDATEUSAGE
CheckDB with the data_purity option
Change page verification to CheckSum (from Torn page)
February 27, 2009 at 12:34 pm
Max (2/27/2009)
Always wondered of there was an overhead with using equal aliases though.
No, but it is deprecated syntax
February 27, 2009 at 12:23 pm
kevinsql7 (2/27/2009)
OBJECT_ID seems to be unique to SQL Server 2005.
Most certainly not. It's been around since SQL 7, if not before.
http://msdn.microsoft.com/en-us/library/aa276843(SQL.80).aspx
Please post SQL 2000-related questions in the SQL 2000...
February 27, 2009 at 12:18 pm
kmarshall (2/27/2009)
I was just trying to keep it simple.
Can you post the full query? Simplifying it does not help when it's a performance issue.
Since it's 2000, the method to post...
February 27, 2009 at 12:16 pm
ritesh (2/27/2009)
Any information...
February 27, 2009 at 9:28 am
shri_sastry (2/27/2009)
This is SQL2000 server.
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
February 27, 2009 at 9:24 am
kmarshall (2/27/2009)
Sorry about the icons, they've taken the place of the colon and open braket characters.
Right click the plan, select save as. Save as a .sqlplan file, zip and attach
That's...
February 27, 2009 at 9:22 am
kevinsql7 (2/27/2009)
Two questions:How may I list (query) the index_id and index_name for a table?
If you're asking for all the indexes (with name and id) on the table then
select index_id, name...
February 27, 2009 at 9:16 am
Be careful even with the truncate_only. Databases tend to grow, it's in their nature, and shrinking one will just result in it growing again (unless it's a static database). Lots...
February 27, 2009 at 9:13 am
winsysadmin (2/27/2009)
Any ideas?
I don't suppose you have a clean backup?
You've already lost data by running repair. Some of the errors couldn't be repaired the first time, not unusual.
If you...
February 27, 2009 at 8:51 am
Are you getting deadlocks, or is this a theoretical question?
If you are, use traceflag 1222 to write the deadlock graph into the error log. Post the error log, the procedures...
February 27, 2009 at 2:19 am
Jeff Moden (2/26/2009)
[Great minds think alike... 😛 modeled very close to what the query designers in 2k and 2k5 spit out... makes it easier for "coders" to comply.
Not that...
February 27, 2009 at 2:16 am
Viewing 15 posts - 40,726 through 40,740 (of 49,571 total)