you can call me just george sibbald. Despite that darned number suffix which I hate I am the only george...

I owe bitbucket a favour so:

the 'name' column is the name of the table.

for clarity you could change the first line of the query to

Select obj.name as 'table',

barrys code...

courtesy of Mr. Barry Young

/*

vwTableInfo - Table Information View

This view display space and storage information for every table in a

SQL Server 2005 database.

Columns are:

Schema

Name

Ownermay be different from Schema)

Columnscount of...

I don't have 64 bit systems to check what actually happens, but that is definitely what the CSS blog says.

I don't think you actually enable AWE, that sp_configure option has no effect on a 64 bit system. It is used behind the scenes in 64 bit to lock pages...

having...

2. Tape does not necessary mean physical tape nowadays. It could be virtual tape library/storage (consolidation, fast I/O…). Media is a better word to describe the backup destination...

SQL server backup = no cost

AppAssure = how much?

Does the network admin realise backing up and recovering exchange server is not the same as for a SQL database?

This tool would...

If you do put sql types in charge of the 3rd party tool, then it definitely has to have advantages over native tools since we work with the native tools...

thanks for posting solution back grustni.

moving msdb to a different server\renaming server has become a minefield since SQL2005. Let us know if you hit any other related problems.

I am not so sure snapshot technologies will take over in the SQL sphere EXCEPT perhaps for VLDBs running on SQL, there a cost\suitability for purpose case could be made.

For...

not sure about faster but you certainly want to batch it up to avoid blowing your log

create table A_DBA_breakout (stopnow char(1)NOT NULL default ('N'))

insert A_DBA_breakout values('N')

create trigger breakout_insert on A_DBA_breakout

for...

we use MOM (the version before SCOM) to monitor SQL and will be upgrading to SCOM. Its a good enterprise level monitoring tool, but expensive. Does threshold monitoring, error alerting...

PiMané (11/3/2009)

---

@Lynn Pettis

The data files, along with the system databases (data and log), are on a RAID10.

The log files are on a RAID1 and tempdb has a RAID1 of it's...

for performance thresholds search 'performance condition alerts [SQL Server Agent]' in BOL

for a base script to reindex see the one under sys.dm_db_index_physical_stats in BOL or any number of scripts on...