Forum Replies Created
Viewing 15 posts - 35,551 through 35,565 (of 39,769 total)
-
RE: Do Hints Work Anymore?
1. I've seen this as well and I have no idea. Some piece of code in the Optimizer is not working as expected.
2.
. send to sqlwish@microsoft.com3....
-
RE: Copying backup causes periodic failure
Most likely the file is in use by some process, either the backup process or some tape process.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SQL Recommendations
I use ASP to query the db and pull stuff out. Visual Studio will help here. I'm sure there are some commercial utilites (http://www.mylittletools.net/scripts/en/home/) and others that can help.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: Recovery of database...
it should be rolling back the transaction and you will have to wait until it completes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: DB application off of a DVD
You could, but the host server would still need sql installed and running. I suppose you could script a startup, but you'd still need the registry entries. SQL, however, can...
-
RE: DB last updated
You can add a field and set a default of "getdate()" for inserts, but for updates you'd have to set a trigger.
Lumigent's Log Explorer or any of the log reader...
-
RE: Virtual briefcase
longer than your arm :D.
Actually I'm not sure at this point. we all three get so many things.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Stars
Not a bad suggestion, we just went with what came from the Snitz code. I'd guess it goes to the number of posts somehow correlating to contributions to the community.
We're...
-
RE: Is the Schema Still Needed?
Interesting idea. I hadn't considered that.
Thanks for the info.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: ACCESS_VIOLATION restarts SQLServer Service
Honestly Robert, I'm not sure what happened, but I wouldn't mess with this. Call PSS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: How to migrate ALL Jobs to another server at one ?
I'd script from EM.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: MSDB getting to big
You probably don't need to keep this, run a backup transaction with no_log to clear it out and then a dbcc shrinkfile () with the filename to reduce the size.
Steve...
-
RE: Test Database Move
backup/restore will work.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: ORACLE !
Tend to agree with the last post. SQL Server DBAs in general, could learn a few things from more mature DBA techniques practised on Oracle/DB2/etc. That being said, I'd put...
-
RE: Off topic.........
Ditto here as well. Happy Holidays to everyone!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
. send to Viewing 15 posts - 35,551 through 35,565 (of 39,769 total)