Viewing 15 posts - 15,631 through 15,645 (of 19,560 total)
Nah, Hades is more fun.
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 10:43 pm
You can have up to 32768 connections to the instance. That is per instance assuming you have adequate memory to support all of the connections. Each connection will...
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 10:39 pm
Yeah, apologies for hijacking the thread with an inside joke.
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 10:35 pm
Ha, too bad this is an April fools joke. It would have been great.
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 10:33 pm
ziangij (3/31/2010)
heard it for the first time... was already fooled by Steve's editorial... so was cautious on this question..:-)lucky to get 7 points.. 😛
Congrats. I better go check out...
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 10:29 pm
This link may be of some use to you. It shows a script that will perform a complete security audit for you.
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 10:27 pm
I would not call it a bug. If they are using their windows login information and they recently changed their password - this will happen. This also happens...
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 10:24 pm
Dodgers are in town and that has sparked quite a bit of talk about the McCourt divorce
7 mansions and the whole circus.
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 10:19 pm
oh la vache
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 10:13 pm
The Dixie Flatline (3/31/2010)
Anything for you, Jason, you copyright-violator, you.
I'm thinking it is probably closer to trademark infringement. And wouldn't it belong to the community anyway. 😉
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 10:08 pm
It is good practice to explicitly define your joins. If for nothing else than to have better readability of the code and to better control the result set.
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 10:05 pm
The Dixie Flatline (3/31/2010)
FROM BOL:Wildcards used without LIKE are interpreted as constants instead of as a pattern, that is they represent only their own values.
http://msdn.microsoft.com/en-us/library/ms187489%28v=SQL.100%29.aspx
Thanks for providing that link.
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 10:01 pm
vijay82 (3/31/2010)
HOW to recover SA password when you forgot it?plz give in GUI METHOD
thank you
No recovery. You will need to logon via another account that has sysadmin permissions and...
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:59 pm
SanjayAttray (3/31/2010)
Even tried to google it and found nothing much. ...
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:55 pm
Though you have it resolved, here is a link with a reason as to why it may have happened. This doesn't explain why it only failed on the one...
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:54 pm
Viewing 15 posts - 15,631 through 15,645 (of 19,560 total)