Are you asking for a logical design for the database?

Page Life Expectancy is the number of seconds data is left in RAM before SQL Server needs to move it out to make room for more data.

The Buffer Hit Ratio...

It's not actually a cartesian product, so an Inner Join and a Cross Join with the same criteria will produce the same plan and same results.

On truly huge datasets, like...

Bhuvnesh (1/7/2011)

---

i am also using sysadmin credential for xp_cmdshell.

can you help me out how you are using...

Is the login in use still associated with that database role?

Has there been any Deny command issued on any of the needed rights since the Grant was issued?

You're welcome.

It's always been interesting to me that SSIS works so poorly with Excel. You'd think MS could get that one ironed out.

Tom.Thomson (1/7/2011)

---

GSquared (1/7/2011)

---

The "13 periods" refers to the baktun. We're currently in the 13th, with the 14th beginning soon. They're not exponentially larger sequentially, the counting system is...

Your "select description" piece is returning more than one row. You can have it do that in that part of the query.

I'd have to see table definitions, at least,...

What end result are you trying to achieve? We don't know your business rules, so it's hard to tell what to suggest regarding the query.

You'll probably have to use a script object to write the text file instead of a data flow to export to it.

;with CTE as

(select familyID, ParentEmail, Parentpassword, Adusername, Adpassword, firstname, lastname, nameID,

row_number() over (partition by ParentEmail order by familyID) as Row

from tblParents)

select *

from CTE

where Row = 1;

Will that give you what...

WayneS (1/7/2011)

---

GSquared (1/7/2011)

---

I just have a bit of a Mayan obsession. It was a cool civilization in a lot of ways, regardless of what Mel Gibson thinks of...

Brandie Tarvin (1/7/2011)

---

GSquared (1/7/2011)

---

The Mayan calendar notation uses powers of 20, and is infinitely extensible by adding more digits to the leading edge. It starts with a particular "day...

You can modify the parallelism threshold in the SQL Server properties. Take a look at the data on that in MSDN/BOL.

Do you have mixed data types in the columns that are coming up with incorrect nulls? Like the first few rows are numbers, and below that it has character...