halifaxdal (1/9/2017)

---

I did some extraction before hand, and the new query is much faster now, however, still the result gets exploded. Here is what I did:

1. I generated two perm...

Something I've setup before is using Event Notification to capture DDL activity:

https://www.mssqltips.com/sqlservertip/2121/event-notifications-in-sql-server-for-tracking-changes/

I've found it works very well, and you can store the captured events in a separate database that has...

if you have older versions of Integration services still running, such as 2008 or 2008 R2, SSMS 2016 cannot connect to those:

https://connect.microsoft.com/SQLServer/feedback/details/2779968/ssms-2016-error-connecting-to-integration-services-on-a-sql-server-2008-r2-instance

This is especially helpful if the query is already...

for Deadlocks and Blocking, I tend to use Event Notifications, which can be setup in any database on the instance that has Service Broker enabled:

http://www.sqlfingers.com/2014/01/sql-server-deadlock-notifications.html

something similar can be done using...

if you have SQL Server Agent running on the instances you want to monitor, it has a built in ability to notify by e-mail on a number of errors that...

I've worked with this pattern many times over the years. I think these options will tend to evaluate ALL orders in the system, since the ROW_NUMBER calculations need to...

I figured staying within SQL Server Agent has the benefit of a very easy to use built in Notification feature to alert someone by e-mail if the copy fails. ...

anjaliagarwal5 (1/5/2017)

---

Hi All,

I am trying to create a local Instance. When I issue a command ssms.exe from the below directory. It always starts SQL server 2008 which is also installed...

rinksrinks (1/5/2017)

---

...note: The FactSalesBudget has an attribute (along with others) "BudgetDate" which isn't linked to DimDate.

When user tries to create a simple report

Filter->DimRegion

DimDate , Sales Budget, Sales Actual.

The report doesn't...

alex.sqldba (1/5/2017)

---

...So my question is that there isn't much different about them except within the INCLUDE list... in these types of cases were two indexes have been suggested with different...

I'm taking a guess here, not sure if I completely understand the question, but if you just want for one specific FeeTable:

SELECT TOP 1 OffSet, Amount

FROM @t

...

fizzleme (1/4/2017)

---

Previously, I changed the service acct to domain on a SQl 2008 R2 machine and received an SPN error.

The machine could not be accessed remotely, so I changed...

rcarrier (1/4/2017)

---

...The problem is we assigned a User Defined Role to the Group. When we check if a user has that role using is_rolemember proving only 1 parameter that specifices...

you might be able to use Event Notifications, I've used it for a number of alert type things before.

http://www.sqlservercentral.com/articles/Event+Notifications/68831/