Viewing 15 posts - 23,266 through 23,280 (of 39,936 total)
Do you mean you are using SSMS to save the data?
This produces a text file and the CR/LF should be there.
July 13, 2009 at 9:43 am
There are some clustering videos at JumpstartTV as well:
http://www.jumpstarttv.com/channel.aspx?cat=4a00c49a-6207-4ba8-952c-807481629761
July 13, 2009 at 9:41 am
Look at PIVOT or a cross tab report.
It's not an easy thing to do, especially as what do you do with multiple rows? Are they extended to the right?
July 13, 2009 at 9:39 am
I'm not sure that there is a business reason to upgrade to 2008 from 2005. There aren't a lot of new features, and the new ones, for the most part...
July 12, 2009 at 5:57 pm
The import/export wizard is designed to ad hoc import a file, not process lots of files. When you run the import/export wizard, you can build an SSIS package as the...
July 12, 2009 at 5:55 pm
I'd really recommend that you begin learning SSIS and rewriting these packages.
July 12, 2009 at 5:53 pm
I highly recommend books. Not because they're better than a web site, but because they help you get organized. They progress from topic to topic. Get one and go through...
July 11, 2009 at 2:24 pm
I think Lowell has the answer. Without an ORDER BY, you can NEVER be sure which rows will be returned or deleted (or updated), but a TOP or SET ROWCOUNT...
July 11, 2009 at 1:16 pm
If the databases have the need to share data, then it makes sense to consider one large database. I've seen separate applications that need to share data, but had separate...
July 11, 2009 at 10:27 am
Any logic for leaving 4GB for the OS? Does it need it in 64bit?
Or would you be OK running to 30GB for SQL?
July 10, 2009 at 4:36 pm
grumble, don't get me started, Jack. I've wanted that (with FB/LI) for some time
July 10, 2009 at 2:12 pm
I've used full, but that's worked well for me. I typically haven't had bulk loading occurring, so there's no savings.
with mirroring, I'm not sure you save anything. The same data...
July 10, 2009 at 1:28 pm
Well, it's an interesting debate. I can understand why dbforums might think it is worth closing it, but I think it goes against my grain to do so.
My feeling in...
July 10, 2009 at 12:27 pm
Viewing 15 posts - 23,266 through 23,280 (of 39,936 total)