Forum Replies Created
Viewing 15 posts - 37,021 through 37,035 (of 39,720 total)
-
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
-
RE: Syntax Help
select @cmd = 'del E:\backups\' + @DELETE
xp_cmdshell @cmd
Steve Jones
-
RE: Auto Numbering
No. this is an incremental field and the increment is stored in the system tables. Someone can alwyas insert their own value or the next value can be reset.
http://www.sqlservercentral.com/columnists/sjones/understandingyouridentity.asp
http://www.sqlservercentral.com/columnists/sjones/identitylocking.asp
Steve Jones
-
RE: Pause for a Minute
Lots of other solutions I know, but this one met our needs and worked nicely.
Thanks for the suggestions.
Steve Jones
-
RE: Problems with Service Pack 2
None here. also none with the cumulative patch
Steve Jones
.Viewing 15 posts - 37,021 through 37,035 (of 39,720 total)