Viewing 15 posts - 15,646 through 15,660 (of 19,560 total)
Jeff Moden (3/31/2010)
I'm a bit disappointed... no mention of the hampster poo enhancement. 😛
Or the optional parameters :hehe:
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
March 31, 2010 at 9:42 pm
Steve Jones - Editor (3/31/2010)
CirquedeSQLeil (3/31/2010)
Maybe create a bunch more messages?
I think you're doing that now. Sorting on the subject, I'll have to see how many came in on this...
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
March 31, 2010 at 9:39 pm
Awesome question!!!!!
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
March 31, 2010 at 9:35 pm
Let's do the timewarp together!!!
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
March 31, 2010 at 9:34 pm
Jeff Moden (3/31/2010)
Heh... and not to worry... part of my goal is to help keep the lights on. 😉
Thanks. Now every time I read a post by you, I...
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
March 31, 2010 at 9:29 pm
Gift Peddie (3/31/2010)
SQL Server is a crystal house, .NET is a glass house all I am saying education is the Lighthouse of the 21rst century please the lights on.
Interesting analogy....
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
March 31, 2010 at 9:26 pm
The Dixie Flatline (3/31/2010)
(whew) It took me 45 minutes to catch up.... I'm out of breath from reading so fast.
That's what you get for taking the weekend off.
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
March 31, 2010 at 9:13 pm
Glenn Dorling (3/31/2010)
Why not use the same tables every time but truncate them before each cycle?
If you are doing this numerous times a day, this seems to be the most...
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
March 31, 2010 at 9:09 pm
rainleta (3/31/2010)
I enabled the dynamic port on the server, restart the SS and SQL Browser Service, I cannot make connection from client. I have to find and use 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
March 31, 2010 at 9:08 pm
Alvin Ramard (3/31/2010)
Grant Fritchey (3/31/2010)
Did I hear Steve say he thought things were too quiet around here?I guess you guys are slacking.
That would also mean he has not read 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
March 31, 2010 at 6:25 pm
rainleta (3/31/2010)
I think 1533 is a valid or correct port number:crying:
It is.
Correct port number simply means the port number that you manually assigned to that instance.
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
March 31, 2010 at 6:24 pm
Alvin Ramard (3/31/2010)
CirquedeSQLeil (3/31/2010)
Steve Jones - Editor (3/31/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
March 31, 2010 at 6:17 pm
The port number that you manually assigned to 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
March 31, 2010 at 6:15 pm
If you are going the table variable route, I would create a stored procedure and then call the stored procedure from .Net.
Other Options would be a CTE.
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
March 31, 2010 at 6:14 pm
Grant Fritchey (3/31/2010)
CirquedeSQLeil (3/31/2010)
Jeff Moden (3/31/2010)
Grant Fritchey (3/31/2010)
dma-669038 (3/31/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
March 31, 2010 at 6:05 pm
Viewing 15 posts - 15,646 through 15,660 (of 19,560 total)