Viewing 15 posts - 27,706 through 27,720 (of 49,552 total)
The other two cases I will use table variables are:
1) When the table variable is not joined to any other tables for the final query. Maybe it's used to dump...
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 16, 2011 at 1:38 pm
Tell them to get someone in who at least knows SQL, preferably knows the database structure as well. Since you know neither, anything you do could easily break things while...
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 16, 2011 at 1:36 pm
Good question. I can't answer that, you're the only one who can.
Was the maintenance plan scheduled, running and succeeding?
What was the log_reuse_wait_desc in sys.databases for that database/
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 16, 2011 at 10:05 am
The warning triangle is saying there are statistics missing. Update stats only updates existing stats, it won't add new ones.
Is auto_create_stats on? What's the object that the warning is on?
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 16, 2011 at 10:02 am
Please note: 5 year old thread.
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 16, 2011 at 10:01 am
That completely depends on what data is in the database. There's no simple answer to that. Is there no SQL person there?
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 16, 2011 at 9:58 am
GSquared (2/16/2011)
I blame Wayne. Execution at noon.
Who's noon?
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 16, 2011 at 7:39 am
GSquared (2/16/2011)
Or maybe another iguana picture.
There's an idea...
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 16, 2011 at 7:35 am
Please, please, please don't run scheduled shrinks. If you explicitly truncate the log (which you can't on SQL 2008) you will need to take another full backup before you can...
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 16, 2011 at 7:31 am
SKYBVI (2/16/2011)
also, u can right click on server, reports-- standard reportsand then see the --Top queries by average CPU time...and other more information.
Regards,
Sushant
That uses the DMVs that Grant mentioned earlier
Another...
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 16, 2011 at 7:28 am
Ian Scarlett (2/16/2011)
Grant Fritchey (2/16/2011)
but I think I'm right on this one if implicit transactions are on.
I also thought that if you executed a procedure on a connection with implicit...
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 16, 2011 at 7:18 am
Grant Fritchey (2/16/2011)
And now it's a new one. It was time to change.
Ooh. Beware the wizard. Swift to anger.
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 16, 2011 at 7:10 am
Please, please do some reading before you start playing with encryption. If you don't know how or why a script works, you shouldn't just be running 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
February 16, 2011 at 7:08 am
If implicit transactions are on, the transaction begins when the first statement/modification occurs (I'm not sure which) and commits when an explicit COMMIT TRANSACTION statement runs. All that implicit transactions...
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 16, 2011 at 7:07 am
Brandie Tarvin (2/16/2011)
So, back to the statement you made right before this, how does the crash recovery cause further damage to a database that's already marked suspect?
It won't. Suspect 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
February 16, 2011 at 6:48 am
Viewing 15 posts - 27,706 through 27,720 (of 49,552 total)