Viewing 15 posts - 17,071 through 17,085 (of 19,560 total)
Sean-752587 (2/22/2010)
As far as scaleability is concerned, I did try it with 1 Mil. rows which didn't work in my master database (SQL 2008 dev edition). It topped out at...
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 22, 2010 at 12:13 pm
Thanks for the article. I tend to use the method similar to what Paul described.
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 22, 2010 at 11:56 am
Yes - that is a classic. I used to have it hanging in my office. Then I moved.
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 22, 2010 at 11:34 am
jcrawf02 (2/22/2010)
Sean, on yours, casting is unneccessary until the ELSE, and makes...
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 22, 2010 at 10:45 am
GSquared (2/22/2010)
SET NOCOUNT ON;
DECLARE @Table1 TABLE (
ID int IDENTITY PRIMARY KEY,
Number int);
DECLARE @Number INT;
SELECT @Number = 1;
WHILE @Number <= 100
BEGIN
INSERT INTO @Table1 (Number)
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 22, 2010 at 9:41 am
J.Faehrmann (2/22/2010)
It performs well enough.
DECLARE @i INT
SET @i = 1
WHILE...
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 22, 2010 at 8:08 am
Another option would be check out this puzzle roundup[/url] by Grant Fritchey.
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 21, 2010 at 10:57 pm
Jeff Moden (2/21/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 21, 2010 at 10:29 pm
These sorts of questions could be good. They could also lead down the slippery slope. If speed over quality is the most important - you will end up...
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 21, 2010 at 6:37 pm
RBarryYoung (2/21/2010)
CirquedeSQLeil (2/21/2010)
The difficult thing is ensuring that people read it. Just like a Terms & Conditions...
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 21, 2010 at 5:57 pm
RainbowFfolly (2/21/2010)
...I must admit the idea of the dozen or so articles people get pointed to intrigues me; what areas do they cover?
Check the article by Gail Shaw in my...
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 21, 2010 at 4:47 pm
Actually creating a thread or forum is not the difficult thing by far.
The difficult thing is ensuring that people read it. Just like a Terms & Conditions Agreement that...
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 21, 2010 at 4:45 pm
Good point - location would help.
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 21, 2010 at 3:55 pm
Yes - oft suggested. Difficult to implement. Not everybody would go looking for the "New Members" section.
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 21, 2010 at 3:50 pm
CirquedeSQLeil (2/21/2010)
If not Barry, Lynn, or Gus, it must be Jack. 😀After that - Gail, Andy, Tim, K. Brian Kelley, Steve, and Jeff are already MVP's.
I know I am quoting...
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 21, 2010 at 3:47 pm
Viewing 15 posts - 17,071 through 17,085 (of 19,560 total)