vinaypugalia (4/6/2010)

---

Great handy article !!

However, we can also achieve the same through -

SELECT CONVERT(DATETIME,DATEDIFF(dd,0,GETDATE()))

This way we can save the time taken to perform DATEADD operation though it would be...

I believe this is the article you were...

Tom.Thomson (4/6/2010)

---

Garadin (4/6/2010)

---

Tom.Thomson (4/6/2010)

---

Peter Brinkhaus (3/23/2010)

---

Note that variable names @, @@ or names starting with @@ are deprecated in SQL 2008. See http://msdn.microsoft.com/en-us/library/ms143729.aspx:

Do not use @ or @@ or names...

I made a very similar one before I re-read it and thought that he needed those numbers to exist in another table. Maybe he does, maybe not.

DECLARE...

kunaal desai (4/6/2010)

---

Hmmmmmm. can I write a script a script to remove Pk constraint from all th etables in a single database, if the PK column is the same all...

Dave Ballantyne (4/6/2010)

---

IMO

select Date,

Sum(Case when Type ='Debit' then Amount else 0 end) AS Debit,

Sum(Case when Type ='Credit' then Amount else 0 end) AS Credit

From <Table Name>

Group by Date

Is...

Tom.Thomson (4/6/2010)

---

Peter Brinkhaus (3/23/2010)

---

Note that variable names @, @@ or names starting with @@ are deprecated in SQL 2008. See http://msdn.microsoft.com/en-us/library/ms143729.aspx:

Do not use @ or @@ or names that begin...

Some of it will carry over. Some of it won't. As much as I love that book, I'd personally recommend getting an Oracle Book instead of reading that...

kkapferer (4/5/2010)

---

Lowell,

Thanks for your reply. I reread my original post and I see I was unclear. When I wrote separate instance I was implying that this was a...

I know I like what it does to my DB size. From ~75gb down...

Steve Jones - Editor (4/5/2010)

---

If you can, it would be great for you to capture a workload and then some CPU/mem/disk stats before and after compression. That would make a...

Steve Jones - Editor (4/5/2010)

---

So data compression can help because it substantially lowers I/O. It sounds crazy since it will use more CPU to do the compression, but you end...

Not all contention... there's still the procs that scan for all tables containing...

John Dempsey

---

I know this was a T-SQL(2K5) forum, but you mentioned you were calling this query in a SSIS package, so I thought I would provide an example of how...

Edited the original post to include the following information, thanks to everyone for the great ideas suggested here.

Separate FileGroups on the same Array

Questionable benefit

If there is a benefit...