Viewing 15 posts - 28,381 through 28,395 (of 49,552 total)
sixthzenz (1/18/2011)
Can anyone explain why it would be more beneficial to store date and time values separately, rather than just using datetime or datetime2 to store the date-related data?
It's not....
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
January 18, 2011 at 10:16 am
Lee Forst (1/18/2011)
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
January 18, 2011 at 10:11 am
Low memory won't cause corruption, poor IO performance won't cause corruption. A disk queue length of 6 is not high. There is something WRONG somewhere in the IO subsystem.
Windows reliability...
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
January 18, 2011 at 10:08 am
No. It could still mean that the IO subsystem is sometimes returning incorrect information and that the retries aren't always enough any longer.
GET SOME DIAGNOSTICS RUN ON THAT IO SUBSYSTEM!!!
An...
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
January 18, 2011 at 6:57 am
Caruncles (1/18/2011)
On Fri 1/14 we got the Event 824 message.
Now you do have a problem.
Run the following, post the full and complete results and get some diagnostics run...
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
January 18, 2011 at 6:25 am
Um, nonclustered indexes ARE the better solution. Unless you like all queries against your tiny table (50 rows? Seriously?) to execute with a table scan.
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
January 18, 2011 at 6:23 am
SequelSurfer (1/18/2011)
The 'biggie' is the last reference which...
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
January 18, 2011 at 6:18 am
There's a chapter (maybe 2) in a book: Inside SQL Server 2005: T-SQL Queries by Itzik Ben-Gan
Excellent book.
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
January 18, 2011 at 5:25 am
It clears the procedure cache. On a test server that shouldn't cause any problems.
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
January 18, 2011 at 4:58 am
It needs to sort because it's dealing with two sets of data, from the two queries, based on two different tables in the union. Also the query probably won't be...
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
January 18, 2011 at 4:53 am
Consider a nonclustered index on (JobCardID, StageID, SubJobID, IsActive, CompletedDate, QueueID)
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
January 18, 2011 at 4:51 am
Is that the version of the server it does work on or the version of the server it doesn't work on?
Can you post the version of the other one?
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
January 18, 2011 at 4:50 am
Your code works fine on SQL 2008.
Error 173 says nothing about unique constraints. It's text is:
The definition for column '%.*ls' must include a data type.
Can you post the full and...
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
January 18, 2011 at 3:22 am
Table and index definitions please (crate table, create index)
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
January 18, 2011 at 3:03 am
kthanigaivel (1/17/2011)
any solution to reduce clustered index scan without introducing non-clustered index?
No. Why don't you want a non-clustered index?
Turn traceflag 1222 on. That will write a deadlock graph into the...
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
January 18, 2011 at 2:00 am
Viewing 15 posts - 28,381 through 28,395 (of 49,552 total)