Viewing 15 posts - 20,686 through 20,700 (of 49,552 total)
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 30, 2012 at 6:41 am
Plus the absolute entertainment of queries occasionally failing with error 601
No, using nolock on every single query 'just because' is not good practice. There are places it's fine and 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
January 30, 2012 at 5:11 am
For fragmentation - sys.dm_db_index_physical_stats
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 30, 2012 at 5:06 am
Perry Whittle (1/29/2012)
GilaMonster (1/29/2012)
though it's not easy to fix.i'd be interested to hear your fix!
On 2005 - create a clustered index. (don't drop it again)
On 2008 - create a clustered...
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 30, 2012 at 4:57 am
The fragmentation values for a heap are extent fragmentation, not logical fragmentation (heaps can never be logically fragmented). It can still be something to be aware of, though 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 29, 2012 at 4:12 pm
Few other things that appears to be missing from the design:
How do I tell what courses a student has taken?
What about courses that have multiple pre-reqs? How do you record...
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 29, 2012 at 2:26 pm
The first I might be a little concerned, the second not at all.
Logical or extent fragmentation only affects large range scans from disk. Emphasis large. You can't have a large...
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 29, 2012 at 2:24 pm
DBA_SQL (1/29/2012)
On adventureworks 08, when I run a query to see the fragmentation information. I got following result.DBNAME: AdventureWorks
Tablename:ProductModelProductDescriptionCulture
Index Name:PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID
Index Type: CLUSTERED INDEX
AVG_FRAGMENTATION_IN_PERCENT: 75
Page counts: 4
There's your reason right...
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 29, 2012 at 11:18 am
Assuming that SexColumn contains only 'Male' and 'Female' and that PregnancyFlagColumn is a char that is either Y or N, yes.
Just one thing, please give constraints meaningful names.
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 29, 2012 at 9:40 am
There's no IF.. THEN construct in constraints.
The constraint is a logical expression that returns true or false only, no other values
Look at how the first one is done
CHECK (death_date is...
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 29, 2012 at 9:13 am
Feel free to post questions in the forums, we can probably help you figure things out.
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 29, 2012 at 8:58 am
Does this folder exist?
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
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 29, 2012 at 5:35 am
I gave you the correct formulas, you should be able to correct the script given those.
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 28, 2012 at 5:44 am
ananda.murugesan (1/28/2012)
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 28, 2012 at 5:32 am
SQL Kiwi (1/28/2012)
Opinions vary on this, but my own view is that it is only worth creating extra equally-sized tempdb files if you are experiencing allocation contention.
My preference too,...
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 28, 2012 at 5:25 am
Viewing 15 posts - 20,686 through 20,700 (of 49,552 total)