Viewing 15 posts - 28,246 through 28,260 (of 49,552 total)
Again, are you sure you're checking in the right database? ObjectID are database specific, profiler will pick up plans for the entire instance.
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
January 23, 2011 at 3:02 am
sql_butterfly (1/22/2011)
2. Is this correct:SELECT * FROM TableA
WHERE ColA <> 64
Think about it, if you want...
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
January 23, 2011 at 2:01 am
600 000 rows is a lot of data to read off disk and send over the network.
Why 600 000 rows? What are you going to do with it?
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
January 23, 2011 at 1:59 am
Do you still have the SQL 2000 DB?
I have a feeling that this requires script, export, recreate to fix.
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
January 23, 2011 at 1:54 am
Are you checking the object_id in the right database? Object_id is just to identify the procedure and, if you have the text you already know what the procedure is. It'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
January 23, 2011 at 1:51 am
sqldba_icon (1/22/2011)
No i did not, i cant clear because i am using sql 2005 edition and it will clear cache for all.
You're testing on a dev or test server...
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
January 23, 2011 at 1:50 am
Tom.Thomson (1/22/2011)
But, I guess someone will ask so it may as well be me, which sport is it a black belt for?
Steve does karate iirc
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
January 23, 2011 at 1:47 am
Did you clear the proc cache before testing? If not, the proc could have been there from earlier executions
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
January 22, 2011 at 12:29 pm
I believe the DMVs you need are sys.database_principals and sys.role_members
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
January 22, 2011 at 1:18 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1051921-2571-1.aspx
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
January 22, 2011 at 1:14 am
Easier question would be what are the similarities, because the answer to that would be "None"
Row number assigns sequential numbers to a column in a resultset, based on what is...
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
January 22, 2011 at 1:13 am
What does the usecounts column say? If it says 3 then the procedure was executed 3 times. If it says 1 then the procedure was executed once.
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
January 22, 2011 at 1:11 am
sqldba_icon (1/21/2011)
My goal is to findout how many different plans are genrated for each procedure.
One and only one. A procedure can only have one plan in cache at a time...
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
January 21, 2011 at 1:42 pm
As Gus said "If you issue a rollback command, it will roll back the WHOLE transaction, including both the nested procedure and the outer procedure." That's true regardless of where...
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
January 21, 2011 at 1:39 pm
rik gretzinger (1/21/2011)
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
January 21, 2011 at 1:36 pm
Viewing 15 posts - 28,246 through 28,260 (of 49,552 total)