Viewing 15 posts - 13,126 through 13,140 (of 19,560 total)
For stored procedures, I would start with the Database Upgrade advisor. That will run checks on your database to help determine what needs fixed prior to upgrade.
For DTS packages,...
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
July 27, 2010 at 11:57 am
Replication sounds like a good option to me for that. Other options may take us beyond SQL Server to creating a package that gets deployed to the laptop when...
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
July 27, 2010 at 11:16 am
You are mixing a few things here. The owner of the job is not necessarily the one that executes a job. SQL Agent Service cannot be set 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
July 27, 2010 at 11:14 am
Jack Corbett (7/27/2010)
CirquedeSQLeil (7/27/2010)
... Dicaprio doesn't do it for me ...So may places to take that, I don't even know where to start and not sure if I should...:-D
Please...
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
July 27, 2010 at 10:21 am
dbowlin (7/27/2010)
CirquedeSQLeil (7/26/2010)
John Rowan (7/26/2010)
crookj (7/26/2010)
John Rowan (7/26/2010)
blessingSneezed?
Joe
Nope, just count 'em.
daily and then repeat
#1. I woke up again
#2. The sun rose again.
#3. My family and I are...
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
July 27, 2010 at 10:17 am
Sankar Reddy (7/27/2010)
CirquedeSQLeil (7/27/2010)
I would rebuild certain tables on certain nights and have a rebuild job running nightly.
Example:
TableA -...
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
July 27, 2010 at 10:15 am
Kit G (7/27/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
July 27, 2010 at 10:14 am
Jack Corbett (7/27/2010)
CirquedeSQLeil (7/27/2010)
... Dicaprio doesn't do it for me ...So may places to take that, I don't even know where to start and not sure if I should...:-D
Not...
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
July 27, 2010 at 10:11 am
And here is another resource for helping to find the cause (if it is different than the index rebuild that occurred).
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
July 27, 2010 at 9:13 am
Nice question. No idea why this stuck in my head without review or research.
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
July 27, 2010 at 9:07 am
Roy Ernest (7/27/2010)
The Dixie Flatline (7/27/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
July 27, 2010 at 9:05 am
Lynn Pettis (7/27/2010)
The Dixie Flatline (7/27/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
July 27, 2010 at 9:02 am
Alvin Ramard (7/27/2010)
The Dixie Flatline (7/27/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
July 27, 2010 at 9:00 am
jcrawf02 (7/27/2010)
Anybody see A-Team? Seems to be exiting the theaters in a hurry.
Yes. I liked it. It has been in theatres for almost 7 weeks here. During...
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
July 27, 2010 at 8:57 am
I would look into doing the rebuilds more frequently and more targeted.
I would rebuild certain tables on certain nights and have a rebuild job running nightly.
Example:
TableA - monday night
TableB -...
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
July 27, 2010 at 8:51 am
Viewing 15 posts - 13,126 through 13,140 (of 19,560 total)