Viewing 15 posts - 13,336 through 13,350 (of 19,560 total)
I can see some reason for evangelizing "never" in the database world to developers. However, if the developer is always told to never do something, and then you do...
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 13, 2010 at 6:41 pm
Paul White NZ (7/13/2010)
CirquedeSQLeil (7/13/2010)
I have a problem with the word "NEVER."
Me too. My only rule of thumb is that there are no good rules of thumb.
And 'never' means...
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 13, 2010 at 6:23 pm
Stefan Krzywicki (7/13/2010)
Jeff Moden (7/13/2010)
CirquedeSQLeil (7/13/2010)
As a rule of thumb, once a table has more than five indexes, updates to that table may 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
July 13, 2010 at 6:18 pm
Jeff Moden (7/13/2010)
CirquedeSQLeil (7/13/2010)
As a rule of thumb, once a table has more than five indexes, updates to that table may be adversely affected...
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 13, 2010 at 5:48 pm
WayneS (7/13/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 13, 2010 at 5:35 pm
Here's another one in the same doc.
As a rule of thumb, once a table has more than five indexes, updates to that table may be adversely affected since the 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
July 13, 2010 at 4:49 pm
I have a problem with the word "NEVER."
I can see where databases may change names from environment to environment. Ideally, they should have the same name from one 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
July 13, 2010 at 4:46 pm
Anybody have any comments on this nugget?
•Never include a USE <database> statement in scripts.
I just found this in a doc here at work.
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 13, 2010 at 3:54 pm
Salivation
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 13, 2010 at 3:53 pm
damnation
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 13, 2010 at 3:43 pm
WayneS (7/13/2010)
WayneS (7/12/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 13, 2010 at 3:42 pm
Wayne,
What are the service accounts being used for SQL Server Agent? (Domain, local, or network service)
Do you have logging enabled?
Can you open and edit the maint plans? Export...
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 13, 2010 at 3:42 pm
ornery
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 13, 2010 at 3:09 pm
Your 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
July 13, 2010 at 12:09 pm
Steinbrenner DEAD
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 13, 2010 at 10:01 am
Viewing 15 posts - 13,336 through 13,350 (of 19,560 total)