Viewing 15 posts - 49,756 through 49,770 (of 59,078 total)
I've been having good success with DTA on set based code. Sometimes it's recommendations don't actually speed anything up but, as some have said about other tools, it's a...
June 24, 2008 at 5:37 am
venki (6/23/2008)
I am pulling the data i.e recordset by written a query from different tables.
I supposed to modify...
June 23, 2008 at 10:32 am
GilaMonster (6/23/2008)
Yup, though you can still get a stats-based recompile from the temp table, sometimes even more than once.
So... wouldn't that be a Catch-22? Optimizer says "I need a...
June 23, 2008 at 10:29 am
GilaMonster (6/23/2008)
The main advantage I've seen for table vars is that they don't cause a stored proc to recompile.
That's pretty important for GUI code... which I normally don't write....
June 23, 2008 at 10:15 am
JJ B (6/23/2008)
- Jeannine Jennifer Bienn.
. According to family legend (my...
June 23, 2008 at 10:10 am
JJ B... (Jar-Jar Binks???)
When you go to post code, take a look at the "IFCode Shortcuts" just to the left of the Edit window... click on the "code" pair there...
June 23, 2008 at 9:31 am
Yeah... I know... Microsoft is pretty much non commital when it comes to stuff like that because the amount of memory and the I/O system will make it vary quite...
June 23, 2008 at 9:01 am
Heh... Embarassingly simple. Thanks Stacey.
Mobasha... that's gotta be as good as deleting SA... still, your users are going to know that you can give SA privs to any login......
June 23, 2008 at 8:54 am
By the way, Peter... you machine is about twice as fast as more poor ol' 6 year old single processor 1.8 GHz box... what are you using?
June 23, 2008 at 8:48 am
That really puts the stuff on the Pivot method, huh? 🙂
June 23, 2008 at 8:46 am
Same conclusion I came to... Thanks Peter. It also means that it could be done using a CTE with the same performance if the data is pre-aggregated like you...
June 23, 2008 at 8:26 am
It's funny how changing the CTE into a derived table improved performance like that. I'll dig into that and see why.
June 23, 2008 at 8:06 am
Ian Crandell (6/23/2008)
Jeff Moden (6/23/2008)[hrIt was designed as a replacement for OTTO Fuel II which is what the Navy is currently using. OTTO Fuel II has a couple of...
June 23, 2008 at 8:01 am
gregers65 (6/23/2008)
June 23, 2008 at 7:53 am
Manoj (6/3/2008)
You Should not be able to Delete SA login from the server, But you could be able to DISABLE the SA account from the server.
Cool... how would you go...
June 23, 2008 at 7:51 am
Viewing 15 posts - 49,756 through 49,770 (of 59,078 total)