npranj (9/2/2013)

---

I need to understand which one is better with respect to performance :

1. SQL 2012 has introducted FETCH OFFSET ...

SELECT FirstNm,LastNm

FROM Person

ORDER BY FirstNm

OFFSET 5 ROWS

FETCH NEXT 10 ROWS...

babak3334000 (9/2/2013)

---

Mrci

You are quite right in my Answer

But I have a view and send it to the different conditions By Collection (Asp.net)

I added the condition to Having, but...

Oracle765 (9/1/2013)

---

Hi Professionals

I have a script thats exports to a csv file

exec exporttocsv 'select top 5 * from newtable', 'test.csv'

the problem I am encountering is that some of the csv...

Finally installed SQL Server 2012 DE on my work laptop so I play with it out here in Afghanistan.

ringovski (9/2/2013)

---

Hi All,

I have written 3 queries and put them in 3 cte statements each is a different report. 1. FCR 2. FCP 3. DFPC. The code is putting each...

Jim P. (8/31/2013)

---

Lynn Pettis (8/31/2013)

---

Okay, I have read all the posts and would like to comment.

....

The problem as I see it, especially at the high school level, is the girls...

Okay, I have read all the posts and would like to comment.

First, Women in Technology. I want to be involved with this group. As the father of three...

It isn't that no one knows the answer, it may be that no one really knows the question. There really isn't enough in your original post to really help.

Please...

Something like this:

SELECT

*

FROM

abc

WHERE

DateCol >= dateadd(hour, 15, dateadd(day, datediff(day, 0, getdate()), -1)) and

DateCol < dateadd(hour, 15, dateadd(day, datediff(day, 0, getdate()), 0))

You may find that the following will work better as the execution plans will more likely be cached, plus it will use an index on END_DATETIME if it exists and...

Jack Corbett (8/26/2013)

---

I'll probably attend just for this one. I would currently argue that you'd...

info 58414 (8/25/2013)

---

Hi,

the following Script builds a perfect SQL-Statement to Truncate multiple Tables.

Print shows the Script, but EXECUTE sp_executesql @sql doesn't exec the Script....

Jeff Moden (8/24/2013)

---

I can't help with requirement #2 because I don't know what your data or table looks like and don't know what exactly you mean by "preferably the one...

Also, if your logfile grew to 100MB through normal operation you should leave it there. If you shrink it, SQL Server will just need to expand it again later...

anoop.mig29 (8/23/2013)

---

GilaMonster (8/11/2013)

---

Sure you can. Full backups do not in any way...