I think the point made stands. There are too many things that can affect the performance of a query for good or bad, even a simple query.

Best to test...

jitendra.padhiyar (1/21/2014)

---

Hello Masters,

We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitoring them manually and runnig backup check script manually. It consumes almost 3-4...

DataMinder (1/15/2014)

---

I am a PLC programmer by trade so logical flow is not completely foreign to me. But I'm not sure which direction I should attempt. Access can be used...

I believe SQL Server Data Tools (SSDT) has in built schema and data compare as well.

It's not as extensive as Red Gate's Tool but it may well be all...

The "AddIns" check suggested is a good idea.

I have had occasions where an AddIn significantly slowed or froze Management Studio.

If memory serves me correctly, ApexSql Intellisense was one of them.

Post the error if you want it more specific.

What exactly are you using to do this deployment? Is it SSDT with a Database Project?

As has already been suggested, unless you are planning to set up some automated...

I think it's the column alias causing the error.

Try it like this:

Select

SUM(Case when CTE1.Status = 'No' Then 1

when CTE1.Agent_Status= 'Aged' Then 1

when CTE1.Platform = Production Then 1

When CTE1.Critical =...

I would use the OUTPUT Parameter approach suggested.

It's more appropriate given the circumstances you describe.

kanala.madhu (12/12/2013)

---

hi, experts....

i had 1000 employees... each employee i paid every month salary.i.e.03/13 ,04/13....Each employee have some employee id .i.e.unique number..

I want to retrieve the particular employee id and every...

Maybe a Full Text Index might help?

http://technet.microsoft.com/en-us/library/ms142571.aspx

farrukhhameed786 (12/7/2013)

---

Hello Experts !

I have a data sheet attached as a sample...

In column B dates are placed, Column C having data, column D average data of last 5 days and...

I doubt there is an "elegant" way to do this via TSQL.

You might be better off trying the SQL CLR, I would imagine you could code against the Excel Object...

domleg (12/5/2013)

---

I have the following script:

SELECT dbo.HemAnimal.AniUserNumber, dbo.HemAnimal.AniResponderNumber, dbo.PrmDeviceVisit.DviStartTime, dbo.PrmDeviceVisit.DviEndTime,

...

rightontarget (12/4/2013)

---

Hi all,

I was asked to create a test environment for one of our apps that is supported by 3 databases.

I can restore latest backup of production version of each,...