Viewing 15 posts - 30,016 through 30,030 (of 49,552 total)
Take a look here for all the certifications available for SQL Server. http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
October 13, 2010 at 2:27 am
hallidayd (10/13/2010)
As a start you look at the results of sp_who2 and investigate those process running on spid 50 or less.
Since SQL 2005 the rule that spids under 50...
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
October 13, 2010 at 2:25 am
Nice Marmot (10/12/2010)
Is it now best practice (i.e. least hassle) to leave the master and mssqlsystemresource databases in the default install location?
On SQL 2008 the mssqlsystemresource is in the binn...
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
October 13, 2010 at 2:20 am
MostInterestingMan (10/12/2010)
Note that the DB with the 7gb log file is now in FULL recovery.
You do have log backups scheduled?
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
October 12, 2010 at 4:34 pm
MostInterestingMan (10/12/2010)
But in my situation I need the space back.
Then do a once-off shrink of the log (and only the log) to a reasonable size (not 1). 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
October 12, 2010 at 4:31 pm
WayneS (10/12/2010)
jcrawf02 (10/12/2010)
Wayne, I think you're going to make Jack and Andy very happy with that comment. 🙂
.... wonder if I can be a presenter for my "Comparing Table Variables...
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
October 12, 2010 at 3:47 pm
MostInterestingMan (10/12/2010)
I will shrink the file and set auto shrink on the database options page.
Good idea, if you want to absolutely cripple database performance, fragment your indexes to hell 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
October 12, 2010 at 3:46 pm
MostInterestingMan (10/12/2010)
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
October 12, 2010 at 3:30 pm
No. T-SQL is not stored in the log.
Tried querying the plan cache? If the query was recent, it may still be in 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
October 12, 2010 at 2:12 pm
WayneS (10/12/2010)
Roy Ernest (10/12/2010)
Gail, I thought Gail were working for yourself. I did not know that you were working for some company.
From what I understand, she does - she's 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
October 12, 2010 at 2:10 pm
The Dixie Flatline (10/12/2010)
Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.
Oh this wasn't a planned meeting. This was...
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
October 12, 2010 at 1:45 pm
Michael Valentine Jones (10/12/2010)
GilaMonster (10/12/2010)
Michael Valentine Jones (10/12/2010)
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
October 12, 2010 at 12:55 pm
Post the code? Near-impossible to say anything useful without being able to see and/or run 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
October 12, 2010 at 11:43 am
parthi-1705 (10/12/2010)
Thanks for your replay as it is local i did DBCC CheckDB () WITH No_INFOMSGS.
And? If you don't post the output I can't help you in fixing it.
Actually 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
October 12, 2010 at 11:39 am
Rather than looking at that right now, could you post the full output of checkDB and I can help you with resolving it.
DBCC CheckDB (<Database Name>) WITH No_INFOMSGS, ALL_ERRORMSGS
To find...
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
October 12, 2010 at 10:46 am
Viewing 15 posts - 30,016 through 30,030 (of 49,552 total)