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.

I'm glad my wife isn't on this thread...

Took me 3 days and 4 trips to a supermarket to buy Toilet Paper... I honestly thought I was going to have to "borrow" (aka Steal) some from work....

Mike, I appreciate you wanting to soldier on, but it's not just about you. Certainly we wouldnt' want you to get sick, but what if you get sick and expose...