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...

I was just about to update the post, adding a link to...

Luis Cazares (8/12/2014)

---

This might not be the correct version (I'm not sure if there's one for 2014) but it can help you out.

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145

You could also read some of the stairways...

pratiksawant28 (7/21/2014)

---

Hi,

I have an database name ABC. In this DB i have table name XYZ.

This table has the rows more than 1000, but suddenly from yesterday is was showing only...

Further on mickyT's post, ISNUMERIC returns 1 for more than just numbers as the sample below shows

😎

USE tempdb;

GO

;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))

,NUMS(N) AS (SELECT TOP(255)...

Thank you Perry for this nice piece.

😎

Jeff Moden (8/12/2014)

---

Howz about we just track the buggers down and take them out for a nice pork chop dinner, Moden style? 😛 It might also decrease the surface...

Unless I really got it wrong, the sample data you provided should not return any records as the Tab2 effective_date is greater than the values in Tab1 effective_date, hence nothing...