Viewing 15 posts - 17,041 through 17,055 (of 19,560 total)
The query certainly works for 100. For large result sets you would want to consider a different method.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 7:18 pm
Elliott W (11/16/2009)
Your boss has you using software outside of the license, ie you don't have a license to use it commercially...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 7:05 pm
Paul White (2/23/2010)
CirquedeSQLeil (2/23/2010)
Why don't we count in K rather than decimal for this thread?Kibi-posts? http://en.wikipedia.org/wiki/Kilobyte
Thank you wikipedia. Whatever politically correct term we want to use - how...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 6:43 pm
Paul White (2/23/2010)
john.arnott (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?
I know I must be one. My thought on seeing the 12000 mark go by was "less than 300 till the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 6:25 pm
Steve Jones - Editor (2/23/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 6:22 pm
Paul White (2/23/2010)
jcrawf02 (2/23/2010)
Paul White (2/23/2010)
Will do. Be brutal 😀Dear Water, be wet. 😛
I was drinking Coca-Cola when I read that.
I now have a fizzing sensation in my nasal...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 6:20 pm
nice question. Thanks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 2:07 pm
Lynn has an additional cross join thus supports up into the billions.
I adjusted my solution to support this
Declare @LimitBigInt
Set @Limit = 150000000
;
WITH Nbrs_2( n ) AS (select 1 union all
select...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 1:40 pm
Lynn Pettis (2/23/2010)
I posted my solution to the FizzBuzz challange on AskSSC. :smooooth:
Check your email.;-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 11:46 am
Missed another one - it always approaches a milestone when I have to get on the road - dang it.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 10:21 am
Gary Varga (2/23/2010)
Is it for real cash or vouchers for pork chops?
If it is for pork chops then I am in 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 10:20 am
Lynn Pettis (2/23/2010)
Should we save the 12,000 post for Gail when she gets back from being on-site with a client?
Can you hold it that long?
She can have 13000
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 9:20 am
Steve Jones - Editor (2/23/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 9:16 am
CirquedeSQLeil (2/23/2010)
Lynn Pettis (2/23/2010)
On a count down to 12,000 posts on The Thread!Only 14 more posts
Nope - 2 more
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 9:14 am
reidres (2/23/2010)
Manie Verster (2/23/2010)
Jeff Moden (2/22/2010)
Manie Verster (2/22/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 23, 2010 at 9:07 am
Viewing 15 posts - 17,041 through 17,055 (of 19,560 total)