Viewing 15 posts - 38,926 through 38,940 (of 49,552 total)
shnex (5/25/2009)
Should I use OPTION (KEEP PLAN) to change the recompilation threshold of the temporary table or there are side effects?
There are side effects. Because the plan won't be recompiled...
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
May 25, 2009 at 2:24 am
Jeffrey Williams (5/24/2009)
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
May 24, 2009 at 4:12 pm
winston Smith (5/24/2009)
Is there ANY way to move database files without taking a database offline?
No. Reason is that to move the files, SQL has to not be using them....
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
May 24, 2009 at 4:05 pm
Excellent.
Now make sure that you have regular integrity checks scheduled. No need to specify data purity in them, it's a default once it's run successfully 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
May 24, 2009 at 3:55 pm
If you have 8GB memory, make sure that SQL's max memory setting is set to no more than 6 GB. This is especially important on 64 bit.
What service pack 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
May 24, 2009 at 1:49 pm
Sankar Reddy (5/24/2009)
-- Cached SP's By Execution Count
SELECT TOP (25) qt.text...
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
May 24, 2009 at 1:47 pm
Not that I'm aware of.
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
May 24, 2009 at 1:28 pm
sheetaljain22 (5/23/2009)
sheetaljain22 (5/23/2009)
I am Facing the Same IssuePlzz Help Today is My Last Day Of my Proj
What precisely is the problem? What are you trying to do, what is 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
May 24, 2009 at 12:04 pm
It's cumulative since the server started. I wouldn't just divide by the number of days, that assumes that the IO load is identical every day (which it may not 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
May 24, 2009 at 11:57 am
Steve Jones - Editor (5/24/2009)
Not a bad apology. There's hope.
That's an apology?
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
May 24, 2009 at 11:50 am
Steve Jones - Editor (5/21/2009)
There is a default trace, but I'd guess that it doesn't have information from 3 days back.
It might, depends how active the server is 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
May 24, 2009 at 4:48 am
If it's a select, you'll still get schema stability locks. If it's any form of modification, the nolock will be ignored. Data modifications have to lock.
Why nolock?
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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
May 24, 2009 at 2:21 am
Threads once posted can't be deleted.
Actual thread here - http://www.sqlservercentral.com/Forums/Topic722641-1550-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
May 24, 2009 at 2:09 am
TRACEY (5/23/2009)
SQL Idera tool.............gives these measurements.
Check it's documentation to see if you can find what that's measuring in. It may be bytes, disk sectors, SQL pages, or a...
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
May 24, 2009 at 2:00 am
<sigh>
"I detached the DB, deleted the log file and it won't attach. Backups not working either"
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126304
Head-desk
Why???????????
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
May 23, 2009 at 2:46 pm
Viewing 15 posts - 38,926 through 38,940 (of 49,552 total)