Viewing 15 posts - 16,936 through 16,950 (of 19,560 total)
Ray K (3/1/2010)
1!!!!!!!!!!!!! (As in WE'RE!!! -- my alma mater, Syracuse University -- GO ORANGE!!!)(Sorry, had to get that out of my system! :-D)
That's fine. They won't be...
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 1, 2010 at 12:40 pm
And in answer to the question, Snapshots should not interfere with the log chain.
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 1, 2010 at 12:38 pm
GilaMonster (3/1/2010)
No one interested in the soccer world cup?
Great Timing.
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 1, 2010 at 12:31 pm
Paul White (3/1/2010)
Alvin Ramard (3/1/2010)
Only SELECT DATEDIFF(DAY, GETDATE(), '2012-07-27') days left to go before the start of the next Olympic games. 😛
The Rugby World Cup is much more exciting 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 1, 2010 at 12:29 pm
dbychen gave some good responses. In addition I would add easier troubleshooting (no other apps interfering).
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 1, 2010 at 10:11 am
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 1, 2010 at 9:37 am
chutney
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 1, 2010 at 9:35 am
Jeff Moden (2/28/2010)
My question would be... why are you truncating the log to begin with? Aren't backups and restorability important?
I was hoping that it was simply a mis-type 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
February 28, 2010 at 7:17 pm
BSavoie (2/27/2010)
I just got passed it. I got a System...
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
February 28, 2010 at 8:21 am
To do a table level reorg, you would be doing a clustered index reorg. You can do a reorg on your indexes in a job in MSSQL on 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
February 28, 2010 at 8:19 am
Sri - SQL (2/27/2010)
restore option will restore data. How about moving jobs and ssis packages?
Restore the msdb database is an option to move the jobs.
Data compare will help transfer 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
February 27, 2010 at 5:16 pm
Once again, a very good question.
Thanks Paul.
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
February 27, 2010 at 5:08 pm
If you are going to use the restore database option, then here is an article on doing that
http://msdn.microsoft.com/en-us/library/ms177429.aspx
Another option is to purchase sql compare and sql data compare from redgate....
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
February 27, 2010 at 4:23 pm
Here's an article on how to move system databases.
http://msdn.microsoft.com/en-us/library/ms345408.aspx
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
February 27, 2010 at 4:20 pm
Will visual studio start at all?
Or does it only fail when trying to open a specific package?
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
February 27, 2010 at 4:05 pm
Viewing 15 posts - 16,936 through 16,950 (of 19,560 total)