GSquared (7/3/2008)

---

Simon Facer (7/3/2008)

---

GSquared / Lynn, thanks for your insights.

So, it still comes down to the right technology in the right circumstance, you just need to know the different behaviours...

aayub (7/3/2008)

---

I have a table with the following format:

Sr1Col1 Col2Col3

1BU123456 80440

2BU123456 0KPMGF1

3BU123456 8044KPMGF1

4FC123456 80440

5FC123456 0KPMGF1

6FC123456 8044KPMGF1

7BU123456 00

8FC123456 00

Need help with an optimized query for.

The following conditions:

If we have an exact...

Truth be told, none of us do. The difference is between those who can admit it and those who can't.

Those who...

Okay, thanks. Unfortunately (?) we are looking at consolidating some of our servers, and will be using named instances where a separation is required.

😎

Where the columns in the select list come into index selection relates to covered indexes. For example, you have an index on an Employee table using EmpID, EmpLastName, EmpFirstName....

Carl Federl (7/3/2008)

---

A new category - Networking:

For each application, use DNS to alias the server name. Then when a database needs to be moved for performance reasons or the...

Jeff Moden (7/3/2008)

---

Jeff Moden (7/3/2008)

---

Nah... I'd get it wrong... I...

The purpose of doing looped Deletes is usually two fold...

1. Do the deletes and still allow the table to be used.

2. Keep the transaction log small.

Item #2 above...

I can see using table variables in test environments to test insert/update/delete processes in a explicit transaction. In SQL Server 2005 this is easier using the OUTPUT clause to...

Ron Kunce (7/3/2008)

---

jim.powers (7/3/2008)

---

This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

In the Workgroup column on the row for RAM, the limit...

Steve Hindle (7/3/2008)

---

Thanks you for all your replies.

I have also been experimenting...

I created:

Full1.Bak

Tran1.TRN

Full2.BAK

Tran2.TRN

using SQL2005. I deleted Full2.BAK and restored Full1.Bak, Tran1.TRN and then Tran2.TRN and this worked.

I'm still a tad...

And another hearty Congratulations!

😎

Contratulations to both of you!

😎

I'll ask a more general question first. What is being deleted, and what are the requirements for the solution you are working on? I ask, as another way...

Andrew Hall (7/1/2008)

---

Previous script returning a string for days when age < 1 month wks 1-3 months and months < 1 year has an out by one error on the...