Forum Replies Created
Viewing 15 posts - 36,811 through 36,825 (of 39,944 total)
-
RE: New Hardware - Suggestions wanted
What we do:
RAID 1 for OS
RAID 1 for db logs
RAID 5 for data on some servers, RAID 10 for data files on others
RAID 5 for backup files (if we can...
-
RE: Obfuscating a column
Sure. Not that secure, but easy to do. Want something simple? Roll the letters, replace A with F, B with G, etc.
Or add some # to the ASCII() value of...
-
RE: Number of DBs Supported
Is your dba a network engineer? Be careful here. Someone needs to sniff the network and provide evidence of being "too much work"
Also, what does that mean? Things are slow?
Doesn't...
-
RE: Another Disaster (Almost)
Glad I'm not Andy or the last guy
I've been pretty lucky with very few disasters, and hopefully that will continue.
Steve Jones
-
RE: New Hardware - Suggestions wanted
$50K is pretty good. How is this system used? Lots of transactions? More reads?
I'd go with RAID 10, try to separate out tempdb (if used) from other db and...
-
RE: SQL2K CLIENT
ODBC drivers will work. Get the latest MDAC from MS will work. You can also install the client tools from the SQL Server CD on W98.
Steve Jones
-
RE: Copy Database
There isn't an easy way to avoid the autoiuncrement fields. You'd need to script something for these.
To copy the database, a backup and restore is the easiest way.
Steve Jones
-
RE: Can't Shrink tempdb
Restart the server should bring it back down.
I assume you've right clicked in EM and done shrink. If not, do that.
Any errors in the logs? Might also try this shrink...
-
RE: T-log backup deletion in Maint Plan
Have you checked that the SQLAgent account has rights to delete? Check the log files for the maintenance plan for errors.
Steve Jones
-
RE: what is xp_runwebtask ???
This is a holdover from SQL v6.5 which takes a query and then builds an HTML page from the results. It isn't documented in v7 or 2000, but was left...
-
RE: Zero Length Log Backup
Are you appending to one file or making a new one each time?
Steve Jones
-
RE: TCP/IP default port
Sounds like you have some bug set. Perhaps SQL is setup for dynamic ports? Check the network setup. I restart SQL and have no issues on a number of servers.
Steve...
-
RE: How accurate is GETDATE()?
Intersting, have to check on this. Will try to ping some MS contacts to see if we can get an explanation of the coding.
Steve Jones
-
RE: Copy_table_schema
Personally I'd stick with a simple solution if I could.
backup/restore.
Script the deletion of all data.
Steve Jones
-
RE: Network-Attached Storage
Haven't used a NAS, though we have some on a SAN. Similar concept, slightly different architecture. The idea behind this is that the storage is consolidated and rarely, if ever,...
Viewing 15 posts - 36,811 through 36,825 (of 39,944 total)