Bill I think your example, while slick, doesn't meet the OPs needs, which it to have all time buckets, even if they don't have matching records.

Looks reasonable, Alan, but I think you need 2 changes:

1) The OP wanted 15 minute "buckets". Easy change obviously.

2) I would want to add in a GROUP BY clause because...

I note that this piece of information "clientapp="SQLDEPLOY"" could mean that the devs really DON'T know what is going on under the covers if they have some automated thingy doing...

There are SOOOOOO many things that come into play with Always On that it isn't even funny. Most people don't have ANY clue what they are getting into or...

I will add that you really REALLY don't want a CURSOR in a UDF.

The only way I know of...

Jako, I have NEVER heard of someone reading a forum post or blog series, slapping together a windows failover cluster and dropping SQL Server AG(s) on them and have it...

The root cause of this failure was that you either a) built a cluster that wasn't properly validated/tested from the start or b) you allowed changes to your production environment...

tdennis-674196 (3/24/2015)

---

In your reply, the implication (emphasized by me above) is that a GUID has a larger capacity than a bigint. The actual number of unique values of a GUID...

Add up the sizes of all the tables (including there indexes) for existing data. Then estimate how many rows/size you will need 12-18 months out and make the database...

donsjones48 (3/24/2015)

---

Has anyone experience any problems following the installation of the February 2015 patches?

We are experience higher than normal CPU and Memory paging with the patches installed. When we...

Dropping unused indexes is a GREAT idea - but with a bunch of caveats, provisos, limitations, gotchas, etc. A short list includes:

1) do not drop indexes that ensure something...

cbosman0 (3/19/2015)

---

I am using a custom sql query to import data into Tableau. Problem is I need to change the varchar column data in SQL currently returning 18/01/2014 08:35:13 as...

rwitt 95744 (3/18/2015)

---

Hi, Kevin.

Thanks for your response.

By functions, I mean table-valued functions (NOT multi-statement table valued functions.) We have a very small number of scalar functions & a very...

I agree with Jason. This sounds like a data quality problem, not a MERGE problem. The error is quite explicit - you can't (shouldn't) have duplicate keys. ...