Viewing 15 posts - 376 through 390 (of 408 total)
Krishna -
Now I get it! You need a paging method - returning that many rows to the client, whether a desktop application or web page, isn't a real good idea and...
October 19, 2005 at 10:56 am
Nethervoid -
Is your "lead" a geek/technical or what?
If there is one common thread I'm seeing here it's that you want to get any version of SQL Server but MSDE for...
October 19, 2005 at 10:23 am
ApexSQL has a nice product as well, frequently advertised here.
There are lots of others as well, a quick Google for "sql server database compare" will find you a whole bunch. ...
October 19, 2005 at 1:46 am
Wow - not funny at all!
Unless you enjoy banging your head against the IT Juggernaut on a frequent basis you need to figure out a way to make...
October 19, 2005 at 1:36 am
3.3 Million rows in 15 seconds isn't slow, it's screaming!
If you're getting that much data to your desktop that quickly I'd be pleased as punch.
Joe
October 18, 2005 at 11:56 am
Assuming that your vendor can't come up with a quick fix (e.g. rewrite the application to use stored procedures) you're probably stuck with tuning what you can.
The usual...
October 18, 2005 at 11:50 am
Krishnan -
Yelena is right, there is no way to completely remove the ability to modify the data. Someone has to be able to get in and work with the plumbing! ...
October 18, 2005 at 11:20 am
Linda -
Is the application in question written specificially for SQL Server or does it support multiple database platforms?
You may have a situation...
October 18, 2005 at 10:58 am
Cullen -
The term transaction is right on the money, search for "Begin Transaction" in your sql server books online - a series of stored procedures with the appropriate begin transaction,...
October 15, 2005 at 1:16 am
Claudia -
4 hours for 260MB (big B = byte) over what sounds like a 256Kb/sec (little b=bit) connection isn't unreasonable when you take into account overhead, other traffic on the...
October 14, 2005 at 10:33 am
Depending on the complexity of the database it's sometimes faster to just dump the data out to disk via bcp, truncate the tables, drop indexes, shrink the database to the...
October 14, 2005 at 1:45 am
Couple of caveats w/ setuser, only works with SQL Logins (no windows/integrated security accounts) and must be executed by a sysadmin/sa.
October 14, 2005 at 12:41 am
Forgot one thing in my previous post, integrated security will most likely not work w/ a cross-connect cable, you'll need to use standard/SQL security (e.g. UID=X,PWD=Y in your connection string,...
October 13, 2005 at 3:26 pm
Jacob -
Before you go banging your head on this thing for too long... If you intend to use a cross-connect cable you're going to have to go manual for a...
October 12, 2005 at 10:19 pm
Viewing 15 posts - 376 through 390 (of 408 total)