Forum Replies Created
Viewing 15 posts - 35,551 through 35,565 (of 39,720 total)
-
RE: Insert into select from taking hours (URGENT))
Good suggestions above, one other point. If the database grows during the insert, while it grows, ALL activity stops. That could be the issue. Has the extra long time occurred...
-
RE: Yukon DTS packages
Not sure about all the changes, but we have an article coming in the Jan issue of SQL Server Standard (http://www.sqlserverstandard.com/). Not that helps you internationally, but maybe we'll get...
-
RE: Yukon Release Dates
That's about what we got at PASS. Feeling was that late 2004 might be ambitious. Might be early 2005.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: How to schedual DB integrity checking seperately
Is this SQL2000? checkdb runs better with this version, but it still takes some resources. It also runs for the whole db.
you can change some options, see BOL for them.
Steve...
-
RE: EM not showing Databases or Management
Something must be wrong with EM. Have you applied SP3? Might want to reapply to your workstation.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Passing parameters from a Trigger to DTS
how are you running the DTS job? xp_cmdshell/dtsrun or sp_Start_job?
In general I'd say that this is a bad idea.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Using ERWIN data Modeller
I think you need to set a new connection. Then enter the values for server, db, etc.
I had an older version of Erwin and I don't remember this being that...
-
RE: Usage Memory in SQL
SQL will take as much memory as it needs and balance itself with other applications, though this can be slow. The OS should manage this, but it might not work...
-
RE: Moving databases to new development box
sp_attach is one of the two best ways, depending on whether you can tolerate downtime. Backup/restore is the other.
Don't use the wizard, IMHO it doesn't work well.
the other thing you...
-
RE: Very minor web site spelling "mistake"
done. Any more, my valued copy editor?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Duplicate Indexing Woes
Perhaps the best plan is not to use Sysmaint, but it's a quick and easy and relatively foolproof way to ensure a server is setup quickly. Especially when we have...
-
RE: add new user with rights using TSQL
Add them to the db role "datareader". This can be done with T-SQL
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Query Analyzer - Licensing
I think you can install QA, but your access to the server requires a CAL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Storing Binary Data
Use the varbinary data type.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: ORACLE !
Good luck! I manage 3 SQL DBAs, 4 DB2 DBAs, and 2 Oracle and boy do we get some good debates going! Enjoy.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
Viewing 15 posts - 35,551 through 35,565 (of 39,720 total)