Viewing 15 posts - 45,091 through 45,105 (of 49,552 total)
I'm not sure about speeding the query up, it's based off system tables and system views which you cannot change.
That said, 50 indexes and 230 statistics on a single table?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 8:11 am
What's the security settings on the linked server "srvr1"?
(In object explorer, Server object -> Linked servers, right click that linked server, choose properties, go to the security tab)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 7:07 am
PhilM99 (8/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 7:05 am
rosh (8/13/2008)
We need to write a stored procedure which works like a search engine.
Have you considered using FullText Search? This isn't an area that the relational engine excels in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:53 am
TEXT is an older datatype, is deprecated in SQL 2005 and will be removed in a future version. Many of the string functions (left, right, substring, replace, etc) don't work...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:49 am
Schadenfreude-Mei (8/13/2008)
yeah think so. certainly they offer sunet desert camel rides etc.
Desert camel rides in Mauritius? Dubai, I could see, but Mauritius is a small tropical island. The only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:43 am
What does the procedure "ap_mtn_Sync_Table_data" do, and what are the security settings of the linked server that it is using?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:37 am
In object explorer, right click the login, select properties, go to status, select disabled, click OK.
Depending where the server is and how you're accessing it, I do prefer windows authentication...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:35 am
Mike Alfa (8/13/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 6:29 am
No need to start a second thread.
Please ditrect replies to the following thread, to keep all the discussion together
http://www.sqlservercentral.com/Forums/Topic551587-360-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 1:00 am
SQL Server has a built-in deadlock detector. When it notices a deadlock it will automatically select one of the processes involved in the deadlock and kill it. There's no need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 12:46 am
Please don't cross post. Many of us read all the forums. 2005-related questions should please only be posted in the 2005 forums to avoid confusion.
No replies to this thread please....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 12:35 am
Have you considered disabling the sa login?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 12:26 am
The latest cumulative update (CU 8) is build 9.00.3257
Ref: http://www.sqlservercentral.com/articles/Administration/2960/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2008 at 12:26 am
Selects or just data modifications? The latter, consider a trigger. For the former, you'll probably have to use profiler.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 12, 2008 at 3:23 pm
Viewing 15 posts - 45,091 through 45,105 (of 49,552 total)