Strange! I've never seen anyone set a date datatype variable to an empty string. But if you do that, it immediately gets set to Jan 1, 1900. ...

You seem to have missed the poster's single problem he mentioned which is query timeout. All my suggestions answer that one problem. If a pre-select is done in...

If your only problem is timeouts:

1. Preheat your data cache by doing a SELECT * FROM whatever WHERE checksum(*) = 1

2. Create an index before doing your SELECT and then...

I have an alternate suggestion to your generic script which is to manually write custom stored procedures for whatever process you are going to call. No offense but I...

Allow me to simplify:

I'm faced with a homework problem and don't have the patience to do it. I'd like to assign it in a round robin fashion to any...

I don't think I implied developers are bad. I work with lots of brilliant developer guys whom I look up to. People have a view on the world...

On a project team a DBA just one member. My DBA responsibilities are negotiated at the beginning of the project. I'll match my rights and controls with the...

Interesting arguments about COBOL and SQL since the first is a procedural language and the second is a declarative language. In SQL we don't tell sql server HOW to...

750 GB database backed up in 30 minutes? Is that 750 GB of compressed backup data on disk? Database size is pretty much irrelevant in any discussion since...

Actually I already had the macro written for working with html samples I find. It just does four simple steps:

1....

Mail is disabled on most all the hosts I hit. But, I was able to write some procs that generate/print html to the output tab. Then I just...

I listened to the following great audio book from my local free library which may give you some excellent ideas for a presentation. It is the best book on...

Backing up 2.3 Terabytes in 64 minutes

is 2.15 TB/Hr

is 36.8 GB/Min

is 628 MB/Sec

A very good SSD can sustain sequential writes at 200 MB/Sec so maybe with a...

On most of my customer's host boxes I'm used to seeing 2GB to 4GB per minute.

There are always tricks such as Differential backups or log backups if one has a...

Note this is a new response on a very old thread. TFS, Visual Studio, and SSMS integration seems to be a holy grail. I haven't found answers anywhere,...