Forum Replies Created
Viewing 15 posts - 37,006 through 37,020 (of 39,717 total)
-
RE: schedule jobs to skip holidays
Make a table. Holidays are such fickle things, change from company to company.
Or set a reminder in Outlook to disable the job.
Steve Jones
-
RE: Mysterious Blank Password
Are you sending a user name? What's the connection string?
Steve Jones
-
RE: $ annoying dollar tables
Excel defaulst to sheet$, which is a valid identifier in SQL (with brackets), so SQL creates a table and uses this name.
If you want a different name, create the table,...
-
RE: Push Those Logs Away!
Actually, this works with servers of all sizes. Large servers might have issues, but it's a bandwidth issue.
We aren't simulating log shipping. Instead, this is merely a way to protect...
-
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
.Viewing 15 posts - 37,006 through 37,020 (of 39,717 total)