Viewing 15 posts - 3,391 through 3,405 (of 5,843 total)
bijarcity (5/15/2011)
Thanks for your website.
I have a question about distributed system.
we have a project about distributed systems but the problems that we have is about how we can design this...
May 16, 2011 at 7:17 am
We have covered the simple things that can be covered on a forum thread. I recommend you get a professional tuner to remote into your system and do a...
May 16, 2011 at 7:09 am
We cannot help you without more details.
May 16, 2011 at 7:07 am
Scalar UDFs are the single worst performance problem I have dealt with over the last 5 years as a perf tuning consultant. I advise my clients to NEVER EVER...
May 12, 2011 at 9:41 am
tfifield (5/11/2011)
You also might want to consider how data is entered for the table. If there are VARCHAR type columns that are initially empty and then get filled in...
May 12, 2011 at 9:01 am
1) http://support.microsoft.com/kb/297861: that article is for sql 7 and sql 2000!!! WAY out of date.
2) your request for help is very deep and complex. That isn't typically what...
May 11, 2011 at 8:57 am
sequential is definitely the way to go. And there are ways you can do this in the middle tier too if you need it. With those you can...
May 11, 2011 at 8:51 am
Schadenfreude-Mei (5/10/2011)
TheSQLGuru (5/10/2011)
May 10, 2011 at 11:30 am
rootfixxxer (5/10/2011)
I'll do what you suggest and come back with the results, but how do i test the file IO in the second point?
I'll let the refactoring...
May 10, 2011 at 11:23 am
One final thing: if you have Lock Pages In Memory setting enabled, you probably should consider turning that off since you have multiple instances.
May 10, 2011 at 11:14 am
That doesn't seem to be a valid query plan - it won't open in Plan Explorer. It also goes WAY beyond simple help that you get for free on...
May 10, 2011 at 8:21 am
GilaMonster (5/9/2011)
terrykzncs (5/9/2011)
Like they said before, start with replacing the cursors with set statements. But then replace the temp tables with table variables.
In general I recommend the other way around....
May 10, 2011 at 8:12 am
Sounds like a possible regression to me, although I will add the following first:
1) update stats must be done on EVERYTHING and with FULL_SCAN. no exceptions, and to do anything...
May 10, 2011 at 8:10 am
Clustering (and HA in general) is a VERY COMPLEX and CRITICAL subject!! You are asking questions that lead me to believe you have a very low probability for success....
May 10, 2011 at 8:06 am
TheSQLGuru (5/10/2011)
1) check permissions on drives, directories, files that have sql server data.
2) did someone enable windows Data Execution Prevention...
May 10, 2011 at 8:03 am
Viewing 15 posts - 3,391 through 3,405 (of 5,843 total)