Forum Replies Created
Viewing 15 posts - 37,066 through 37,080 (of 39,769 total)
-
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
-
RE: KILLED/ROLLBACK done, but won't finish
I've seen some long rollbacks. Can you define forever?
I wouldn't be surprised if the process notifies 100%, but still is doing cleanup (like deleting log entries or something).
Can you tell...
-
RE: Worth the $$$?
Personallly I've been to a number of conferences (PASS, TechEd, PDC, etc.) and I've found that the more junior you are, the more you learn from the seminars. As I've...
-
RE: DBCC SHOWCONTIG
What do you mean the output is the same as if you don't run WITH TABLERESULTS?
I suspect that this is due to the fact the a recordset is not returned...
-
RE: Day to Day Administration
Improve processes, make them run faster. Look for holes in your processes. Automate things that I do. Performance monitoring and tuning if I can get time.
Steve Jones
.Viewing 15 posts - 37,066 through 37,080 (of 39,769 total)