Viewing 15 posts - 36,586 through 36,600 (of 49,562 total)
CirquedeSQLeil (9/3/2009)
hmmm - guess he didn't want to post his codehttp://www.sqlservercentral.com/Forums/Topic782432-146-1.aspx
does that mean he has learned how to research the issue and troubleshoot?
Well, he posted it then deleted it.
I...
September 3, 2009 at 3:45 pm
What's the wait_type and wait_resource?
September 3, 2009 at 2:25 pm
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/Topic782432-146-1.aspx
September 3, 2009 at 2:23 pm
WayneS (9/3/2009)
GilaMonster (9/3/2009)
September 3, 2009 at 2:13 pm
It's not pretty, but it's not too bad. After all, SQL 2005 has a permanently running trace of its own. Trick is to keep the events and the columns to...
September 3, 2009 at 1:04 pm
Best thing would be SQLTrace. Set up a server-side trace and run it for as long as necessary.
p.s. Sure you want your email address and phone no visible on a...
September 3, 2009 at 12:55 pm
Dave Ballantyne (9/3/2009)
Try Clearing sqlserver's cache by using DBCC DROPCLEANBUFFERS.
Only if it's a dev/test server. Emptying the data cache on a busy production server's likely to cause performance problems and...
September 3, 2009 at 12:46 pm
George Nak (9/3/2009)
Actually the size has never grown above 4 Gbs for this db.
If that's the case, make the starting size 4 GB, the growth around 100MB and change the...
September 3, 2009 at 10:21 am
I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.
September 3, 2009 at 8:17 am
xnleiden (9/3/2009)
So I believe this "stopping" action caused the database to put into a recovery mode.
No, that wouldn't do it. That would just cause a transaction rollback. To have the...
September 3, 2009 at 8:14 am
So add the name and surname to the SELECT and Group By. The correct table is already in the query.
September 3, 2009 at 7:52 am
Was the server restarted?
Typically this happens when the server is shut down suddenly, SQL doesn't have time to close the databases cleanly so they have to go through restart-recovery when...
September 3, 2009 at 7:41 am
TheSQLGuru (9/3/2009)
I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. 🙁
There was a whole presentation on NUMA...
September 3, 2009 at 7:38 am
Viewing 15 posts - 36,586 through 36,600 (of 49,562 total)