Viewing 15 posts - 46,501 through 46,515 (of 49,552 total)
dbaInTraining (5/19/2008)
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 20, 2008 at 12:19 am
A heap is a table without a clustered index. It may or may not have nonclustered indexes on it. You can rebuild nonclustered indexes that are on a heap, but...
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 20, 2008 at 12:11 am
What does the SQL error log say about the reason the database is suspect? There should be some evidence in there.
Be aware that if you recreate msdb, you will lose...
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 20, 2008 at 12:08 am
Looks about right.
I wouldn't worry about splittng files/filegroups unless you're noticing some form of IO contention
high numbers of pending IOs within SQL, high disk queue length (though that counter's fairly...
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 20, 2008 at 12:04 am
GSquared (5/19/2008)
perhaps more importantly, I'm seriously bored and this job is going nowhere slowly.
That's the no.1 reason I gave my boss when I told him I would be leaving...
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 20, 2008 at 12:02 am
Michael Earl (5/19/2008)
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 20, 2008 at 12:00 am
Matt Miller (5/19/2008)
(it's also a one-way ticket as I recall, so you can't "downgrade").
Compat mode can be changed up and down, no issues. All that happens if you drop...
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 20, 2008 at 12:00 am
More space. It's a second copy of the index. It will also mean more overhead on insert/update/delete as both indexes will have to be updated, rather than just one.
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 19, 2008 at 7:46 am
You can read the tran log manually, but it's very hard to understand.
SELECT * from fn_dblog(null, null)
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 19, 2008 at 7:37 am
SQL 2005?
You may have some luck with the ROW_NUMBER function. Try partition by PER_ID, order by Sch
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 19, 2008 at 7:32 am
mobasha (5/18/2008)
then update thier statistics with full scan.
thats only if u want to gain some time...
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 19, 2008 at 7:23 am
You could run a server-side trace, using the sp_trace* procs. It's very light weight, much lighter than the profiler front end. You can get profiler to script out the trace...
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 19, 2008 at 7:19 am
Make sure you're read this:
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
SQL does not use 1 thread for I/O per data file.
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 19, 2008 at 7:05 am
It could be that you're getting a lock escalation to a table lock. Readpast only goes past page and row locks. A table lock will still block it.
I have no...
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 19, 2008 at 5:39 am
Down in my part of the world, skilled people are leaving for Australia and New Zealand at an ever-increasing rate. 2 friends of mine (both skilled IT people) have left...
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 19, 2008 at 5:29 am
Viewing 15 posts - 46,501 through 46,515 (of 49,552 total)