Viewing 15 posts - 15,901 through 15,915 (of 19,560 total)
arr.nagaraj (3/26/2010)
Jason:
This is about the cheapest method.
Recession has taught us that we need to resort to the cheapest option where ever possible 😀
It's also probably the easiest. But...
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 26, 2010 at 7:52 am
The Dixie Flatline (3/26/2010)
Dixie, you collect on that one and I will be proud to tell folks that I am your evil twin!
Hey, I've got a couple free hours 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 26, 2010 at 7:32 am
John McC (3/26/2010)
Ah.That would explain why I couldn't find the b@##y st??%d table
I think so.
Another reason could be that the table changes names daily. Guess what it is...
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 26, 2010 at 7:10 am
arr.nagaraj (3/26/2010)
You can always script all the jobs from Enterprise manager fromManagement->SQL server agent->All tasks->Generate SQL scripts
generates the script for all the jobs on the server
This is about 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 26, 2010 at 7:09 am
Steve Jones - Editor (3/26/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
March 26, 2010 at 6:59 am
Steve Jones - Editor (3/26/2010)
I've heard, not sure if it's true, that the MS exams typically are around 200 questions, which is a low pool.
I've heard 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
March 26, 2010 at 6:58 am
Thanks. This was still fresh in memory from the last question you posted. I had to do a lot more research that time.
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
March 25, 2010 at 10:57 pm
Gift Peddie (3/25/2010)
This is true with most standardized exams from LSAT, GMAT and GRE exams add in the colleges that professors leave past tests at the school library. The software...
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 25, 2010 at 6:33 pm
Despite that kind of restriction, you could still use the redgate tools to perform the comparison. Redgate allows you to compare files for differences. Thus you would only...
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 25, 2010 at 6:27 pm
RBarryYoung (3/25/2010)
CirquedeSQLeil (3/25/2010)
RBarryYoung (3/25/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
March 25, 2010 at 6:07 pm
Angelindiego (3/25/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
March 25, 2010 at 6:04 pm
RBarryYoung (3/25/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
March 25, 2010 at 5:43 pm
sys.objects would be insufficient. You also need to compare sys.columns and sys.indexes. Then their are the Primary Keys and foreign keys that also need to be compared.
You could...
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 25, 2010 at 5:07 pm
Check out SQL Compare by 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
March 25, 2010 at 4:27 pm
In one environment, we ran update stats hourly and rebuilt indexes nightly.
Others we rebuilt indexes weekly and updated stats nightly.
It will depend on your environment.
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 25, 2010 at 4:26 pm
Viewing 15 posts - 15,901 through 15,915 (of 19,560 total)