Viewing 15 posts - 23,146 through 23,160 (of 39,821 total)
There are some new events in Profiler/Trace to help with this. Otherwise, not sure there's a list. I'll post this around.
July 13, 2009 at 10:18 am
I'm with Grant. The DTA gives you a place to start, especially if you're not sure where, but I wouldn't trust it much beyond using it for suggestions that I'd...
July 13, 2009 at 10:17 am
This is 32bit, right?
I wonder if SQL Agent has a limitation. Keep in mind that Agent is a separate system from SQL Server. It's a different process.
July 13, 2009 at 10:07 am
Most of these products will probably deploy the same way you did, they'll send a script through to SQL Server.
There isn't a shortcut here. Not that I'm pushing you away...
July 13, 2009 at 10:06 am
The Inside SQL Server book is a great reference and it talks about this. There are in place updates, which just change the data in row, and there are updates...
July 13, 2009 at 9:58 am
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
Viewing 15 posts - 23,146 through 23,160 (of 39,821 total)