Viewing 15 posts - 41,746 through 41,760 (of 49,552 total)
Since you have the execution plan that you want to force, try using the OPTIOn (USE PLAN ...) hint. That guarantees that the baseline query will never change plan.
The disclaimer...
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 14, 2009 at 8:21 am
A snapshot is a sparse file. The size of the file appears to be the size of the database, but it hasn't reserved that much space on the disk. The...
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 14, 2009 at 8:07 am
If you're on SQL 2005, and I assume you are because this is the SQL 2005 forum, use traceflag 1222 rather than 1204. It produces a lot more output and...
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 14, 2009 at 8:04 am
Look up BACKUP LOG in Books Online.
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 14, 2009 at 8:01 am
For testing purposes only!
Hints should not be used in production code, unless you really, really know what you're doing and are 120% certain you know better than the optimiser.
Right, now...
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 14, 2009 at 8:01 am
It would be nicer it it was a script that I could just run to create the tables and insert the data, but it will do. I probably won't be...
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 14, 2009 at 12:58 am
Sandra Skaar (1/13/2009)
One question - is it possible that SQL Server's alerting is a bit wacky when the server is virtual, and on a SAN to boot? Just curious.
No. If...
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 13, 2009 at 11:34 pm
Can you please connect to that server from a querying tool and run the following. Post all of the outputs
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
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 13, 2009 at 11:24 pm
madhu.arda (1/13/2009)
I did this already DBCC SHRINKFILE (N'MSDBLog' , 500) . But the log file size still showing as 17Gb after shrinking the file!!!
How full is the log file? Have...
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 13, 2009 at 10:58 pm
Avinash (1/13/2009)
you can restore the backup in a different box that is taken before the update.
Except that he doesn't have a backup.
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 13, 2009 at 10:56 pm
shnex (1/13/2009)
I should be kicked a little for the way I posted 😀I will write the tables and the desired output
🙂 Don't worry. We only kick repeat offenders. 😉
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 13, 2009 at 1:34 pm
shnex (1/13/2009)
Is there a better solution?
I don't know. There probably is, but you haven't given us enough information to help you.
Please post table definitions, sample data and desired output. Read...
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 13, 2009 at 1:23 pm
IOs are one area that cause major problems for virtual servers.
How many virtuals are hosted on that physical server? How do those virtual server's drives map to the physical server'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 13, 2009 at 1:05 pm
shnex (1/13/2009)
I hope this is more clear.
Not really. Can you please read the links in Jack's sig.
Why do you want a loop?
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 13, 2009 at 12:26 pm
bsrlong (1/13/2009)
Gee, and I signed up for this.
I'm sorry you find this site a waste. Please feel free to ask Steve for a refund.
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 13, 2009 at 12:19 pm
Viewing 15 posts - 41,746 through 41,760 (of 49,552 total)