Forum Replies Created
Viewing 15 posts - 35,641 through 35,655 (of 39,804 total)
-
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...
-
RE: Site Search Takes me to Google for Results?
New, while we're trying to get search working better, we substituted Google for the time being.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Yukon & Log shipping
Log shipping is still there, clustering is better and there is also a new "Database mirror" feature. Haven't tested (yet) so I can't really comment on it, but it looks...
-
RE: What is starting this backup
Alamir's advice should work for you.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Naming Conventions
No real stadnards and MS changes theirs over time as well. I'd pick something (mine or some others) and stick with it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
-
RE: MAXDOP
I believe that they are two views into the same setting.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Proper Data Type
For smaller scale values, I'm not sure it matters which you choose. I use numeric most of the time.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 15 posts - 35,641 through 35,655 (of 39,804 total)