Viewing 15 posts - 40,126 through 40,140 (of 49,552 total)
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic685614-265-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
March 28, 2009 at 2:40 pm
Kit G (3/27/2009)
Activity on the Thread seems to have diminished. Should I be worried? Is THE THREAD executing its plan to take over the world and that's 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
March 28, 2009 at 6:53 am
Gift Peddie (3/27/2009)
That is a better book the worst is a none SQL Server book but still Microsoft press an exam prep book comes with 89 pages errata. I...
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
March 28, 2009 at 6:48 am
Krishna (3/27/2009)
1.) There should be at least one clustered index for a table which should be Narrow, ever-increasing, unique
At least one?
5.)Think about Covering indexes to cover all the columns retrieved...
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
March 27, 2009 at 2:05 pm
Do not ever use the profiler gui when tracing busy production servers. It can kill th server. I've done that twice.
There's an article at Simple Talk that shows how to...
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
March 27, 2009 at 1:54 pm
What did you set the fill factor for when you reindexed? (If that's what the maint plans are doing. Impossible to tell from the commands you postd)
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
March 27, 2009 at 1:46 pm
Marios Philippopoulos (3/3/2009)
I run the following to get the object name:
SELECT object_name(99)I get the following: ALLOCATION
It's one of the GAM/SGAM/PFS pages. One of the allocation structures of the database.
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
March 26, 2009 at 10:48 pm
GilaMonster (3/26/2009)
Three days of major internet connectivity issues and every tech I speak to wants me to restart the machine and reset the modem.
Then, tonight, the crowning glory.
The error 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
March 26, 2009 at 10:44 pm
GSquared (3/26/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
March 26, 2009 at 2:22 pm
Luke L (3/26/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
March 26, 2009 at 2:19 pm
GSquared (3/26/2009)
Sounds like my last call to tech support.Me: My computer won't POST
....
I wouldn't have bothered in that case.
But then, I built my desktop myself, so for the PC...
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
March 26, 2009 at 2:05 pm
Oh, I forgot one thing.
He asked me to run ipconfig while I was not connected, and then sounded puzzled when I read back a list of disconnected adaptors and connections.
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
March 26, 2009 at 2:01 pm
prvreddy (3/26/2009)
Hi guys,Please tell me about dba dailly activities.Because tommorow onwards i have to attend interviews.
Thanks in advance
If you're applying for a job as a DBA, then you should...
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
March 26, 2009 at 1:48 pm
Darren.Siegert (3/26/2009)
His action was to run a shrink database command and then reduce the allocated free space by 50%.
Rebuild all of your indexes (perhaps after growing the file by 20%...
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
March 26, 2009 at 1:45 pm
AAaaahhhhh!!!!!!!
Three days of major internet connectivity issues and every tech I speak to wants me to restart the machine and reset the modem.
Then, tonight, the crowning glory.
The error 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
March 26, 2009 at 1:37 pm
Viewing 15 posts - 40,126 through 40,140 (of 49,552 total)