Viewing 15 posts - 6,016 through 6,030 (of 11,678 total)
Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂
December 27, 2012 at 11:19 pm
chandan_jha18 (12/27/2012)
Removing non clustered index does give me benefit of 40 min-1 hour but then when I create them it will compensate for the gain that I got:-)Thanks
Chandan
Yes, but you...
December 27, 2012 at 6:58 am
Ah yes, update is fully logged. But when using simple recovery model you have (somewhat) less worries about the transaction log eating all your disk space.
Maybe you can write your...
December 27, 2012 at 5:19 am
pirrot (12/26/2012)
December 27, 2012 at 4:52 am
There are several options:
* recreating the table like you did before, but not with SELECT INTO, and using the simple recovery model.
* updating the table in batches: do the update...
December 27, 2012 at 4:49 am
Krtyknm (12/27/2012)
I don't think MERGE statement is available in SQL Server 2005. Hope it should read SQL Server 2008.
It isn't. Hence the smiley 😉
December 27, 2012 at 4:46 am
Is this consistent behaviour? If you run the import/export wizard again for that single table, does it fail again?
December 27, 2012 at 3:11 am
W00t :w00t: 7 easy points! 🙂
Merry christmas, channukah, druidfest etc. for everyone!
December 26, 2012 at 11:44 pm
Checked 1 and 4 and then stopped thinking because I only had to select two 😀
December 26, 2012 at 11:40 pm
There's a MERGE statement in SQL Server 2005? 😉
December 26, 2012 at 11:34 pm
Bugger. All the time dimensions in my data warehouses just went to the 21st. Now I'll have to add more years. What's the next doomsday?
December 22, 2012 at 12:06 am
ChrisM@Work (12/21/2012)
Anybody out there?
Yes, but I'm very busy fighting off the zombie apocalypse.
December 21, 2012 at 2:21 am
Viewing 15 posts - 6,016 through 6,030 (of 11,678 total)