New technology does not mean the old technology is going away. Technology has a purpose, and only goes away when its utility goes away.

I read somewhere that there are...

OLDCHAPPY (6/11/2013)

---

thanks. unfortunately its SAP so i can't change anything. it would be super cool if MS would make a more intelligent reindex/reorg task that could skip indexes with allow...

opc.three (6/12/2013)

---

Based on your requirements I thin Change Data Capture (CDC) would be a decent place to start. For an accounting system where you not only want to know if...

LOB data (TEXT, NTEXT, IMAGE, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)) is only compressed if it is stored in-row.

I suggest adding the CHECKSUM option to your backup command. Example:

backup database [MyDatabase]

to

disk = '\\MyBackupServer\MyBackupShare\MyDatabase_Backup.bak'

with

init,

compression,

checksum,

stats = 10;

CHECKSUM specifies that the backup operation will verify each page for...

This works by finding the 7th day of April for a given year, and then finding the Monday on or before that date.

select

a.DT,

FirstMondayInApril =

dateadd(dd,(datediff(dd,'17530101',dateadd(yy,datediff(yy,'17530407',a.DT),'17530407'))/7)*7,'17530101')

from

( -- Test Dates

select DT =...

This code shows the result of nested transactions:

create table #t ( x int not null primary key clustered )

begin transaction

select [@@Trancount 1] = @@trancount

insert into #t select 1

insert into #t...

Are you doing a row at a time delete, or deleting multiple rows at a time?

Do any of the tables you are deleting from have a delete trigger that is...

There is probably very little advantage to having allow_row_locks or allow_page_locks disabled, so you would be better off finding them and fixing them.

select * from sys.indexes where allow_row_locks = 0...

Jeff Moden (6/7/2013)

---

PHYData DBA (6/7/2013)

---

Does this count as using compression?

using rar instead of xcopy to speed up the network transfer?

Once we had to move an entire JDE 8.X database with...

This will return both unique constraints and primary keys:

select

[SCHEMA_NAME]= sc.name,

[TABLE_NAME]= t.name,

[CONSTRAINT_NAME]= k.name,

[CONSTRAINT_TYPE]= k.type_desc

from

sys.schemas sc

inner join

sys.tables t

onsc.schema_id = t.schema_id

inner join

sys.key_constraints k

ont.object_id = k.parent_object_id

order by

sc.name,

t.name,

k.name

To copy a backup of a large database over a WAN, I recommend the following:

1. Make a compressed backup of the database to multiple output files. Example: Make 20x5...

Rod at work (6/5/2013)

---

Michael Valentine Jones (6/5/2013)

---

SQL server CALs are not for concurrent users.

You need a CAL for each user or client that accesses SQL Server either directly or indirectly...

I take a conservative approach to applying SQL Server service packs.

I usually don’t apply them to a production environment until they have been out for a few months, unless I...

SQL server CALs are not for concurrent users.

You need a CAL for each user or client that accesses SQL Server either directly or indirectly via a middle tier application.