we currently use Veritas Netbackup and we are looking to go to Evault in the next few months. EMC also owns Avamar which was OK, but very buggy when we...

if you have to go to such pains to put SQL on VMWare what is the point? why not just buy physical servers and you don't have to worry about...

Marios Philippopoulos (1/29/2008)

---

Slightly off topic, but if you are planning to re-define your clustered index on one or more non-identity columns, choosing keys found in GROUP BY/ORDER BY clauses is...

it's in the windows 2003 server help section or just type diskpart at the command line and it will list all the commands

The 64k offset thing has been on the...

forgot to tell you all, sql mail doesn't work on 64 bit. you'll have to change everything to db mail

when we bought VMWare a few years ago the sales guys specifically said don't run SQL or Exchange on it

your best bet in reducing expenses is buying x64 hardware and...

have you tried full text indexes?

i did a drop/recreate of the index and same thing. checked a few others and even after the days the index is rebuilt the level 1 of the index is...

the system views are pretty easy to dump data into tables

just select into new_table_name from system_view_name

it will create the table name and all the right data types. then i usually...

the database completely changes in data every 2-3 months as new billing data is added and old data is archived to a different server. one billing cycle is larger than...

there is around 48GB free space in the db and file growth is set at 100MB. there is only one datafile because this is a replicated copy.

i think there...

here it is

in my alter index posts from months ago, i changed the temp tables to table variables. too much trouble with temp tables and job failures

-- Run system view...

whatever column is not in the system view i run an update to fill in after the system view runs

USE [Index_Stats]

GO

/****** Object: Table [dbo].[physical_stats] Script Date:...

we only do rebuilds since it saves us from doing an update statistics

we do alter index rebuild with (online = on) and once in a while drop and recreate it...

i have a process where daily i run the system view to gather the data and then alter index based on the frag data. i have separate db's on each...