Viewing 15 posts - 38,581 through 38,595 (of 49,552 total)
homebrew01 (6/8/2009)
If we do, is there a way to repair the fragmentation damage that occurs ?
Internal (index) fragmentation or external (file) fragmentation?
For the first, rebuild your...
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
June 8, 2009 at 2:11 pm
David (6/8/2009)
Basically I'm trying to calculate the Median of a set of values. At the moment the sort order is causing problems because the values are in the wrong order.
If...
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
June 8, 2009 at 2:08 pm
Just for interest, it's usually recommended that the backup be done to local disks and then copied to the network. Firstly because of the speed of local drives vs 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
June 8, 2009 at 12:58 pm
Just so you know, it is strongly not recommended that SQL run on a NAS. I'll find kb article if you like, or you can search yourself (I'd have to...
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
June 8, 2009 at 12:55 pm
darth.pathos (6/8/2009)
but was looking for more in-depth (ie. Geeky ;-)) information about them.
Not sure what you're looking for. What's normal for pages/sec depends greatly on the app. 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
June 8, 2009 at 12:24 pm
I'm sure it was. Don't recall where it's set though.
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
June 8, 2009 at 12:13 pm
SuzDBA (6/8/2009)
Any other quick global setting that I haven't stumbled upon that might be out there?
Nope.
Enforce through triggers, enforce through stored procedures (and make sure nothing directly accesses the table)...
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
June 8, 2009 at 12:12 pm
RBarryYoung (6/8/2009)
EdVassie (6/8/2009)
If you are asked 'Is anyone in the office wearing a red shirt' what do you do?
Well the first thing that *I* do when asked this is to...
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
June 8, 2009 at 12:10 pm
SK (6/8/2009)
Fortunately and unfortunately, this is my first go-round with a currupt/suspect database. Paul's links and references have been great thus far, but I'm kind of stuck.
Emergency mode repair...
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
June 8, 2009 at 12:09 pm
Dilip Nagle (6/8/2009)
I was under impression that the SQL Server writes Transaction Log in 1st file sequentially and when it is full, it starts writing Transaction Log in 2nd file.
2....
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
June 8, 2009 at 10:54 am
ps (6/8/2009)
Use DDL Trigger.
DDL triggers do not fire for data changes. They fire for DDL (data definition language) changes 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
June 8, 2009 at 10:46 am
There's no ORDER BY on that query so you can make absolutely no assumptions about the order the data will be returned in. If you want a specific order, add...
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
June 8, 2009 at 10:44 am
What you can do is use profiler (or a server-side trace) to see what the IOs are like for frequently run queries. High IOs may indicate inefficient queries or 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
June 8, 2009 at 10:39 am
Lynn Pettis (6/8/2009)
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
June 8, 2009 at 10:38 am
Sorry, os shouldn't have been there. sys.dm_tran_locks. Run it in the DB in question, not in master.
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
June 8, 2009 at 10:34 am
Viewing 15 posts - 38,581 through 38,595 (of 49,552 total)