Yes, but not used yet. As far as I know, the performance dashboard is more useful for production administration. I'm not sure if it will give you same detailed information...

Hi

I'd start with the Database Engine Tuning Advisor.

SQL Server Management Studio -> Menu -> Database Engine Tuning Advisor.

But review and refine the index recommendations, it often shows too many "missing"...

Hi

I'm not the SSIS pro, but you could a "Execute Process Task" use a tool (like WinZip) that supports command line arguments to compress your Excel file.

Greets

Flo

Hi

If you need to convert this size of binary data I'd either try to do this in a client application (c#/java/c++/...) or consider to use a SQL CLR function.

Just tried...

Hi Mary Ann

Yes. You need to configure Service Broker to provide the notification queue. Shown as a short SQL Statement in Enabling Query Notifications (ADO.NET). After that ensure that your...

SQL Server parser validates the existence of all database objects (tables, columns, procedures, ...) before the execution starts. Even if you encapsulate not existing objects into an IF-ELSE block, or...

Hi

I'd try to avoid the dynamic SQL and move the DML statements into another batch, where IsActive is available.

-- ...

-- New upgrade script will be

--==========

IF OBJECT_ID('dbo.TestA') IS NULL

BEGIN

...

Hi Sridhar

Ugh... I'll do my best but it's more than one decade since my last VB6 attempts.

I am not sure how we...

Hi

Don't configure SQL Servers max memory allocation for maximum (or higher) memory of your box. If you have 24GB physical memory you should configure SQL Server for a maximum of...

Hi Sridhar

You got a procedure that does nothing but one INSERT statement and takes more than 30 seconds? You...

Hi

A VIEW doesn't need to return all columns of your base tables. If you create a view that returns those 20 columns which are equal you will be able to...

Hi

Yes, NVARCHAR(MAX) is an option. However, in my opinion it should only be used if data are really large and/or rarely needed. When rarely needed I'd suggest to set the...

Hi

As ps. suggested, if your database consists of multiple data files, use parallel index maintenance jobs. Can you use a larger maintenance window on weekend?

Do you run a SQL Server...

Hi

Huh? ColdCoffee's is correct in my opinion. The result returns all data of...

Hi

Since all your facility tables have the same structure, I would try to centralize your query logic. If you need this UNION ALL only in one script/procedure, I'd use a...