Viewing 15 posts - 8,161 through 8,175 (of 49,571 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,...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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...
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...
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.
August 11, 2014 at 5:43 am
After step 4 everything was working?
Can you restore the backup again?
August 11, 2014 at 5:36 am
What was the exact order things were done in, and what exactly was done?
August 11, 2014 at 5:22 am
Viewing 15 posts - 8,161 through 8,175 (of 49,571 total)