zedtec (11/13/2014)

---

The interaction between application and database becomes slow all of a sudden.

I have run a trace but no slow queries found (all running under 5 seconds).

Checked CPU, memory, disks...

Script produces bugs:

Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62

The object 't_DispCSV' does not exist in database 'EPCentral' or is invalid for this operation.

Even though script has only...

SSMS: Your_database/Right-mouse-click/Tasks/Generate scripts/Script entire database and all database objects

No, they describe these steps as if I already opened it. But my problem is that I even cannot find it.

Great script, I liked it. Even though it returns results only for queries that being executed at the current moment, it's good.

From Text field I can find out the text...

Thank you, that is great article, but it takes time to digest it and use it for my goal. I tried to use "EXECUTE AS" but it did not work....

Aren't you shrinking tempdb by any chance?

Check for SPARSE COLUMNS in B.O.L.

Thanks, Gianluca. I suspected this.

BTW, I liked your site.

1. What version of SQL Server do they have?

2. Do they have dev, test environment?

3. What version manager they use?

4. Besides SSIS, what other ETL tools they use?

5. Size of...

Yes you can do filegroup backup:

BACKUP DATABASE <your_db>

FILEGROUP = 'primary'

TO DISK = '...'

Alternatively, you can set secondary to read-only, and run this:

BACKUP DATABASE <your_db>

...

Run this:

exec xp_cmdshell 'dir \\your_server\your_share\ /S'

Drop its subscription and article and re-run snapshot:

exec <your_db>.dbo.sp_dropsubscription

@publication = <publication_name>,

@article ...

Yes it is possible when trigger is ON on the Publisher. But if it is ON on Subscriber, you will get an error 'Can't insert duplicate record in PK...'

You can do this:

1. script out the index

2. Drop it.

3. Create from the script from (1).

In this case you don't need any new space.