What is your approach for providing minimal downtime during deployments in an environment with a reporting-specific database?

I know this is a common problem but I just don't see how folks are dealing with it. Requirements: …

SQL server Audit Trigger for INSERT , UPDATE , DELETE

SQL Server Merge Command On Match update and insert together

Hi All,There has to be a way to use the Merge Command. Use: When it finds a matching record ch…

XML Field index ??

Hi I'm trying to read the data in an XML field with 27 indexes(Sorry if I'm their not called "Index…

Running CTE against all user databases

Hello - Can anyone please advise how to run the below piece of script against all user databases? B…

Translating Crystal Syntax to SQL difficulties.

Hey All,Hoping to draw on some of the expertise on here! Currently struggling to translate the foll…

Deleted

Deleted.

Multiple disparate UPDATE statements in a SP

Does anyone see any reason multiple UPDATE statements like below cannot work in a single SP? Does t…

SQL Server leaving connections open on Progress/Open Edge database

Has anyone had issues with SQL server leaving connections open after running a query on a Progress/…

Command-line Building of a Single Solution for Multiple Versions of SQL Server

I posted this same article to the Continous Integration forum but thought the SSDT forum might be a…

Looking the url to download for Access Database Engine 2010 (V.14.0.4763.1000)

I am looking for a url to download Microsoft Access Database Engine driver v 14.0.4763.1000 , tried…

SSIS Deployments

Comments posted to this topic are about the item SSIS Deployments Need an answer? No, you need a qu…

Sql queries Problem

Helloi will appreciate if you tell me the sql queries that i need in the following questions ( i am…

Three for a bit

Comments posted to this topic are about the item Three for a bit

Missing Analysis Services, Reporting Services and Integration Services

Hello,I just installed Visual Studio 2017 Professional where i have checked workloads according to …