One of the things I found out early on was was that decision makers often ignore data in favor of their pre-existing desires and prejudices.

I created a fairly detailed analysis...

You can return the result set directly from the UPDATE statement.

create table [dbo].[TEST1]

(

[ID][int]not null primary key clustered,

[VALUE][int]not null

);

GO

insert into dbo.TEST1 (ID, VALUE) SELECT 1, 10;

update dbo.TEST1

set

VALUE = VALUE+5

output

inserted.ID,

deleted.VALUE as Old_VALUE,

inserted.VALUE...

In the MDF you will need as much empty space as the largest index, probably a clustered index, and a bit more. If the largest table is 20 GB,...

If the first week on the month always starts on day 1 on the month, this should do it:

declare @MonthStart datetime

-- Find first day of current month

set @MonthStart = dateadd(mm,datediff(mm,0,getdate()),0)

select

Week,

WeekStart...

This script gets all the infomation you wanted for all databases on a server, and runs various queries to analyze it different ways. It works with SQL Server 7.0,...

Disabling an index is fine, provided it is not clustered index.

Disabling a clustered index prevents user access to the underlying table data.

The table is a heap (index id=0), which means it does not have a clustered index.

You cannot do a reindex rebuild of a heap table in SQL Server 2000.

To be...

Are any of the indexes on foreign key columns?

If they are, you can run into issues when you try to delete a row from a referenced table, because it will...

Brandie Tarvin (7/5/2012)

---

Michael Valentine Jones (7/5/2012)

---

Create a calendar table with a row for each date, and include a column that indicates if a date is a working day or not.

Then...

Jeff Moden (7/5/2012)

---

Michael Valentine Jones (7/4/2012)

---

Instead of using a function to test the ability to convert to a uniqueidentifier before actually converting it, wouldn't it be faster to do this...

Create a calendar table with a row for each date, and include a column that indicates if a date is a working day or not.

Then you can just run a...

Here is another calendar table function.

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

I was thinking more of a situation...

Instead of using a function to test the ability to convert to a uniqueidentifier before actually converting it, wouldn't it be faster to do this inline with a case statement...

Things to be aware of with differential backups:

A major re-indexing operation will change virtually all the pages in the database, so any differential backup made after that will be the...