Viewing 15 posts - 23,251 through 23,265 (of 39,917 total)
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
I don't see the administrative value of instances. It might make security separation easier, but anything else gets more complex. I guess you get administrative skills beefed up, but it's...
July 10, 2009 at 11:41 am
I don't think location matters. I'm not familiar with anyone wanting to know if you got your certification training from a university v some training center.
The issue will be experience....
July 10, 2009 at 11:38 am
The default trace is always on. That's why it's named that.
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
Server side tracing, it's in books online. It's not too hard to set up, but a little tedious. I believe...
July 10, 2009 at 10:30 am
I believe that you will need to restart.
If you limit memory, SQL Server will have less to work with. That can affect performance, but there's no way to know how...
July 10, 2009 at 10:14 am
Viewing 15 posts - 23,251 through 23,265 (of 39,917 total)