Viewing 15 posts - 9,796 through 9,810 (of 19,560 total)
cfradenburg (6/8/2011)
SQLRNNR (6/8/2011)
We currently logship to a secondary server and set it up so that the secondary is accessible for reads. Works like a charm.
What's the process for 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
June 8, 2011 at 3:01 pm
can you d-click the files and have them open in SSMS properly?
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
June 8, 2011 at 2:54 pm
See if this helps at all
https://www.arcomit.co.uk/support/kb.aspx?kbid=000057
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
June 8, 2011 at 1:46 pm
Kit G (6/8/2011)
crookj (6/7/2011)
Daniel Bowlin (6/7/2011)
A true classicHigh Anxiety (Mel Brooks - Another true Classic!)
Joe
Blazing Saddles!
Long bike ride without cushion?
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
June 8, 2011 at 1:44 pm
Cool Beans.
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
June 8, 2011 at 1:36 pm
So if you try to open files more than 2 days old it opens them just fine?
What OS and SP?
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
June 8, 2011 at 1:20 pm
crashdan (6/8/2011)
SQLRNNR (6/8/2011)
crashdan (6/8/2011)
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
The db would be in restore mode in this case, so not able to be accessed 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
June 8, 2011 at 1:14 pm
crashdan (6/8/2011)
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
The db would be in restore mode in this case, so not able to be accessed the same way....
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
June 8, 2011 at 1:08 pm
You could modify the report and change it to be a monthly rollup instead of a daily rollup. If you are going to alter that particular report, I would...
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
June 8, 2011 at 12:12 pm
Kit G (6/8/2011)
Grant Fritchey (6/7/2011)
WayneS (6/6/2011)
If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he can...
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
June 8, 2011 at 10:58 am
Jim Murphy (6/8/2011)
The good news is: I'm alive. The bad news: I'm alive. For every perspective on this thread.
1.1 miles down. Ran slow. Still had...
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
June 8, 2011 at 10:57 am
Roy Ernest (6/8/2011)
Does going down the stairs and way to the back of the office towards the beach to take a smoke break count for this? 🙂
Well, it should -...
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
June 8, 2011 at 9:59 am
Steve Jones - SSC Editor (6/8/2011)
Stefan Krzywicki (6/8/2011)
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
June 8, 2011 at 9:57 am
Hadn't heard about it - congrats to 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
June 8, 2011 at 9:52 am
Good 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
June 8, 2011 at 9:49 am
Viewing 15 posts - 9,796 through 9,810 (of 19,560 total)