When we had our cyber attack back in June 2017, everything was offline and it was reported internally that it was costing the business $50m p/h. We were offline...

Going up or down? I wonder these days. For the supermarket,...

I think that query from scdecade might not work with multiple of the same. If I add two rows of  (5,4), I get a return.

This requirement (

"there should only be...

There are quite a few people losing data because they've put up an open data source on the Internet. No hacking, not really, just someone stumbling across data. Customers have...

Compression is separate from partitioning. You can create a PK and have that index be compressed. If I read this correctly, you're asking if the nonclustered index will be compressed...

You want all alerttype=[4,6] records or the first or last one? That's not a very good requirement statement.

Be careful of having exact numbers in the ROWS clause if your data isn't clean. You can partition by some datepart(hour), but be aware this might not run quickly. If...

Look at ConCat(), but what Scott did was escape out the single quotes with extras. That's a common technique for adding them to strings.

Error. No one put in the URL.

It's here: https://www.red-gate.com/hub/product-learning/sql-compare/build-and-fill-a-sql-server-database-using-sql-compare-cli-and-a-batch-script?topic=database-builds

Good catch on CDC. I've altered the question to remove this.

Well, today I was drinking my coffee, trying to come to grips with another day of trying to actually get some work done at home. The housework has slipped....

We closed our office last week, everyone at home. Not a big change for some of us, but it is a change. Many things are less active and it looks...

Reported the last post bug again. There was supposed to be some fix, but not sure if  it deployed while I was gone.

Hope you feel better, Jason, and it's not serious.

All of you are. If she saw a few of these posts, she'd sneak onto my desktop and start banning your accounts.