Viewing 15 posts - 34,786 through 34,800 (of 49,552 total)
And I've seen many where the developers thought it worked like a charm until suddenly there were duplicate key errors.
If you insist on maintaining the sequence yourself you've got...
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 12, 2010 at 7:56 am
Why overwrite at all? Each log backup to an individual file, each full backup to an individual file. Then there's no chance of overwriting the wrong file, they 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
January 12, 2010 at 7:37 am
Dugi (1/12/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
January 12, 2010 at 7:32 am
I stand by what I said earlier. What happens if shortly after the full backup you find that a table something has messed up data and you need to restore...
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 12, 2010 at 7:10 am
I have never posted such a link because, as far as I know, there's no legal downloadable eBook of any of the Inside SQL Server series. Go and buy 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
January 12, 2010 at 7:05 am
I would rather suggest one file per backup. That way you don't overwrite every day. Problem with your design is, say 20 minutes after you did the backup with init,...
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 12, 2010 at 6:52 am
repent_kog_is_near (1/12/2010)
I do not (yet) use that trace. Do you recommend it?
Have you looked up that traceflag (search engine of your choice)? Have you examined info given regarding when...
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 12, 2010 at 6:33 am
Dugi (1/12/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
January 12, 2010 at 6:31 am
First things first, that trigger will not work correctly when more than one row is inserted into the table. You're selecting values from the inserted table into variables, what's 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
January 12, 2010 at 5:39 am
Dugi (1/12/2010)
usually the tables cannot have 2 billion records
Why do you say that? There's no inherent restriction that stops tables from having 2 billion rows. It's easily possible on larger...
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 12, 2010 at 5:36 am
That's not a limitation of identity. That's a limitation of the data type you used on that column. As I said, identity is not a data type. The data type...
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 12, 2010 at 5:03 am
What do you mean by 'limit'?
Identity is not a data type, it's just a property of a numeric column. You can set identity on an int column for a max...
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 12, 2010 at 4:56 am
Can you be more specific? Sample for what regarding locking?
All SQL queries take locks without you having to do anything. In the default isolation level shared locks are released as...
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 12, 2010 at 4:45 am
No way to ensure that in SQL 2000/2005. Just make sure the backups are secured so that unauthorised people can't get at them.
The post was in the SQl 2008 forum,...
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 12, 2010 at 4:42 am
huhaoranxing (1/12/2010)
But I guess there should be a parse tree before generating the query plan.But the tree's format is a secret to us,do you known anything about it?
If it'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
January 12, 2010 at 4:41 am
Viewing 15 posts - 34,786 through 34,800 (of 49,552 total)