With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable spot....

Hi,I'm pretty new to Azure but less new to SQL Server. We have an Azure SQL database with one table of about 300000 rows. So not huge. But, whilst...

From the article:

Flash storage is known for enabling significant improvements in data processing operation speeds, allowing multi-terabyte databases to be stored "in-memory", with a read/write speed that is four...

Please see the following articles.  The first compares PIVOTs to an old "Black Arts" technique known a CROSSTAB (as well as fully explaining CROSSTABs), which is what Erland is talking...

Jeff, You ask some great questions. Are you suggesting that I create a separate database with only views (that are named with the original names of the tables I...

If prod is on a SAN, a lot of SAN vendors provide the ability to do "SAN Snapshots", which are virtually instantaneous.

I guess what I'd really like to know is why do you have the second set of fully replaceable tables to begin with?  What are in these tables and why...

How will partition switching help you between databases?

Jeff, thank you for all the info and your time it's greatly appreciated!

1. plans attached as xml, sqlplan is not allowed
2. will start looking at that, that's a lot...

You can also use a computed column for as_of_month, there's no need to physically store it again. as_of_date date NOT NULL, as_of_month AS CONVERT(varchar(6), as_of_date, 112), That...

Not me... but I want one.

I'm pretty sure that a Tally table solution for this wouldn't be the preferred solution.  There is a set based solution.  See the winning entry at the bottom of the...

Thanks for the update, Steve.

I've not tried RCSI yet but, from what I've read, it seems like a really expensive solution especially where imports are concerned.

It's amazing how common such posts are becoming.