Regardless of SQL version I tend to use a 20% rule of thumb for the initial logfile size based on the Sum size of the datafiles, and with a proper...

Firstly on...

In a merge statement it generates an $action which is either Insert, Delete, Update as well as being able to get the Inserted, Deleted data.

Eg

MERGE tblCustomer AS target

USING (SELECT *...

I always get the Partition and Order by the wrong way round, so even when I get them the right way round I second guess myself and reverse them.

This isnt...

Can we have some sample data, as we dont know what it looks like.

As the requested output looks like a numerical increment based on the position in the set.

Its not really counting distinct, so what I though you're looking to do is something like

Select

State

,City

ROW_NUMBER() OVER(Order by City PARTITION BY State)

From [dbo].[MySalesDataTableAggregatedMonthly]

Where State is NOT NULL and City...

this should work, and return the number of Nulls in the Nationalirty and ModeOfStudy columns, although the result set is 2,2 rather than the 4,1 that you mention in the...

khushbu (10/9/2012)

---

I have been hearing lately that SQL Server when performing update to any table, first deletes that set of records and then inserts the record with the new value.

Wonder...

You'll just get the standard OLAP version of SSAS.

In 2012 SSAS come in two versions, the first is the standard OLAP variety that has been in place since SQL2005. The second is the Tabular model, that is...

Eugene Elutin (10/9/2012)

---

Jason-299789 (10/9/2012)

---

Fair enough Eugine, I agree its an important caveat but does that mean unless you keep an open transaction on the table it will disappear once the...

Gazareth (10/9/2012)

---

Jason-299789 (10/9/2012)

---

I think that Joe was probably refering to some form of regulatory requirement, eg Sarbanes Oxley/solvency II or other federal requirement...

Fair enough Eugine, I agree its an important caveat but does that mean unless you keep an open transaction on the table it will disappear once the transaction is closed...

I think that Joe was probably refering to some form of regulatory requirement, eg Sarbanes Oxley/solvency II or other federal requirement to maintain...

yuvipoy (10/9/2012)

---

# is a Local temporary tables

## is a Global temporary tables

Local Temp table is valid only for that processor id(@@SPID) alone where as Global Temp table is valid across...