Viewing 15 posts - 35,251 through 35,265 (of 49,552 total)
one-1016367 (12/16/2009)
I wasn't aware that I could get the same row more than once, in which scenario could that happen?
The link I gave you when I first asked...
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
December 16, 2009 at 5:58 am
It would depend on specifics of the app and server, but I'd say 6 months, maybe. Not just one month though. More than that.
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
December 16, 2009 at 5:49 am
one-1016367 (12/16/2009)
Yes, we are confident using nolock in the given scenario.
You are aware that there is a chance it can can cause rows to be returned more than once, rows...
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
December 16, 2009 at 5:35 am
Ratings?
Points are given for posting or for correctly answering the question of the day. When your points are high enough (see the thread I referenced for the thresholds) your title...
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
December 16, 2009 at 5:33 am
Have a look here. Example B is almost exactly what you want to do.
http://msdn.microsoft.com/en-us/library/ms186734.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
December 16, 2009 at 3:54 am
Lennart Gerdvall (12/16/2009)
And, do you people never delete old data not used.
Sure, and if that old data that has been removed creates free space that will not be reused...
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
December 16, 2009 at 3:44 am
No risk, just watch what you pick as the clustering key. A bad choice and everything might slow down a lot.
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
December 16, 2009 at 2:41 am
Just an aside, are you really sure that you want to be using nolock around financial transactions? I've worked in banks before, they're not usually happy with the possibility of...
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
December 16, 2009 at 2:40 am
I'd start by using RowNumber partitioned by the jobid and ordered by the date. Then you can select where that is <=10
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
December 16, 2009 at 2:40 am
Have a look at the QUOTENAME function. It should do what you want.
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
December 16, 2009 at 1:10 am
Braindumps are questions taken from the exam, in violation of the NDA that anyone writing the exam has to accept. Using braindumps is cheating and using or distributing them 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
December 16, 2009 at 1:09 am
See here: http://www.sqlservercentral.com/Forums/Topic447796-4-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
December 16, 2009 at 12:24 am
Sorry, don't understand your question. Can you explain more?
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
December 16, 2009 at 12:23 am
Can you post the entire error message and any other relevant details (like what the job does)?
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
December 16, 2009 at 12:23 am
I said it was a start.
The index is not covering, that's why you're getting key lookups. It's very expensive to cover a query that selects all columns. Hence the first...
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
December 16, 2009 at 12:18 am
Viewing 15 posts - 35,251 through 35,265 (of 49,552 total)