Viewing 15 posts - 8,161 through 8,175 (of 49,552 total)
Please note: 9 year old thread.
Shrink works in lots of little transactions, so there's little chance of a rollback taking forever. A database recovery after a restart won't take forever,...
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
August 11, 2014 at 3:32 pm
Why?
If you're copying data from one table to another on the same server, you would use INSERT ... SELECT, not bulk insert. Bulk insert is for when you're starting...
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
August 11, 2014 at 2:59 pm
Are tasks added one at a time, or will you get batches of a lot of tasks in one insert?
Is it a crisis if the groups aren't perfectly balanced?
Just so...
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
August 11, 2014 at 2:45 pm
That's not what BULK INSERT does.
Bulk insert, specifically and only, loads data from a file (text file usually, or comma-separated value) in the file system into a database table. 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
August 11, 2014 at 2:31 pm
So if you've checked MSDN, seen the syntax description and looked at the examples at the bottom of the page, what specifically are you stuck with?
What have you got so...
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
August 11, 2014 at 2:02 pm
Why not a unique constraint when all you're doing is enforcing uniqueness? Using a trigger for what a constraint does is poor design and a bad idea
As for what you...
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
August 11, 2014 at 1:09 pm
Jeff Moden (8/11/2014)
Now that would be nice in "regular" T-SQL.
Err.. It is in regular T-SQL, from SQL 2014 onwards.
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
August 11, 2014 at 1:00 pm
You're looking on the wrong page, the page you linked to is for Azure databases, where I assume this feature doesn't exist. If you look at the CREATE TABLE page...
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
August 11, 2014 at 12:22 pm
Three things immediately obvious:
1) This trigger can't handle multiple rows being inserted or updated.
2) A unique constraint on AlphanumericCol would probably be a better option
3) It's written more like an...
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
August 11, 2014 at 9:07 am
Microsoft holds the copyright on MSDN. Stuff on Linked In will either be the author of the piece or Linked In themselves, depending on the agreements.
The point is, unless you're...
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
August 11, 2014 at 7:23 am
Ed Wagner (8/11/2014)
It would be another layer of security, but a captcha on the new thread screen could also help eliminate the bot-style posts.
No, please no. Captchas are so annoying...
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
August 11, 2014 at 7:14 am
What can you do?
If he plagiarises a specific blog, the owner of that blog can file a take down request. Same if he does that to an article. If you're...
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
August 11, 2014 at 6:38 am
Gazareth (8/11/2014)
Thanks Gail, that could be why it's 16KB, can't see a table that small needing 2 IAM pages?
Indeed, that's probably the index root page and the IAM.
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
August 11, 2014 at 5:43 am
After step 4 everything was working?
Can you restore the backup again?
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
August 11, 2014 at 5:36 am
What was the exact order things were done in, and what exactly was done?
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
August 11, 2014 at 5:22 am
Viewing 15 posts - 8,161 through 8,175 (of 49,552 total)