Forum Replies Created
Viewing 15 posts - 37,111 through 37,125 (of 39,818 total)
-
RE: Push Those Logs Away!
I could, but we have been using Maintance Plans and I dislike tinkering with the jobs that are setup.
This will change as we are looking at going to Diffs...
-
RE: Push Those Logs Away!
Actually, we do not rely on the tape. We keep 2 days worth of full backups. Since the tape only runs at night, we are copying the local disk T-Log...
-
RE: Last Query Fired
Profiler in real time. If someone is stuck, dbcc inputbuffer
Steve Jones
-
RE: Poll: SQL2k, NT, and Stability
No issues on SQL 2K or SQL 7. W2K is sooo much better than NT4. Terminal Services alone are worth it.
Steve Jones
-
RE: Question about UDF
I believe in memory. If it's large, it might be in tempdb, but I do not think it would be accessable by you.
Steve Jones
-
RE: Memory Capping a good idea?
Dedicated server - no capping (unless > 2GB and AWE not enabled. MS says don't try to let it run above 2GB.
Shared Server - Probably need to cap it otherwise...
-
RE: Moving Transaction Log after DB Creation ?
detach/attach (as noted above) is the easiest way to do this.
Steve Jones
-
RE: Pause for a Minute
The SQL command works well, but this particular process wasn't running on a SQL server. Instead it was a backup of another database (Btrieve).
Steve Jones
-
RE: Push Those Logs Away!
Thanks and glad people liked this one
.I backup locally to prevent any issues if I am having network problems with another server. Hate to lose a...
-
RE: Tuning queries
#1 needs indexes. That's the only thing I could see.
#2 probably same thing.
Steve Jones
-
RE: Database Diagrams in Enterprise Manager
Not sure this is documented. I believe they are stored in dtproperties in each database.
Not sure of the format. Likely leveraged from other MS tools.
Steve Jones
-
RE: Physical Disks
I've got a similar problem .
Diskperf reports things are enabled and I have rebooted, still no physical counters.
Steve Jones
-
RE: Creating a stored procedure by using..
Instead of using GOs, what about issueing multiple executes?
Steve Jones
-
RE: Windows Authentication problem
Are you using Windows and Basic? I have a similar problems. The sysadmin accounts work with Windows, but the normal accounts do not unless I enable Basic. Not a huge...
-
RE: KILLED/ROLLBACK done, but won't finish
That stinks. Hopefully they will get this sometime. I know how it feels to have no resolution. Got two MS cases now and not sure if they'll be resolved.
Steve Jones
.Viewing 15 posts - 37,111 through 37,125 (of 39,818 total)