Viewing 15 posts - 11,011 through 11,025 (of 19,560 total)
Lynn Pettis (2/13/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
February 16, 2011 at 2:31 pm
Peter Trast (2/16/2011)
Never been in this thread before but here it is:Antidisestablishmentarianism
Yes, it is a real word 🙂
Pseudoantidisestablishmentarianism
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 16, 2011 at 2:10 pm
Have you been able to open and edit it in the past?
Has the server been patched recently?
If not has something been installed or uninstalled or otherwise changed on the server?
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 16, 2011 at 2:08 pm
Have you tried setting up a proxy account for the job in sql agent?
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 16, 2011 at 2:04 pm
Gourmet Butter Toffee Popcorn Recipe
Ingredients You Will Need:
1 cup butter
2 cups light brown sugar
½ cup corn syrup
½ teaspoon salt
½ teaspoon baking soda
1 teaspoon vanilla extract
1 cup whole pecans (or peanuts)...
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 16, 2011 at 2:01 pm
Try this to help quickly find where the exact and partial duplicate indexes are.
-- Overlapping indxes
with indexpartdups as (
Select object_id As id, index_id As indid, name,
(Select case keyno when 0...
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 16, 2011 at 1:53 pm
A couple of things you could do to minimize the log size and the effect on logshipping.
Change your rebuild job so that it only rebuilds specific tables on certain nights...
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 16, 2011 at 1:36 pm
ahmedhussein787 (2/16/2011)
(ID, ProductionDate,ExpiredDate,IsAvaliable,Product)
1 , 2-1-2011 , 2-15-2011, false, Milk
2 , 2-4-2011 , 2-8-2011,true,Cheese
3 , 2-3-2011 , 2-5-2011,true,Coffee
4 , 2-7-2011 , 2-13-2011,false,...
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 16, 2011 at 1:32 pm
Is it mandatory to convert to C#, or could you convert it to Vb .Net?
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 16, 2011 at 1:29 pm
I would certify on SQL 2008 at this point.
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 16, 2011 at 1:27 pm
Thanks for continuing the series.
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 16, 2011 at 1:26 pm
Mine is mostly based on momentary whims.
However the Running Rhino is very descriptive of me.
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 16, 2011 at 1:21 pm
Thanks for the 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
February 16, 2011 at 1:18 pm
What - this isn't about PostGres?
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 16, 2011 at 1:17 pm
Nice question.
Thanks
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 16, 2011 at 1:16 pm
Viewing 15 posts - 11,011 through 11,025 (of 19,560 total)