itsgaurav (6/11/2014)

---

I Create an Index Like

Create Nonclustered Index In_product_pdid

ON Product(pd_id)

INCLUDE pd_desp; <- Include product description column with Index

GO

My Question is in 60% query i need pd_desp...

Thanks Jim, a worthy subject, although somewhat simplified. Often it tends to be not only two sides but four or five, including database developers, business analysts and solution-, database- and...

It is safer to use the IDENT_CURRENT function as it "returns the last identity value generated for a specific table in any session and any scope."

😎

You can use the DelimitedSplit8K [/url] for this.

😎

As for the UK market goes, the demand is there but the remuneration isn't brilliant, especially in the...

Sean Lange (6/11/2014)

---

I don't think Joe is all that worried about earning respect. Might...

CELKO (6/11/2014)

---

What you posted is not tables at all! No keys, no DRI and very poor design.

The proprietary, non-relational IDENTITY is a table property and not a column (but...

Here is a solution entirely based on SQL 2012 window functions, I left it a little long winded to make it easier to follow.

😎

USE tempdb;

GO

IF OBJECT_ID('tempdb.dbo.sales') IS NOT NULL...

Roust_m (6/10/2014)

---

Hi,

Just installed standard editon, put tempdb on SSD and configured buffer pool extension to SSD. Ran some production replay trace. Very slow. Eats a lot of...

Evil Kraig F (6/10/2014)

---

Sub,

What performance concerns are you worried about from the concatonation technique? You should see little to no performance difference for a concatonation technique vs. a more...

SQListic (6/10/2014)

---

Hi,

How to create insert statements of the data from a table for top 'n' rows. I know we can create using generate scripts wizard, but we can't customize the...

From the top of my head, it would be

😎

EXEC dbo.sp_update_job @job_name = N'Job_Name',@enabled = 0

GO

From the command line

sqlcmd -S server -d database -Q "EXEC dbo.sp_update_job @job_name = N'Job_Name',@enabled =...

TomThomson (6/10/2014)

---

a...

The Dixie Flatline (6/10/2014)

---

That's where we disagree. 🙂

When I set statistics time,io on for the JOIN solution, it gives the following results:

Table '#B558B379' Scan count 0, logical...

below86 (6/10/2014)

---

Having a consistent naming convention for fields. I am as guilty as anybody at not doing this, but it is driving me nuts now. Years ago we...