Viewing 15 posts - 12,796 through 12,810 (of 19,560 total)
You could look into Central Management Server. That is an option that is available with SQL 2008. You can execute a query against multiple servers at the same...
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
August 24, 2010 at 12:17 pm
I would run that by your rep. If you have an enterprise license agreement, or msdn account - that may be substantially different.
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
August 24, 2010 at 11:18 am
I think a common component is coming from this discussion. The safest way to proceed with these kinds of databases from vendors (and MS has plenty of bad database...
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
August 24, 2010 at 11:14 am
I was expecting there to at least be a few comments on this one.
I, like you, have found that the DMVs are useful. I find that, despite some of...
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
August 24, 2010 at 10:54 am
crookj (8/24/2010)
CirquedeSQLeil (8/24/2010)
crookj (8/24/2010)
Painful (Infection!)OUCH!:crying:
Joe
Abscess
Antibiotics (Hopeful)
joe
Addiction
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
August 24, 2010 at 10:44 am
The book you listed should be able to get you familiar with the basics.
Much of the tool is GUI driven. You would need to setup your connection, create 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
August 24, 2010 at 10:43 am
An assessment of the bug should be split out amongst the team. Ease of fix, impact, time to fix should all be included. If the bug is simple...
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
August 24, 2010 at 10:37 am
Yes SSIS can handle this. I am using SSIS currently for a similar task.
As Baskar suggested, use the date field as your control point. You may need to...
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
August 24, 2010 at 10:31 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
August 24, 2010 at 10:11 am
crookj (8/24/2010)
Painful (Infection!)OUCH!:crying:
Joe
Abscess
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
August 24, 2010 at 10:10 am
S.K. (8/24/2010)
CirquedeSQLeil (8/24/2010)
1. Source control.
2. Ensuring that QA or beta is exactly like production (some automated process would 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
August 24, 2010 at 9:58 am
No on the dev license. Your server is licensed.
On the Standard v. Enterprise, I would check with your rep. My gut says no on that one.
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
August 24, 2010 at 9:56 am
Shark Energy (8/24/2010)
We run Reporting Services,...
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
August 24, 2010 at 9:03 am
Congrats again Tracy. It is good to see this kind of information and candidness from the winner.
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
August 24, 2010 at 8:56 am
Here are some important points for me (some already mentioned):
1. Source control.
2. Ensuring that QA or beta is exactly like production (some automated process would be good here).
3....
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
August 24, 2010 at 8:53 am
Viewing 15 posts - 12,796 through 12,810 (of 19,560 total)