HAH!! Love that one! I...

How can we (or you or the client) know if a database server-level time-zone change will affect any portion of a sql server database(s) or application(s) that hit said database(s)?...

Make a sproc that does SELECT 1/0 and mark it as start up and start the instance. Voila, you will see what happens (and what is logged in the error...

I TOTALLY LOVE working with Cognos and Business Objects clients because I get to make GOBS OF MONEY trying to decipher and tune horrible stuff like that!!! 😎

Why didn't you provide the query plan?!? I will ask again that you get the query plan for the DELETE and provide it here.

Now that we have additional information that...

You could do what you want to do and it will work just fine. There are many examples to be found of simple trigger code like you need.

I would still...

assuming you have a guarantee that only 1 and 3 or the other possible values and you can't have more than one of either it is simply this:

select person

from table

where...

1) What is the estimated query plan for the delete? If you are doing a table scan of a billion row table to delete 6000 rows it could take a...

This seems to be a time-sensitive matter. You have gone back and forth for 3 days now and I promise you that...

Check out SET QUOTED_IDENTIFIER OFF. Now you no longer have to worry about how dang many single quotes you need to get your dynamic sql to be parsable! 😎

1) Going to be blunt here, sorry: You should absolutely not be responsible for this evolution. Partitioning is a VERY COMPLEX SUBSYSTEM, with LOTS of caveats, limitations, gotchas, provisos, etc....

mbbalaji (7/14/2016)

---

We have SQL Server 2012 SE in DR site. (log shipping configured every 15 min).

Physical memory : 64 GB. allocated for instance 19GB.

While monitored the server performance found that...

Your error message explicitly states that row versions are in play. Since you said no snapshot isolation, look into trigger usage, MARS usage or online indexing:

https://technet.microsoft.com/en-us/library/ms175492(v=sql.105).aspx

A simple web...

Minnu (7/14/2016)

---

Hi Team,

Below is my scenario.

Server 1

Database Name : UNIFY

Table Name : User

No.of Columns : 50

String Datatype : Varchar

No.of Records : 10000

Server 2

Database Name : UNIFY

Table Name : User

No.of Columns...

Foreign Keys are an important part of the data integrity problem (and can also offer benefits to the optimizer in some cases).

I agree with the other poster that a...