Viewing 15 posts - 13,876 through 13,890 (of 19,560 total)
david.c.holley (5/20/2010)
SELECT REPLACE(SUSER_NAME(), HOST_NAME() + '\','') as userId
I need to pull out the user name from the fully qualified name ([domain name]/). The statement above isn't working as 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
May 20, 2010 at 12:09 pm
Greg Charles (5/20/2010)
If you're using SQL Server Management Studio, expand...
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
May 20, 2010 at 11:54 am
Grant Fritchey (5/20/2010)
Just understand, in a pretty healthy majority of circumstances, using NOLOCK is a bad idea and can lead to problems.
There are rare occasions where it may be acceptable...
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
May 20, 2010 at 11:22 am
Here is another option.
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
May 20, 2010 at 11:20 am
Thanks - nice 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
May 20, 2010 at 10:53 am
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
May 20, 2010 at 10:52 am
Nice QOTD Ron.
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
May 20, 2010 at 10:51 am
Paul White NZ (5/20/2010)
Trey Staker (5/20/2010)
btw -- I REALLY liked your comments in that discussion.
Me and Gianluca standing up for what's right!!! LOL
Wait until Jeff sees that thread...he does...
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
May 20, 2010 at 10:45 am
Jeff Gray (5/20/2010)
The author did a fine job discussing the different approaches. The article shows once again that never and always are both almost always never the correct answer.
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
May 20, 2010 at 10:41 am
Gianluca Sartori (5/20/2010)
Brett Robson (5/20/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
May 20, 2010 at 10:34 am
Paul White NZ (5/20/2010)
I see now - you guys are way ahead of me tonight.Trying to do too many things at once, and failing to do any of them well!
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
May 20, 2010 at 10:31 am
Atif Sheikh (5/20/2010)
Dynamic SQL is the last thing to do.
Sometimes Dynamic SQL is quite useful. There are alternatives to using case statements or dynamic sql (such as child...
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
May 20, 2010 at 10:31 am
Chris Morris-439714 (5/20/2010)
CirquedeSQLeil (5/20/2010)
Is the paint tin blue paint or pink paint?LMAO!
Shhhh...It's Pure Brilliant White!
HAHA - glad you caught 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
May 20, 2010 at 10:21 am
Paul White NZ (5/20/2010)
CirquedeSQLeil (5/20/2010)
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Chris Morris-439714 (5/20/2010)
Paul White NZ (5/20/2010)
Hey Chris, what's with 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
May 20, 2010 at 10:20 am
nadersam (5/20/2010)
Thanks for all replies.
You're welcome.
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
May 20, 2010 at 10:15 am
Viewing 15 posts - 13,876 through 13,890 (of 19,560 total)