Viewing 15 posts - 20,131 through 20,145 (of 22,202 total)
Another vote for Itzik's books. Absolute must reads. Kalen Delaney's book on internals is a must read.
I've heard that Kalen's book on performance and troubleshooting is good but I haven't...
June 16, 2008 at 6:10 am
I'm flummoxed.
When I said recompiles, I did mean recompiles caused by the code, not a recompile that you ran. Do you have anying in the code that would cause the...
June 13, 2008 at 10:58 am
Duly chastised and I've proven my lack of reading ability, yet again.
June 13, 2008 at 10:54 am
Part of the problem is returning 1 million rows. Does the user need a million rows? Are they really using a million rows? Are they going to look at 1...
June 13, 2008 at 8:59 am
Whoa! What a mess. So, in short, FIRST() functions in a fashion somewhat, but not entirely, similar to TOP(1)?
June 13, 2008 at 7:27 am
What everyone else said is very correct. Multiple disks with multiple files and file groups is the way to go.
The one thing I would add is that I've read (can't...
June 13, 2008 at 7:18 am
Looking at the execution plan, I'd try creating a second index, just on fk_tbl_visits_id. There's no guarantee it's going to work. 1m rows out 60m has a .0167 ratio, which...
June 13, 2008 at 7:08 am
Purist anything in databases is usually a sign for disaster. There are places where an identity column as a PK and as FK's in all the related tables not only...
June 13, 2008 at 6:55 am
When you ran the trace did you also see two different times on the server? I understand the client saw two times, but was it the same on the server?
Oh,...
June 13, 2008 at 6:16 am
Should you "have to" do extra work? No. Are you going to in most situations. Yes.
It's kind of the nature of the beast. If you have tasks that have to...
June 13, 2008 at 6:11 am
While that may be true, SQL Server is not Access. There's no way to ensure physical order of the data returned without applying some type of order to the statement....
June 13, 2008 at 6:06 am
Are you seeing two different execution plans too?
June 12, 2008 at 1:19 pm
FWIW, SQL Server 2008 has the same stupid problem.
June 12, 2008 at 12:46 pm
Not knowing your system, your code or any special circumstances that you're laboring under, I'd go with my standard set. I've got them documented here[/url].
June 12, 2008 at 12:34 pm
It doesn't give enough details on that page to determine if there's a funky business requirement or even if that initial model is updated in the demo. I'm still falling...
June 12, 2008 at 11:45 am
Viewing 15 posts - 20,131 through 20,145 (of 22,202 total)