I know this is an old thread, but I ran into this issue myself.   I have job A that will check and stop job B if it is running when job...

AlwaysOn does not use SQL Clusters at all, that is a different technology.  You have to setup both machines with a windows failover cluster.

I don't have experience myself with...

Column Store Index is on all columns, not just a single column, and a date column isn't really that good of a key for a column store because it has...

I've already completed dozens of other tasks and you guys are still talking about this issue. Lol.

Lucky for me, I'm dealing with hundreds of transactions per minute, not...

I prefer to use COUNT because I think it is more readable.  I usually use in the 2012 compatibility, which seems to be the easiest to understand/most readable, to me,...

I would use a derived column transform with an expression like:

(DT_STR,4,1252)YEAR([MyDateCol]) + RIGHT("0" + (DT_STR,2,1252)MONTH([MyDateCol]),2) + RIGHT("0" + (DT_STR,2,1252)DAY([MyDateCol]),2)

select
COUNT(CASE WHEN TYPE ='D' THEN 1 ELSE NULL end) AS 'TotalXRows',
COUNT(CASE WHEN TYPE ='L' THEN 1 ELSE NULL end) AS 'TotalYRows',
Count(TYPE) AS 'TotalRows'
from dbo.Table (nolock)

There are a lot of variables for determining how to handle something like this.  It sounds like at least one of your tables has a recursive self-join involved.  I generally...

For that, you can just right click on your table in SSMS Object Explorer and choose Script Table As -> Create To...

You can also right-click and choose "View...

Never mind, I guess SSAS is just chock full of bugs and inconsistency.  I can't even get cut and paste to work right.

Is there a stable release of...

Seems pretty simple.   Instead of dropping the regular table, just make a copy of it and then truncate, that way, all your triggers, indexes, constraints, etc are not lost.  You...

As far as having a script on the remote server that starts/stops the service also run the refresh, that is more work because with SQL Agent Jobs, logging and failure...

Enabling a Task Scheduler job does not trigger it to run.  You would have to enable the job and you would still have the problem of trying to trigger it. ...

The version of SSMS is the samve version as SQL Server 2012 SP3/CU9:  11.0.6598
The PowerShell dlls are version 11.0.6020
I don't have any files at C:\Program Files\WindowsPowerShell\Modules, nor in the...

If may want to add a registry entry to make the module path permanent:

$CurrentValue