Duplicate post. Please put answers in this thread, http://www.sqlservercentral.com/Forums/Topic1588898-3411-1.aspx

Have you put on a server-side trace or extended events session that captures the query and metrics like reads, cpu, duration for it?

Have you verified that statistics are up to...

I'm not a Service Broker expert, but essentially what you are doing is creating a queue by putting that data in another database. Service Broker may help with the...

It makes sense that the EXISTS query would return fewer rows. When using JOIN or CROSS APPLY you are going to get the order information for each order detail...

the second query might have fewer scans, but it also has more reads, 75 vs. 12, so the first query appears to be doing less IO. Both are doing...

A trigger like this should work:

CREATE TRIGGER K2K01.dbo.InsertCustomerInsertAction ON K2K01.dbo.cust

FOR INSERT

AS

BEGIN;

IF @@rowcount = 0

BEGIN;

...

Yes it is...

harsimranjeetsinghwasson (6/26/2014)

---

Another thing i would like to ask is ,how to connect from ssis to sqlserver instance, after ssl is implemented.

Will Simple Connection establishment in package is sufficient or need...

Your model database is corrupt so the SQL server instance can't start. You need to rebuild the model database. If you don't have good backups of master, model,...

No, TDE only protects that data at rest (on disk). Once the data is read into the buffer pool it...

murnilim9 (6/25/2014)

---

HI... Thanks for the response..Appreciate it ..

How do I check that it has not "End Conversation"

Would you guide me on this?

It is not me the developer though...

Thanks so much...

There aren't major changes to the BI suite between 2008 R2 and 2012. The biggest changes are in SSIS with little in SSRS. I'm not sure about SSAS...

I'd rebuild the indexes before I did a shrink as you might shrink below what you need for the rebuild and then the rebuild will take longer due to a...

80 is the default port for IIS so maybe that's why it was deleting the 80. It may have been failing because you have something else running on port...

You can setup SQL Server to use SSL for connections. I would think that this would be the best way. Otherwise I think you'd have to do some...