sqlserveraintsobad.blogspot.com

SQL Server aint so bad

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.

http://sqlserveraintsobad.blogspot.com/

OVERVIEW OF sqlserveraintsobad.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

11

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLSERVERAINTSOBAD.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Tuesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.9 out of 5 with 14 reviews

5 star

7

4 star

3

3 star

2

2 star

0

1 star

2

Hey there! Start your review of sqlserveraintsobad.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.4 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLSERVERAINTSOBAD.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

11

SSL

EXTERNAL LINKS

0

SITE IP

173.194.46.108

LOAD TIME

0.359 sec

SCORE

6.2

PAGE TITLE

SQL Server aint so bad | sqlserveraintsobad.blogspot.com Reviews

<META> DESCRIPTION

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.

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 if day getdate =1

4 begin

5 problem sorted

6 posted by

7 john parker

8 no comments

9 select

10 from

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,if day getdate =1,begin,problem sorted,posted by,john parker,no comments,select,from,join,set nocount on,declare @dbname nvarchar 255,declare @execsql nvarchar 1024,simple,select @execsql,exec @execsql,variable declaration

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL Server aint so bad | sqlserveraintsobad.blogspot.com Reviews

https://sqlserveraintsobad.blogspot.com

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.

INTERNAL PAGES

sqlserveraintsobad.blogspot.com

1

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).

2

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.

3

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.

4

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.

5

SQL Server aint so bad: January 2008

http://sqlserveraintsobad.blogspot.com/2008_01_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, 3 January 2008. DBCC Deathmatch: DBREINDEX vs INDEXDEFRAG. Platform: SQL Server 2000. It is prudent to re-index tables frequently for optimal performance. These two have been well documented over the years but when should you use one versus t'other? It's a good question but first let's look at each statement, just a little more closely. So when to use?

UPGRADE TO PREMIUM TO VIEW 6 MORE

TOTAL PAGES IN THIS WEBSITE

11

OTHER SITES

sqlserveradminscript.codeplex.com

SQL Server Admin Scripts Pack - Home

Project Hosting for Open Source Software. SQL Server Admin Scripts Pack. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Collection of T-SQL (mostly) scripts with centralized logging and emailing allowing quick configuration of backup, free space control, operations with files, custom log shipping, audit, lock tracing. Plus other useful utilities and libraries found around in the web. ErrLog (SQL 2000) - framework...

sqlserveradvisor.blogspot.com

Microsoft SQL Server Advisor

Microsoft SQL Server Advisor. Don't optimize the workload, reduce the workload. Sunday, June 28, 2009. Tablediff: howto compare all database tables. Tablediff.exe is a command-line utility that you can you to compare tables from different database / servers. It is located in the . Program Files Microsoft SQL Server 90 COM folder. It is a handy tool that can compare tables at an amazingly high speed and create sync scripts along the way. You have to pass all object info to the tool via the command line.

sqlserveradvisor.com

sqlserveradvisor.com - sqlserveradvisor Resources and Information. This website is for sale!

Buy this domain This domain is for sale. To purchase, call 1 339-222-5144 or 1 866-829-0764 to speak with a Sales Specialist or click here for more details. This domain is for sale. Request quote.

sqlserveraid.wordpress.com

Plunge yourself in SQL Server | Informations about SQL Server from various seeds

Plunge yourself in SQL Server. Informations about SQL Server from various seeds. February 15, 2013 by raguyazhin. Select Floor(Abs(-568.05) *-1. Select ParseName(-568.05,2). Select ParseName(-568.05,1). Posted in T SQL. Print File using Powershell. February 5, 2013 by raguyazhin. 1Open Powershell in windows Server With Local Administrator. Then change to Remote Signed. 4paste the below code in notepad and save as file name. If ($thefile -is [string]) {$filename = $thefile }. If ($file -ne $null) {. Apply...

sqlserveraintsobad.blogspot.com

SQL Server aint so bad

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.

sqlserveranalysisservices.com

Sqlserveranalysisservices

Find the best information and most relevant links on all topics related to sqlserveranalysisservices.com.

sqlserveranalytics.com

Quanta Intelligence - Home

What's new in the world of IT? Read the latest news.

sqlserverandme.blogspot.com

On the Journey to be a SQL Server Professional

On the Journey to be a SQL Server Professional. SQL Server Administration, Development and B.I. Development related. Https:/ technet.microsoft.com/en-us/library/ms345193(v=sql.105).aspx. Https:/ support.microsoft.com/en-us/kb/942176. Subscribe to: Posts ( Atom ).

sqlserverapp.com

SQL SERVER MONITORING MOBILE APPS

SQL tools for the DBA, crafted with love. TALK TO US 1 909 954 0006. EMAIL US support at ikosmik.com. Info at ikosmik.com. SQL SCRIPT EXECUTION APP. Monitor your SQL instances on the go! SQL SERVER QUERY / SCRIPT EXECUTION. SQL SERVER JOBS MONITORING. We respect your privacy. You can be sure we won't spam you. WHAT OUR CUSTOMERS SAY. SQL SERVER MOBILE APPS. IPHONE / iPAD APPSTORE. The SQL Server Health Monitoring App for the DBA. Lets you monitor SQL Server instances. SQL SERVER QUERY / SCRIPT EXECUTION.