Forum Replies Created
Viewing 15 posts - 1,156 through 1,170 (of 18,926 total)
-
RE: View Performance - Not using table index?
Gazareth (11/15/2011)
Ha, let me rephrase that - you could use the FORCESEEK hint, but I really really really _really_ wouldn't recommend it 🙂I reallly really really wanted to make...
-
RE: SQL Server 2000 - Memory Issues
sharath.chalamgari (11/15/2011)
As i mentioned earlier we have 90 GB of space on the E drive. when we restart the services the backup jobs will work as usual. is there any... -
RE: Are the posted questions getting worse?
Brandie Tarvin (11/11/2011)
EEEK! I just sold another story. Happy happy.Now I have to write more.
-
RE: Are the posted questions getting worse?
Ninja's_RGR'us (11/14/2011)
Hi, I'd like to upgrade from Coach.Sir, that's insane.
I know!
20 000, 20K!
-
RE: Are the posted questions getting worse?
SQLRNNR (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!Thanks - you were quick on that. I just got the email this morning.
-
RE: Are the posted questions getting worse?
Ninja's_RGR'us (11/10/2011)
WayneS (11/10/2011)
Ninja's_RGR'us (11/10/2011)
We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. ... -
RE: Are the posted questions getting worse?
Ninja's_RGR'us (11/10/2011)
Jeff Moden (11/10/2011)
I don't know if anyone else noticed but Gail isn't just the leading point holder anymore... she's also the leading poster![font="Arial Black"]Congrats Gail!!! [/font]
Actually I...
-
RE: View Performance - Not using table index?
Gazareth (11/15/2011)
You could use the FORCESEEK table hint, but I wouldn't recommend it.Does the query with the dummy WHERE clause outperform the one without, and are they synonymous queries?
As Ninja...
-
RE: Table variable in stored proc - query plan reuse
Tom Brown (11/15/2011)
I've tested and Its definitely quicker with some of the @table variables converted to #tmp tables (the ones that are reused in joins) - I then added... -
RE: SQL Server 2000 - Memory Issues
Insufficiant memory is usually a local error on the dev machine.
The 2nd error is definitely an error about not enough drive space.
If you really have ram issue on your server...
-
RE: Are the posted questions getting worse?
Grant Fritchey (11/15/2011)
Hey everyone. Back from the hole into which I crawled. Did I miss anything? And no, I'm deleting a few hundred emails rather than read through all this.... -
RE: Table variable in stored proc - query plan reuse
I wanted the code to see how the table was used to see if it was a bad use.
-
RE: Table variable in stored proc - query plan reuse
You have the recompile event in the tsql category as well.
-
RE: Are the posted questions getting worse?
L' Eomot Inversé (11/15/2011)
Brandie Tarvin (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Guy missing 60 cpus! Don't know how to help.http://www.sqlservercentral.com/Forums/Topic1205595-391-1.aspx
Did he feed them after midnight or get water on them?
SET Snark = OFF;
SET SNARK...
-
RE: View Performance - Not using table index?
Please post the actual execution plan of the final select that scan.
A scan is not a bad thing. It often beats the hell out of seek + lookup.
Also you...
Viewing 15 posts - 1,156 through 1,170 (of 18,926 total)