Viewing 15 posts - 13,156 through 13,170 (of 19,560 total)
The Dixie Flatline (7/26/2010)
Since when do spies knock on the door? I thought they just broke in / snuck in and took what they wanted.
Shhhhhh....
"They" are monitoring all communications now,...
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
July 26, 2010 at 1:38 pm
The Dixie Flatline (7/26/2010)
"Lynn?"
"Lynn, who?"
"There is no such person."
"There never was...
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
July 26, 2010 at 1:18 pm
russell.young (7/26/2010)
so I should shrink the log file and then let it grow for a while to determine it's normal size and then add 5-10 gigs.
No. You determine what...
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
July 26, 2010 at 1:17 pm
Shrink it back to an appropriate size. You can determine an appropriate size based on usage and typical log backup size. Add 5-10GB to the typical usage 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
July 26, 2010 at 1:04 pm
Matt Miller (#4) (7/26/2010)
GilaMonster (7/26/2010)
Lynn Pettis (7/26/2010)
Going to work for Honeywell. Government contracts, about all I can really say.Sounds intriguing...
DBCC TIMEWARP @CIACleanse @userID='Lynn Pettis' @noHamsterPoo
ROFLOL:w00t:
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
July 26, 2010 at 12:50 pm
Roy Ernest (7/26/2010)
Now I can tell everyone, "Hey..I know a real Spy" 😉
The guy next to me used to work for microsoft while working for the kgb.
You never know who...
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
July 26, 2010 at 12:24 pm
m_wp (7/26/2010)
Hi,Here is the reason: Every time users need to type the long database name.
I am curious as to why the users are typing the database name?
An option that could...
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
July 26, 2010 at 12:18 pm
Brandie Tarvin (7/26/2010)
Lynn Pettis (7/26/2010)
Going to work for Honeywell. Government contracts, about all I can really say.
Hey, now. I've seen Covert Affairs. You becoming a spy, Lynn? Quick, Everybody,...
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
July 26, 2010 at 12:14 pm
jcrawf02 (7/26/2010)
Lynn Pettis (7/26/2010)
GilaMonster (7/24/2010)
Lynn Pettis (7/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
July 26, 2010 at 12:12 pm
Steve Jones - Editor (7/26/2010)
I'm not sure what happened, but I have added back the last code snippet and final para.
Thanks Steve.
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
July 26, 2010 at 12:11 pm
If I understand correctly, the logins that are disabled are the NT Authority\System, and NT Service logins.
This could be getting disabled by a local security policy on the server or...
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
July 26, 2010 at 12:09 pm
Which logins were disabled? Ones that you created?
Are you creating these via script or through the gui?
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
July 26, 2010 at 11:02 am
Just double-click the exe and follow the prompts.
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
July 26, 2010 at 10:41 am
John Rowan (7/26/2010)
crookj (7/26/2010)
John Rowan (7/26/2010)
blessingSneezed?
Joe
Nope, just count 'em.
daily and then repeat
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
July 26, 2010 at 10:39 am
Thanks for the time taken to write this article.
I too would have liked to see something more verbose in the explanations. More detail would also be good.
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
July 26, 2010 at 10:38 am
Viewing 15 posts - 13,156 through 13,170 (of 19,560 total)