Another great article is here. http://www.sqlservercentral.com/articles/Performance/71549/%5B/url%5D

And for what it is worth the NOLOCK hint is not a magic go fast pill. It comes with a lot of other concerns, like...

SQLSACT (10/4/2012)

---

Hi All

I understand that parameter sniffing is a good thing

It becomes a bad thing when the parameters used in the first execution of the Procedure are atypical to the...

Here is an example of doing this both ways:

First is the Delimited string method. The code for the DelimitedSplit8K function can be found at the link in my signature about...

What you need to do is either use a table valued parameter or change your datatype to a varchar and then split the variable inside the proc.

If your...

Not to sound rude but have tried (insert your search engine of choice)???

L' Eomot Inversé (10/4/2012)

---

Sean Lange (10/3/2012)

---

NO LIKE is not SARGable so you will get scans. It has to examine every row...

haiao2000 (10/3/2012)

---

And if you want to avoid the natural tendency to do some sort of looping to build your dynamic sql you can do something like this.

select 'insert YourNewTable select'...

These three payment methods have different data requirements:

1. Checks only need Payment Amount and Check Number (for our requirements).

2. ACH transactions only need Bank Name, Routing Number and Account...

haiao2000 (10/3/2012)

---

this is code to get columns name from a table,

SELECT COLUMN_NAME FROM SourceDbName.dbo.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='';

if you want to do all in sql, them you may have to build...

jrichards54 (10/2/2012)

---

I currently have VS 2003, VS 2005 and SQL Server 2005 installed on my machine. VS 2003 is 32 bit, VS 2005 And SQL Server 2005 are 64 bit....

surma.sql (10/3/2012)

---

ok, i got it.

But in my requirement, I insert the output to another table and...

xoom (10/3/2012)

---

Hi,

i have to solve the following problem. We used DoubleTake for the event of a disaster in SQL Server 2008 R2 environment. The prod database server is mirrored 1:1...

select *, ROW_NUMBER() over (PARTITION BY cStudentId Order by dtEnrollmentDate) as RowNum

from #temp1

surma.sql (10/3/2012)

---

Thanks for Your reply

My question is,

Is it possible in SQL, I increment Row Number while i am...

This should do it.

ROW_NUMBER() over (PARTITION BY cStudentId, Order by tEnrollmentDate)