Viewing 15 posts - 13,321 through 13,335 (of 19,560 total)
I would love to be able to pull a Derek for those kinds of meetings.:-D
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 14, 2010 at 12:09 am
You need to enable delay validation and also create the temp table in the database during the same ssis session. You should create the temp table earlier in 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
July 14, 2010 at 12:00 am
Nothing particularly required.
You would need to ensure that all of your code is SQL 2005 compliant but there is no single command for that. You should run the upgrade...
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 11:55 pm
I would not permit a client or a vendor to have such permissions on a production server of mine.
I would find an alternative method such as described by Jeff or...
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 11:52 pm
Jeff Moden (7/13/2010)
river1 (7/12/2010)
I execute a command (xp_cmdshell) , but i always receive this error:
Login failed for user 'teste'.
But the user is sysadmin and the password is correct.... and...
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 11:46 pm
Nice article. I think this is sometimes overlooked as a valid method to troubleshoot performance problems. The point is to provide a solution that meets the requirements without...
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 11:39 pm
Check out this thread:
http://www.sqlservercentral.com/Forums/Topic796512-391-1.aspx
There is a script there as well as a link to another thread that has multiple revisions for a script that will do what you are looking...
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 11:14 pm
Jim McLeod (7/13/2010)
CirquedeSQLeil (7/13/2010)
Grant Fritchey (7/13/2010)
This document sounds like it's a doozy.That's an understatement.
On the plus side, it is providing me with good fodder for a blog post.
I love reading...
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:34 pm
Thanks for the article.
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:29 pm
Grant Fritchey (7/13/2010)
CirquedeSQLeil (7/13/2010)
Grant Fritchey (7/13/2010)
CirquedeSQLeil (7/13/2010)
Anybody have a good source concerning the "don't index tables with less than 1000 rows" optimization technique?
It's not 1000 rows, it's a 1000 pages...
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 8:56 pm
Grant Fritchey (7/13/2010)
CirquedeSQLeil (7/13/2010)
Anybody have a good source concerning the "don't index tables with less than 1000 rows" optimization technique?
It's not 1000 rows, it's a 1000 pages and, it's 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
July 13, 2010 at 8:15 pm
Anybody have a good source concerning the "don't index tables with less than 1000 rows" optimization technique?
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 7:07 pm
Grant Fritchey (7/13/2010)
Jeff Moden (7/13/2010)
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...
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 7:01 pm
I am uncertain if this is a good question or not. The point was to error-check. We see that kind of mistake quite a bit in the forums...
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:57 pm
As coldcoffee suggested, use of ObjectProperty is a good reliable source too!
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:45 pm
Viewing 15 posts - 13,321 through 13,335 (of 19,560 total)