Viewing 15 posts - 33,421 through 33,435 (of 49,552 total)
stefan.gustafsson 60897 (3/18/2010)
Anyway, I do not think you will ever have range scans with GUID:s. Looking up a specific value will work perfectly even if the index is heavily fragmented.
Sure...
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
March 18, 2010 at 7:40 am
stefan.gustafsson 60897 (3/18/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
March 18, 2010 at 7:24 am
What are min and max server memory set to?
How are you monitoring how much memory SQL is using?
What's the value of Total Server Memory and Target Server Memory? (Perfmon counters)
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
March 18, 2010 at 7:21 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885461-146-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
March 18, 2010 at 7:19 am
stefan.gustafsson 60897 (3/18/2010)
The easiest way to fix the problem is to make the index clustered instead of non-clustered. This would definitely solve the problem.
It would fix it, but GUIDs are...
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
March 18, 2010 at 7:14 am
Adding or altering indexes invalidates cached plans based on the base table that the index is defined on. Next time the query runs, the plan will be recompiled.
It's easy enough...
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
March 18, 2010 at 7:10 am
The Dixie Flatline (3/18/2010)
A Elbereth GilthonielSilivren Penna Miriel
Enna Aglar Elenath
Gilthoniel, a Elbereth
We remember, we who dwell
In this far land, beneath the trees
The starlight on the western seas.
From memory, that's...
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
March 18, 2010 at 6:55 am
I don't think I ever memorised the 1 Ring in Black Speech. English, sure.
There's a large number of his verse that I can still remember almost perfectly. don't know what...
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
March 18, 2010 at 6:39 am
There's at least 2 of tolkien's languages that are published and are usable (though maybe a little short of technical vocab) Quenya and Sindarin. I dug through the details 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
March 18, 2010 at 6:11 am
That's 2 out of the 4 tables.
Please just post the script in the forum directly rather than in attached word docs.
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
March 18, 2010 at 6:02 am
You have to drop them. A disabled foreign key is still a foreign key and a table referenced by a fk cannot be truncated.
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
March 18, 2010 at 4:33 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic885305-148-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
March 18, 2010 at 4:25 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
March 18, 2010 at 4:25 am
The compatibility level affects how the query processor handles some query constructs and whether or not some features are allowed or not. Mostly is disallows features that changes the meaning...
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
March 18, 2010 at 4:18 am
You cannot lose data in a detach/attach. SQL Server supports the ACID requirements for relational databases. D stands for durability, meaning once a transaction has committed, the changes that transaction...
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
March 18, 2010 at 2:08 am
Viewing 15 posts - 33,421 through 33,435 (of 49,552 total)