Viewing 15 posts - 47,461 through 47,475 (of 49,552 total)
Looks like you've mostly got it under control.
Regarding those 3 older indexes, and looking at what you've said, I'd suggest the following.
nclidx_JOBS_Live_TempMode_FeatureScore - Change to Live, TempMode, SiteFK, LiveDate,...
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
February 4, 2008 at 9:05 am
Please do not cross post. It wastes people's time.
Please direct replies to the following thread -
Error in parameterised query (SQL 2000)
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
February 4, 2008 at 8:15 am
Not exactly. The OP admits that he posted in the wrong forum initially and reposted in the 2000 forum after you replied.
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
February 4, 2008 at 8:10 am
Since this was reposted in the SQL 2000 forum, please direct replies there.
Select distinct.. order by newID() (SQL 2000)
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
February 4, 2008 at 7:53 am
Is that error written into the SQL error log? What's the message that you get?
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
February 4, 2008 at 6:28 am
Could you post the code that you're using for the time calculation please. Along with any tables that it uses, sample data and expected output.
See http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
February 4, 2008 at 6:22 am
Rob Reid (2/4/2008)
which I created a non clustered index with ClientFK,JobFk,Live (in that order)I then replaced the COUNT(JobPk) with COUNT(*) and dropped the JobPk
Looks pretty good. If you had left...
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
February 4, 2008 at 6:09 am
With the table structure you've given, there's no way to tell 100% which days are holidays. It's easy to tell which days are not work days (SELECT dt FROM Calender...
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
February 4, 2008 at 5:48 am
You're getting stack dumps and hung schedulers. I would suggest you contact PSS (microsoft product support) and log a case with them.
I doubt this is anything that we can...
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
February 4, 2008 at 5:39 am
And one thing to note about the procedure cache is that only one session may put a specific proc in the cache at a time.
If you have multiple users recompiling...
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
February 4, 2008 at 5:35 am
What problems are you having?
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
February 4, 2008 at 5:27 am
Could you post that other query please Rob?
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
February 4, 2008 at 5:18 am
Could you give the expected output 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
February 4, 2008 at 4:04 am
I'm not sure I fully understand your question. What does the code you've written do that it's no supposed to do, or not do what it's supposed to do?
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
February 4, 2008 at 1:18 am
Please don't cross post. It's not necessary, the regular's read all the forums. It also fragments replies and wastes people's time.
Discussion to the following thread please - http://www.sqlservercentral.com/Forums/Topic451025-338-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
February 4, 2008 at 1:14 am
Viewing 15 posts - 47,461 through 47,475 (of 49,552 total)