Viewing 15 posts - 37,861 through 37,875 (of 49,552 total)
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/Topic747530-150-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
July 6, 2009 at 1:50 am
Lynn Pettis (7/5/2009)
I concur, your db design is flawed, and fails the 3NF.
It's violating BCNF if I'm not mistaken. There's no inter-data dependency (so passed 3NF) but there is 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
July 6, 2009 at 1:50 am
There's a chance that will cause duplicate key errors under heavy load. Two queries run at the same time, both do the SELECT MAX and get the same value (shared...
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
July 6, 2009 at 1:48 am
Check out that Whitepaper I mentioned. I don't know it's location offhand, but a search for "Paul Randal" and filestream should turn it up.
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
July 6, 2009 at 1:40 am
Nero (7/5/2009)
hi ,It is giving invalid object name for above query.
We have sql server 2000...
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post...
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
July 6, 2009 at 1:40 am
Check out that Whitepaper I mentioned. I don't know it's location offhand, but a search for "Paul Randal" and filestream should turn it up.
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
July 6, 2009 at 1:30 am
Check out that Whitepaper I mentioned. I don't know it's location offhand, but a search for "Paul Randal" and filestream should turn it up.
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
July 6, 2009 at 1:25 am
Check out that Whitepaper I mentioned. I don't know it's location offhand, but a search for "Paul Randal" and filestream should turn it up.
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
July 6, 2009 at 1:22 am
WayneS (7/3/2009)
GilaMonster (7/3/2009)
You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.
chuckle...
Makes one...
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
July 5, 2009 at 1:26 pm
paulneyman (7/5/2009)
I can not reorganize DB structure.
Why not?
As I've understand it can be solved only using trigger... so can someone show how to do this. Or if there 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
July 5, 2009 at 1:18 pm
ps (7/5/2009)
The only condition i can think of is the affected pages must not have been changed after the full backup from which i'm trying to restore.
That's not 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
July 5, 2009 at 1:13 pm
paulneyman (7/5/2009)
I see your point, but the code I wrote is not a real DB structure.You solution does not suit.
Would it be possible for you to show us the real...
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
July 5, 2009 at 11:24 am
The backup in question has been striped across two files, with half the backup in each one. This commonly happens by accident when backing up through management studio. If there...
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
July 5, 2009 at 10:03 am
Maximum capacity specifications
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
July 5, 2009 at 10:01 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic747333-338-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
July 5, 2009 at 6:09 am
Viewing 15 posts - 37,861 through 37,875 (of 49,552 total)