Viewing 15 posts - 44,071 through 44,085 (of 49,552 total)
Pretty much what I'd do.
If you're not going to use schemas, put the objects in the dbo schema and set all the users' default schemas to dbo.
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
October 1, 2008 at 2:38 pm
Is something else perhaps reading the error log file? An anitvirus, a text file, some other process?
p.s. could you please edit your post to fix the width?
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
October 1, 2008 at 2:34 pm
Appropriate indexes?
Not really enough info. Can you post the table structure, the existing indexes and the query. Also an idea of the number of rows in the table would help.
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
October 1, 2008 at 2:32 pm
DBCC CHECKDB( < Database name > ) WITH NO_INFOMSGS
Post the output here, and we can help you interpret it.
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
October 1, 2008 at 1:57 pm
Apparently the issue was related to bug no. 6646512, whatever that is. 😉
The creation of the publication now runs in a reasonable time, but the log reader's still timing out....
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
October 1, 2008 at 1:56 pm
dithebe (10/1/2008)
Just curios - can you elaborate on this statement "8 CPUs and 4GB memory seems an odd combo. "
Normally SQL systems that I see have 2 or 4 GB...
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
October 1, 2008 at 1:51 pm
Maxer (10/1/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
October 1, 2008 at 12:59 pm
See this blog post, specifically the first section "SQL Server Uses One Thread Per Data File"
http://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.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
October 1, 2008 at 10:47 am
Milu (10/1/2008)
Gail,Can you please Explain with a situation where you wants to use the table variable and temp table..
As has been said before in this thread, if the table variable...
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
October 1, 2008 at 10:46 am
bcronce (10/1/2008)
GilaMonster (9/26/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
October 1, 2008 at 10:36 am
Maybe. It's worth testing, however in 2005 and higher, the optimiser has the same options for optimising an 'or' as it has optimising a 'union', and there's a good chance...
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
October 1, 2008 at 10:32 am
Milu (10/1/2008)
I got so many new concepts from both of your post..thanks you a lot to both of you. but still i am in dark on my...
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
October 1, 2008 at 10:30 am
pavankumar.mvs (10/1/2008)
I am new to sql server 2005. I have few questions to the forum, Please give me the solutions.
1). My database is running fine all...
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
October 1, 2008 at 9:04 am
Maybe.
It depends on whether the clustered index is useful for the queries that are causing the locking. All tables should have a clustered index and 0 or more nonclustered indexes,...
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
October 1, 2008 at 9:01 am
Wilfred van Dijk (10/1/2008)
Clustering is a failover system for your server (not for your storage), while mirroring is a failover for your complete environment.
Mirroring is a failover for a...
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
October 1, 2008 at 8:58 am
Viewing 15 posts - 44,071 through 44,085 (of 49,552 total)