Forum Replies Created
Viewing 15 posts - 6,166 through 6,180 (of 7,505 total)
-
RE: Restore v Detach/Attach
actualy you can name your backup files whatever you want.
And in fact, you can also name your sqlserver db-files whatever you want.
If you stick with the guidelines of using the...
-
RE: Cluster IP Address Change
Thumbs up for Collin !
In theory it should be done using Cluster Administrator.
"How to change the network IP addresses of SQL Server virtual servers" :
http://support.microsoft.com/kb/244980/
http://support.microsoft.com/kb/230356
SQLServer itself does...
-
RE: Lots of unused space
indeed sp_updatestats and dbcc updateusage should be part of your maintenance job !
and like you experianced, should also be the first step when...
-
RE: Lots of unused space
Keep in mind dbcc dbreindex will keep a lock on your table, so others may not be able to use it during the reindex !
If you have updates/deletes on your...
-
RE: Lots of unused space
- Did you define indexes for this table ?
- Lets hope you also defined a (unique if possible) clustering index.
- you may want to schedule maintenance for the database/table
(or write...
-
RE: Few Questions
Books online "Maximum Capacity Specifications"
---> Standard Edition max 2Gb
-
RE: Sql Query Optimization
just my 2 Ct
-
Avoid predicates containing functions !!! (e.g. SUBSTRING
-
RE: Some clients cann''''t connect to QSL server after restarting SQL service
you should use Cluster Administrator to stop/start all clustered applications !!!
Clustermanager loose connectivity info an try to failover ... it the stop/start is taking more than a "isalive"-poll-interval.
-
RE: Some clients cann''''t connect to QSL server after restarting SQL service
- How about the connection-pools ? Did they reach the timeouts ?
- Did the users stop and start their applications ? or just tried executing some stuff with the ongoing...
-
RE: Some clients cann''''t connect to QSL server after restarting SQL service
did you restart the services using CLUSTER MANAGER ?
If not, that will be your problem.
-
RE: Beware of Search Argument (SARG) Data Types
And probably INTEGER would be mutch faster
and preferable because you have precision 0. -
RE: Want to change logical file name.
I was probably updating my previous reply whilst you replied to it
It does not need to be in single user mode, but may...
-
RE: Want to change logical file name.
you can modify the LOGICAL filename.
If you want to alter the physical filename , you're stuck with detatch / rename-file (e.g. with explorer) / attatch
from BOL :
- FILENAME
- FILENAME
-
RE: Beware of Search Argument (SARG) Data Types
btw precedence has been changed with sql2000 sp4
Let's hope they don't do that again
-
RE: Beware of Search Argument (SARG) Data Types
add this one to "10 things i wish my developers knew about sql"
Make sure you use the datatype of your columns ! because you avoid your dbms to translate it...
Viewing 15 posts - 6,166 through 6,180 (of 7,505 total)