Viewing 15 posts - 10,681 through 10,695 (of 19,560 total)
Stefan Krzywicki (3/31/2011)
Gianluca Sartori (3/31/2011)
Wow, Roy! It takes me three years to earn that money!I would go, if I wasn't certain that my wife would kill me.
What does your wife...
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, 2011 at 10:38 am
Thanks for the 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, 2011 at 9:39 am
GilaMonster (3/31/2011)
David Benoit (3/31/2011)
Grant Fritchey (3/31/2011)
Jeez, that guy (or girl) is lost. One more response and then I'm done. I'm the Scary DBA, not the Saintly DBA.
If it is 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, 2011 at 8:15 am
Craig Farrell (3/30/2011)
WayneS (3/30/2011)
Craig, in your case, I'd have to agree! :w00t:
Awww, my duckie's pretty good at tech problems. His answer to all my relationship questions though is "Go...
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 30, 2011 at 11:20 pm
Great stuff presented in this article. I am working on a project that may benefit from this - have to see how it plays 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 30, 2011 at 9:58 pm
NP Wayne
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 30, 2011 at 9:55 pm
Great Stuff Kevin - thanks for posting 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 30, 2011 at 9:54 pm
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
March 30, 2011 at 4:32 pm
WayneS (3/30/2011)
SELECT s.name AS schema_name,
t.name AS table_name,
...
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 30, 2011 at 4:31 pm
To add to what Wayne said, a read_only database may or may not be a part of a high-availability set. You can change a database to read_only for archival...
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 30, 2011 at 4:15 pm
As Gail said, the two are different. 2008 will not merge into R2 but there you can upgrade 2008 to R2. That will mean more work 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 30, 2011 at 4:12 pm
Tough to say on that one. If you figure that a larger file will cover more sectors than a smaller file - then the possibility of corruption from a...
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 30, 2011 at 3:56 pm
crookj (3/30/2011)
Orion's BeltJoe
MIB
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 30, 2011 at 3:23 pm
The answers to your questions are not straight forward. It depends on your DB, usage, and environment.
I'd recommend reading this blog by Paul Randal on the topic.
The best answer...
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 30, 2011 at 3:17 pm
jamalziena (3/30/2011)
thank you very much , about the the code :
SELECT
t.name AS table_name,
...
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 30, 2011 at 2:18 pm
Viewing 15 posts - 10,681 through 10,695 (of 19,560 total)