Kimberly Tripp has an excellent article about dealing with this kind of problem here:

http://www.sqlskills.com/blogs/kimberly/plan-cache-adhoc-workloads-and-clearing-the-single-use-plan-cache-bloat/

I have some third party software systems that needed this kind of cleanup to run periodically, and...

This is normal behavior, since database mail uses Service Broker, and queue, when you use sp_send_dbmail to send an e-mail, it gets put into a queue, which has an activation...

I have a computer still running SSIS 2008 R2 that runs packages against a SQL...

oh come on... you know you're curious 😉

I was...

Analysis Services permissions are separate from the SQL Server engine permissions. In Management Studio, make an Analysis Services connection (click on the Connect button dropdown in Object Explorer)

Once you're...

almost forgot, to reassociate SQL Authenticated logins to their database users:

/* automate fix SQL auth logins */

DECLARE @login nvarchar(128), @sqlcmd nvarchar(1000);

DECLARE cur_fix CURSOR FAST_FORWARD FOR

SELECT name

...

for the logins themselves, I've found this KB article still works (last did it in February this year to SQL Server 2014 server)

https://support.microsoft.com/en-us/kb/918992

I have another script I use to get...

simplest way to write it is have a subquery to determine the count of appointments per client, then group again by that count:

CREATE TABLE #appt (ClientID int, AppointmentDate char(1))

INSERT INTO...

the MDF and LDF files aren't the problem those are the physical names, the problem is that each file in SQL Server also has a logical name. These logical...

my initial guess is that the problem is in this part of your code:

SET @filename = @DBName

SET @Start = GETDATE()

SET @TSQL = 'ALTER DATABASE ['+@NewDBName+'] SET MULTI_USER WITH ROLLBACK IMMEDIATE;

RESTORE...

If this is a datamart, then how are they related in the source system? If they are related does the Forename and Surname need to be in both tables...

hegdesuchi (11/9/2016)

---

i have to check if record exists in table , if there is record then update else insert.

...

If exists(select 1 from stg_table s

join table t

on s.id=t.id and t.seq=s.seq...

duplicate posting... see:

http://www.sqlservercentral.com/Forums/Topic1833304-1351-1.aspx

SteveD SQL (11/9/2016)

---

...

I figure there are 3 ways I can provide the database and basic data:

1. database to be attached

2. backup to be restored

3. provide scripts to create and populate...

kevin.obrien 66193 (11/9/2016)

---

Hi,

I am building a DW which will load data from 2 separate sources.

Each source will populate the Broker Dim table and the Account Dim table.

To identify which source...