SQLRNNR (8/14/2014)

---

Ed Wagner (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a...

tcronin 95651 (8/14/2014)

---

Dealing with 3rd party app that is somehow deleting records. Was going to put a delete trigger on the table so we can at least be notified...

SQLRNNR (8/14/2014)

---

Koen Verbeeck (8/14/2014)

---

I asked Matt...

Quick thought, add an output method element

😎

<xsl:output method="text" indent="no"/>

mqbk (8/13/2014)

---

Recently, I partitioned one of my largest tables into multiple monthly field groups. For the current month, it is attached to my "Active' table. The older records are...

demin99 (8/13/2014)

---

Hi Iam using SQL Server 2012.I have around 120 packages deployed in Integration services catalogs.

I wanted to find the packages that uses a particular tablename. Is there any easy...

N_Muller (8/13/2014)

---

There can be a significant overhead of dropping indexes before the partition is switched out and recreating them after the partition is switched out. Not only the switching...

faisalfarouqi (8/13/2014)

---

Eirikur Eiriksson (8/13/2014)

---

faisalfarouqi (8/13/2014)

---

[font="Comic Sans MS"]The free space is not pretty much as to accommodate another db as the db is around 5 TB. Secondly, I don't have a...

Here is an example using IN / NOT IN for error report and insert. Same can be done with EXISTS / EXCEPT

😎

USE tempdb;

GO

DECLARE @CLIENT TABLE

(

CLIENT_ID INT...

faisalfarouqi (8/13/2014)

---

[font="Comic Sans MS"]The free space is not pretty much as to accommodate another db as the db is around 5 TB. Secondly, I don't have a file backup available

Is...

julie.breetzke (8/13/2014)

---

HI There

I want to pick someones brain

I am using a Trigger to search for existing values in a column in a table to look if the value is already...

Can you post the DDL including the collation for AU.dbo.INV1, AU.dbo.OINV, SCE.dbo.AU_SALES_R, SCE.dbo.AU_SALES_H and the database collation?

😎

Quick questions

1. How much free space is on the P: drive?

2. Has the content of P:\Mnt\DATA4B\ changed?

3. Do you have a file backup of P:\Mnt\DATA4B\ ?

😎

Quick thought, if the indexes cannot be partition-aligned, how about dropping them before the switch and then re-create them?

😎

While I suspect that the requirements might possibly...