Viewing 15 posts - 2,356 through 2,370 (of 8,416 total)
shump66 (11/17/2010)
Just to clarify you are say use Begin Tran run the insert then measure then commit Tran
Yep.
November 17, 2010 at 7:11 am
Chris Morris-439714 (11/16/2010)
His attitude has got to me now. JFDI is what we get paid for.
I used to wish for a JFDI key on the standard keyboard.
It would have the...
November 16, 2010 at 9:30 am
Chris Morris-439714 (11/16/2010)
Bored, Paul? :hehe:
Stuck on another problem, rather than bored exactly...but it comes to the same thing.
I even copy-and-pasted that guy's sample data into a text file and had...
November 16, 2010 at 9:17 am
Greg Edwards-268690 (11/16/2010)
Paul White NZ (11/16/2010)
Chris Morris-439714 (11/16/2010)
Only on tuesday afternoons.
Hah! No, seriously then, I would have given up on that thread a good while ago. Not eager...
November 16, 2010 at 9:10 am
Jack Corbett (11/16/2010)
Thanks. I don't know that I've been giving for too long, but I do need to refine my focus a little bit.
SQL Server is an entirely bewildering...
November 16, 2010 at 7:06 am
Chris Morris-439714 (11/16/2010)
Only on tuesday afternoons.
Hah! No, seriously then, I would have given up on that thread a good while ago. Not eager to help himself is he?
November 16, 2010 at 6:58 am
Chris Morris-439714 (11/16/2010)
I never know when to take you seriously Paul, even when there's a shiny bit of code visible 😛
That must be really irritating.
November 16, 2010 at 6:45 am
GSquared (11/16/2010)
Ah. That makes sense then. Forgot about those.
No worries.
For anyone else that wants to play around, here's a repro:
SET XACT_ABORT ON;
GO
CREATE TABLE...
November 16, 2010 at 6:41 am
Chris Morris-439714 (11/16/2010)
Am I being too harsh with this poster?
You are the very model of self-restraint.
November 16, 2010 at 6:33 am
GSquared (11/16/2010)
November 16, 2010 at 6:18 am
steveb. (11/15/2010)
Well it is Non-Sargablehttp://www.sql-server-performance.com/tips/t_sql_where_p2.aspx
so performance would not be optimal.
That article is nearly four years old now, and much of the specific advice given is out...
November 16, 2010 at 5:35 am
r.vanlaake-1086273 (11/15/2010)
November 16, 2010 at 5:22 am
shump66 (11/16/2010)
First off, Thank you for all your help and time you spent on this.
No worries. It was an interesting and fun question to answer.
The one question is how...
November 16, 2010 at 5:19 am
dlam 18073 (11/15/2010)
but what about table and view?
Using an (non-materialized) view makes no difference. Such a view is just a description of a query - no data is stored...
November 16, 2010 at 3:47 am
Viewing 15 posts - 2,356 through 2,370 (of 8,416 total)