Viewing 15 posts - 4,156 through 4,170 (of 5,843 total)
2000 record per second steady state capabilities is reasonably high, even in today's world. There are MANY things that can cause your throughput to fluctuate, chiefly among them are...
February 25, 2010 at 6:51 am
I wouldn't recommend SELECT * without a WHERE clause for this because it could bring back billions of rows of data. SELECT TOP 1.. will suffice with the TABLOCKX...
February 23, 2010 at 6:57 am
1) I recommend getting a book or two on administering sql server, or find a course or two to take.
2) with only 2GB on the server, if NOTHING else is...
February 23, 2010 at 6:51 am
Andrew Gothard-467944 (2/22/2010)
TheSQLGuru (2/22/2010)
Boy, if I had a nickel for every time I have seen this problem posted in a forum!! :w00t:
Your trousers would be terribly uncomfortable and weigh...
February 22, 2010 at 10:21 am
Thankfully those are some old dates there and (hopefully) newer machines won't have those problems! I personally don't have much of a warm and fuzzy about HPs firmware and...
February 22, 2010 at 10:09 am
Chris Kitchen (2/22/2010)
Hi,I couldn't see a link to the articles in your reply, would you mind posting again?
Many thanks,
Chris
There's a very good reason why you didn'g see the link, but...
February 22, 2010 at 9:26 am
Boy, if I had a nickel for every time I have seen this problem posted in a forum!! :w00t:
February 22, 2010 at 9:11 am
I use this article (and the two follow-on ones) as my Bible for troubleshooting/resolving deadlocks:
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
February 22, 2010 at 9:10 am
Some very interesting discussions on this thread - wish I had had the time to pop in before it had run it's course!
By the way, I have definitely seen this...
February 22, 2010 at 8:57 am
Glad you were able to resolve your problem! Seems there really is a reason it is 'required' to make sure your firmware and drivers are topped off! I...
February 22, 2010 at 8:51 am
Paul White (2/19/2010)
Thanks for the great feedback there Jon. CLR is definitely a superior option to extended stored procedures!Paul
But in order to do things that are done in many...
February 19, 2010 at 9:46 am
Ol'SureHand (2/18/2010)
Just discovered this happening on our brand new SQL2005 64-bit Standard installation.
Every morning at about the same time IO takes longer than 15...
February 18, 2010 at 6:50 pm
mansshah (2/18/2010)
I am facing similar issue while inserting lots of rows into the SQL server 2005 database.
My through put from the Sql server is 400 rows in...
February 18, 2010 at 4:39 pm
Tara-1044200 (2/18/2010)
As i have to run the same update from 6 different server/databases having same table, is there a way i can loop through all in single procedure or something.
1)...
February 18, 2010 at 8:44 am
Animal Magic (2/18/2010)
TheSQLGuru (2/17/2010)
sanketahir1985 (2/17/2010)
Do not change any configuration settings without having the root cause why RAM is getting utilized. ByDefault sql server uses available RAM.
2ndly run the...
February 18, 2010 at 7:24 am
Viewing 15 posts - 4,156 through 4,170 (of 5,843 total)