Sathvik (6/12/2014)

---

Hi All,

Recently we have migrated sql server 2008R2 server to 2012, But after migration one of the stored procedure is taking 2mins execute in 2012 server. It took...

Quick thought, wouldn't it be simpler to have an SSIS package for shuffling the backup files around, no need for XP_CMDSHELL etc.

😎

Throwing in an other 2c, it is much worse when duties and responsibilities fall between the different groups than occasional clashes or issues. And it definitely isn't about who's [put...

Eric M Russell (6/12/2014)

---

Hollywood should make a film called "A Day Without a DBA" just to show the ignorant public (and cocky app developers) what a total global disaster it...

Have a look at this article

Tally OH! An Improved SQL 8K “CSV Splitter” Function By Jeff Moden[/url]

😎

liudi (6/11/2014)

---

Hi all, I'm new to this forum, and really need your help.

Recently I got a 1.3TB table, has 2.7billion rows and 25 columns running on MSSQL. When trying to...

What is the Recovery Model for the database?

😎

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...