these are super cool examples

I used to use C# and the Redgate SDK for things like this (such as checking if all 100 servers had the same database structure for...

my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.

In my experience it's a...

One idea:

Add every server to a group in Registered Servers in SSMS.  Then, open a query from that qroup which will open the query connected to every instance.

You can...

just thinking outside the box

Because you have no key then replication is out of the game

could you move the tables you need to a new filegroup? that gives you lots...

Grant nailed it there - do your checkdb on a different server.

you can even include it in the restore process, then you get a restore test and a checkdb all...

If I get a chance to, I'll happily be the first one to make it work in production. Same as I got Memory Usage of Memory Optimized Tables under...

it's a little bit like prevention vs abortion.. triggers will abort the process after the fact. a unique index or pk will kill it before it starts

you can use some...

• This reply was modified 6 years, 2 months ago by MVDBA (Mike Vessey).

its ok

we've all done it.... mostly when i'm hungover 🙂 accidental deletes occur. 🙂

I don't know about the last month, the jury is still out, but last night was pretty good.

We were watching the Justice League movie.  Myself, and my 10, 7,...

I still look at Memory-Optimized TempDB Tables with jealousy. I wish SQL Server 2019 was out there just a few months earlier and I would've argued for 2019...

man , i'm stealing that quote

its pretty easy to google, but this might help

https://mindmajix.com/sql-server-2019#sql-server

personally I like the inline function optimisation and the mongo db integration into poly, but I think you need to work out...

Can you create a unique index on the table?

is your Primary key correct ?

going to 2019  will bring you longer term benefits... you won't have to upgrade from 2017, so your upgrade lifecycle is less expensive, but you will have to put some...

I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company)...