Viewing 15 posts - 6,016 through 6,030 (of 11,676 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 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 27, 2012 at 5:19 am
pirrot (12/26/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 27, 2012 at 3:11 am
It seems there was a network issue.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 27, 2012 at 2:44 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 26, 2012 at 11:56 pm
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 26, 2012 at 11:45 pm
W00t :w00t: 7 easy points! 🙂
Merry christmas, channukah, druidfest etc. for everyone!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 26, 2012 at 11:44 pm
Checked 1 and 4 and then stopped thinking because I only had to select two 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 26, 2012 at 11:40 pm
There's a MERGE statement in SQL Server 2005? 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 21, 2012 at 2:21 am
Viewing 15 posts - 6,016 through 6,030 (of 11,676 total)