Viewing 15 posts - 40,711 through 40,725 (of 49,552 total)
Max (2/27/2009)
Always wondered of there was an overhead with using equal aliases though.
No, but it is deprecated syntax
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 12:16 pm
ritesh (2/27/2009)
Any information...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 2:16 am
Asha Richardson (2/26/2009)
INSERT @OrdersSELECT @OrderId, ProductId, (Quantity * UnitPrice) As ItemTotal
FROM [Order Details]
WHERE @OrderID IN (select orderID from @CaracasOrders)
Use =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 2:08 am
Or detach, copy files, attach. Either will work
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 1:58 am
Can you explain a bit more what you're trying to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 1:53 am
sqlserverdba.dba (2/27/2009)
Thanks. But i need to run it on on-going basis. Will this not cause an overhead on performance if I run daily?
Not if you do it properly. Server-side trace...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 27, 2009 at 1:52 am
Viewing 15 posts - 40,711 through 40,725 (of 49,552 total)