sqlserveraintsobad.blogspot.com
SQL Server aint so bad: In a Snap! A Database Snapshot
http://sqlserveraintsobad.blogspot.com/2008/03/in-snap-database-snapshot.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Monday, 3 March 2008. SQL Server 2005 has added functionality called Database Snapshots, but what exactly are the uses of this? Secondly, in a maintenance window on a non 24/7 database you could issue this command before a data load, thus saving time. Compressed backups in 2008 may override the two options above, time will tell. View my complete profile.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: GO GO GO
http://sqlserveraintsobad.blogspot.com/2008/08/go-go-go.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Wednesday, 20 August 2008. Saw a post the other day reminding us that GO 5 can run a statement say 5 times. I'd come across this from the book Inside SQL. However, I like to create audit tables in my routines say reindex. Routines and whilst they're running I query null conditions to see where I'm at. Select count(1) from reindex. SQL Server 2005 Missing Index.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: SQL Server 2005 Express Edition - Recycle Log
http://sqlserveraintsobad.blogspot.com/2008/08/sql-server-2005-express-edition.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Thursday, 21 August 2008. SQL Server 2005 Express Edition - Recycle Log. Found a problem with a SQL Server 2005 Express edition. The errorlog. One client had a 12GB errorlog cos the server had never been restarted. I added a reindex script to be called by the Windows scheduler and simply added a line to it. If its the first of the month, lets recycle the log.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: new version - change recovery model of all dbs to simple
http://sqlserveraintsobad.blogspot.com/2008/08/new-version-change-recovery-model-of.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Wednesday, 20 August 2008. New version - change recovery model of all dbs to simple. Set @DBName = null. Select @DBName = MIN(name) from sys.databases where recovery model desc. While @DBName is not null. If @DBName NOT IN ('master', 'msdb', 'tempdb', 'model', 'distribution', 'userdatabasename'). Set @ExecSQL = '. Subscribe to: Post Comments (Atom).
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: Reindex All Databases - SQL Server 2005
http://sqlserveraintsobad.blogspot.com/2008/08/reindex-all-databases-sql-server-2005.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Wednesday, 20 August 2008. Reindex All Databases - SQL Server 2005. Reindex script to reindex all tables in all databases on SQL Server 2005. Check back here frequently I will add to as and when. Create a database called DBA and save this script in it. It takes care of the table itself. Schedule it to run whenever you have an opportunity. SET ANSI NULLS ON.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: March 2008
http://sqlserveraintsobad.blogspot.com/2008_03_01_archive.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Wednesday, 12 March 2008. SQL Server 2005 Standard Edition - it aint Standard at all. SQL Server 2005 Standard Edition. SQL Server 2005 has many enterprise class features out of the box, making it a great value for money edition especially if you can live without on-line reindexing. Web Services or HTTP Endpoints. Labels: SQL Server 2005. Monday, 3 March 2008.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: February 2008
http://sqlserveraintsobad.blogspot.com/2008_02_01_archive.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Friday, 1 February 2008. No, Mr Bond, I want you to add more RAM. If you want to use AWE on 2005 SE. Lock Pages in Memory. If you want to use 4GB on 2005 SE. Add /PAE to the boot.ini file. It aint always obvious (thankfully). Subscribe to: Posts (Atom). No, Mr Bond, I want you to add more RAM. View my complete profile.
sqlserveraintsobad.blogspot.com
SQL Server aint so bad: August 2008
http://sqlserveraintsobad.blogspot.com/2008_08_01_archive.html
SQL Server aint so bad. I am a Microsoft SQL Server DBA. Here is what I have to say. SQL Server has a bad rap, but I really think it aint so bad. Thursday, 21 August 2008. SQL Server 2005 Express Edition - Recycle Log. Found a problem with a SQL Server 2005 Express edition. The errorlog. One client had a 12GB errorlog cos the server had never been restarted. I added a reindex script to be called by the Windows scheduler and simply added a line to it. If its the first of the month, lets recycle the log.