Viewing 15 posts - 12,616 through 12,630 (of 22,214 total)
I just talk about the information on a form, like a drivers license. It all gets stored somewhere and I'm the guy that manages the stuff that does the storing.
April 29, 2011 at 5:52 am
Dropping all indexes may help with the inserts, but then again it might not. It really depends on if any of them are necessary for lookup operatoins during the inserts....
April 29, 2011 at 5:47 am
No, there's no way to change it. It's funny that it's called a timeout because it actually isn't. It's a set number of times that the optimizer will attempt to...
April 29, 2011 at 5:42 am
Try adding p.Date_Last_Requested as an INCLUDE column on the Person.CorvId_FirstName_LastName_Email index. That would eliminate the key lookup operation you're getting to retrieve that one column. That will help, a lot....
April 29, 2011 at 5:30 am
Yeah, I checked it. At my previous employer we were automating builds, both complete and incremental, for the last couple of years. Make sure it's checked on all projects involved.
April 29, 2011 at 5:18 am
Steve Jones - SSC Editor (4/28/2011)
I posted a note about understanding your access patterns for data, meaning hitting tables...
April 28, 2011 at 12:25 pm
One, you're posting in the SQL Server 2005 forum. You might want to take this question to that forum.
Two, the old SQL Server software had a mechanism for generating scripts...
April 28, 2011 at 8:18 am
Depends. Do you want to just do it, or do you want to do it programatically? If you just need a script, right click on the database, select Tasks and...
April 28, 2011 at 8:05 am
spadavala82 (4/28/2011)
The Data base Schema will never decreases the Query Performance. If you are not mentioned the schema when you are executing the query check the execution time, and...
April 28, 2011 at 7:41 am
From the error, I would assume that you have a value that is not numeric stored in that column.
April 28, 2011 at 5:12 am
Tempdb is used by so much it's hard to list it all. I suppose if you had terrabytes of memory and gigabytes of data you might not see tempdb used...
April 28, 2011 at 5:09 am
I can't see that exec plan. When I opened it I got chinese characters.
April 28, 2011 at 5:05 am
It does depend on how you define "schema." I would include picking the clustered index as a fundamental part of database design and that certainly affects performance. Also, primary keys...
April 28, 2011 at 4:54 am
I had a system where we ran a basic query trace 24/7 for years. Other than dealing with the data that came out of, there was no real issues there...
April 27, 2011 at 11:29 am
David Egnoski (4/27/2011)
April 27, 2011 at 9:55 am
Viewing 15 posts - 12,616 through 12,630 (of 22,214 total)