Duplicate post, respond here

😎

challakarthik (10/5/2014)

---

Hi ,

I have a scenario like ........I have 6 flat files(Country1,Country2,Country3,.......Country6) in the source and i need to fetch the records of Country1 flat file to Country1 table in...

armm1388 (10/4/2014)

---

Hi

I created a database in sqlserver 2005 . now I wants to attach it in sqlserver 2008. But I would be face to error:

Failed to retrieve data for this...

desperadomar (9/28/2014)

---

@Eirikur Eiriksson

Just a quick question.

You used the MAX(wan)<>MIN(Wan) instead of COUNT(wan)>1

When I checked the estimated execution plan there is one less operator(compute scalar) in the first operation...

Steve Jones - SSC Editor (10/4/2014)

---

Eirikur Eiriksson (10/4/2014)

---

Is it just me or does this smell like a spam? A quick search returned few similar postings referencing the same vendor on...

Luis Cazares (9/19/2014)

---

I need to wait for some maintenance tasks to complete (including moving the instance to a not-shared node). After everything completes, I'll give it a try. That was...

...or from a command promt

net stop "instance name"

😎

samp.silvercreek (9/23/2014)

---

I like this solution because it handles the "dangling decimal point"...

Quick thought, full text search is not going to perform (or even work) when searching for a suffix, probably better off using the LIKE operator here.

😎

Is it just me or does this smell like a spam? A quick search returned few similar postings referencing the same vendor on other sites.

😎

thomashohner (10/4/2014)

---

I just did that and I am currently running a 50-55 second query vs 8+ minutes. I just don't understand why such a small thing made such a huge...

vinaygambhir (10/4/2014)

---

Thanks.. But the problem is I have to 1st use the below command:

EXEC ('CALL GETENROLLMENT() ')At serverName which returns the two data sets.

I do not know how to...

Here is a quick nesting example

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(Location,Building,RoomName,Habitant )AS

(SELECT * FROM (VALUES

('USA','White House','Oval Office','Mickey Mouse')

,('UK','Whitehall','24hour Lounce','Donald Duck')

) AS X(Location,Building,RoomName,Habitant)

)

,LOCATION_DETAIL(Location,LocationType) AS

(SELECT...

Yet another spam-tastic weekend:angry:

😎

vsamantha35 (10/4/2014)

---

Hi,

I need some help on security. Checking if any Security experts can guide me here.

How to do a Security assessment for an database application?

What are things to have...