Viewing 15 posts - 31,051 through 31,065 (of 49,552 total)
Alvin Ramard (8/25/2010)
GilaMonster (8/25/2010)
Anyone want to help an apparent newbie to create a critical, large database?http://www.sqlservercentral.com/Forums/Topic975128-1292-1.aspx
If he's doing this for my bank, then I'm changing bank! :w00t:
Mee too.
I just can't...
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 25, 2010 at 1:58 pm
Anyone want to help an apparent newbie to create a critical, large database?
http://www.sqlservercentral.com/Forums/Topic975128-1292-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 25, 2010 at 1:43 pm
If you want to completely avoid locking, you'll need to move all indexes, clustered and nonclustered to the new filegroup. You can move all with CREATE ... WITH DROP EXISTING,...
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 25, 2010 at 12:49 pm
EasyBoy (8/25/2010)
Then later i compare Wk1 with Wk2 to see which index are unchanged and i have to drop the index that are unchanged.
What happens to indexes that are 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 25, 2010 at 12:24 pm
Create a second filegroup and make it the default filegroup. Put all the tables into that filegroup. Set the filegroup readonly. Then you can still alter the procs (they're 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 25, 2010 at 12:22 pm
Humayoon Khan (8/25/2010)
True, you can't read transaction log.
You can. It's not easy to understand, but you 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
August 25, 2010 at 12:17 pm
Why? What problem are you trying to solve here?
All data modifications are logged in the transaction log, but it is not intended as an audit log, it's not easily readable.
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 25, 2010 at 5:55 am
Asked with a lot of discussion and work done here : http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149262
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 25, 2010 at 5:55 am
I'm gonna guess that you didn't read the article I referenced. Please 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
August 25, 2010 at 5:43 am
Please post table definitions, sample data and expected results as per 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
August 25, 2010 at 4:53 am
No, it's not corrupt.
Quite likely you have a very large number of VLFs, which results in slow restart-recovery of the database.
http://sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.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 25, 2010 at 3:29 am
pankushmehta (8/24/2010)
beejug1983 (8/24/2010)
How can I get these CPU, Network & Memory details ? Can you guide me ?
You can use a profiler or one of the Set Statistics [time /...
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 24, 2010 at 11:40 pm
mdp11 (8/24/2010)
so that I can make sure index I am going to create on table is not going to create any negative impact on performance.
Number of updates is not going...
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 24, 2010 at 11:39 pm
Sqlchicken (8/24/2010)
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 24, 2010 at 11:35 pm
It'll have to be a HASH join, it's advertised as the one that handles large numbers.
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 24, 2010 at 4:40 pm
Viewing 15 posts - 31,051 through 31,065 (of 49,552 total)