Dear Tesla,

thank you for your autonomous vehicle package, too bad it won't work anymore once someone sells a Tesla second hand. You can beat on any bush you want but...

wow, kinda amazed I didn't overthink this one 😉 it might look unusual but not more than

• WHERE 1 = 2
•  HAVING 1 < 2
•  GROUP BY 1, 2

Select Columns from Table where 1 is smaller than the COUNT on the subset of resultsets from the subquery in the where clause.

Or in other words: Show only results where...

I was consulting one of Dell's customers a few years ago which had trouble with SQL Server Performance on ESX Hosts.

Took me 3 days to capture some metrics to be...

Indeed very sad News, R.I.P. and my condolences to his family.

Run this against your Instances

IF OBJECT_ID('tempdb.dbo.##enterprise_features') IS NOT NULL
  DROP TABLE ##enterprise_features
 
CREATE TABLE ##enterprise_features
  (
     dbname    ...

Have a look at datediff 

your case statement will probably look something like this:

CASE 
WHEN DATEDIFF(week,E.[Start Date], GETDATE()) >=0 THEN 'Yes - Started'

1. Yes
2. Depends on your configuration
3.  Define issues, you're aware that replication needs some time to catch up after one node going down? What are broken chains? LSN...

considering the thread is almost 1,5 years old, I wouldn't count on needing to sign up for the images anymore. Looking at some deployment file I'd say all you...

Netapp A800

Dell PowerMax 2000 / 8000

Dell aswell offers HCI Ready Building blocks and Azure Stack HCI

HPE Nimble

Well Elfstone, on the one hand you're trying to get rid of IExplorer.exe but you're forced to keep it around because of Silverlight. How would you feel about that? If...

I'm unfortunately not using MDS 2019 but I can confirm that MDS 2016 Plugin won't work with MDS 2014 either. I think MDS 2014 Plugin is compatible with MDS 2012...

Indeed, even tho SQL Server 2017 is a minor upgrade over SQL Server 2016 I find it from a Dev perspective much more compelling and when asked if I'd like...

What is a normal SQL Server? I think that question is rather simple: One that manages to keep up with demands from the business side.

There are systems you can't put...

Hi Jeff,

I have very few links I can provide right now as the original article I'm looking for is about not existant anymore it seems, anyways have a look