Schemas are simply containers like folders in the NTFS file system. I don't see any drawbacks but I see lots of organizational advantages to using them. Most OLTP...

I believe the term is "technical debt". If you're allowing code to age, you are allowing it to die and eventually bring down the company with it. My...

I watched a terrifying TED talk about the findings of a group tasked to hack a car. All systems are hackable if you take your car to a mechanic....

All versions are generally backward compatible (a new server can run an older database). The problem comes into play when you are backing up a newer version database and...

John Mitchell-245523 (10/30/2015)

---

Bill Talada (10/30/2015)

---

I have replaced all chars in my databases with varchars because of the weird object-like method handling they have:

-- funky handling of chars

DECLARE @c char(5);

SET @c...

Chris Date is an academic purist...but we have real work to do and need to use nullable data types. The fundamental problem is that simple data types should not...

Some developers ain't never did nuthin' with nots and ain't not never gonna will.

My complaint is using the math terms of positive and negative when we are talking about a...

It would be nice if everyone could easily reformat to their liking. If that is not a possibility, maybe start with the ANSI standards or Microsoft's recommendations: Transact-SQL Syntax...

I ran the test below in two sessions to create a simple deadlock and you're both correct that the graph does show a trancount of 2. My interpretation is...

Your hypothesis is false as the following code will show a trancount=1:

BEGIN TRAN

SELECT @@trancount;

COMMIT;

My guess is that your deadlock is happening in a trigger, in a transaction...and triggers do operate...

Server level resources are available to all databases equally (network, data cache, tempdb).

Using SSD for tempdb might make a lot of sense and benefit all databases for a little cost.

It seems I.T. likes to set up a single channel RAID 5 which in my opinion is the worst possible setup for sql server (50 MB/sec limit) with a severe...

Dynamic Sql is great for when you have a dynamic request. In this case I think the triggers should be fully static for best performance. My preference is...

If you only have a few million rows and you are deleting about 30% of them, then likely the optimizer will use a table scan. If you delete 50k...

You have two problems:

1. Lack of disk space.

2. Incorrect constraint on a column (wrong datatype).

With compression you can solve #1 and turn a blind eye to #2.

Likely your space problem...