hmm interesting , wonder what will happen if I put a filtered index on an isactive column that has 90 % not active and 10% active

Hover over the table scan and see the estimated and actual number of rows , that should explain it. Else post the actual sqlplan file.

Hi jeff

here is the link to the video

https://www.youtube.com/watch?v=5sOlIIC-UXg

The procedure was used to decides deadline for when certain business processes should complete. It required people to fetch items...

OLTP and DW never go hand in hand (personal experience talking here). I a fairly routine aggregation summarizing data for the last 5 years could easily flood the buffer pool...

I once fixed a stored...

You can put an audit to track when the DDL is fired. Any ORM accessing the tables?

Great , thank you for clarifying that the stg table is permanent. This is exactly what I follow as well. In my case I always truncate and load the...

declare @price float = 200

declare @pricew int = 1

declare @customerrating int =3

declare @ratingweight int =5

select * from [dbo].[VacationDestination]

where price >=@price and userrating >@customerrating

order by ntile(@customerrating) over(order by userrating) desc,

ntile(@pricew)...

xsevensinzx (10/24/2015)

---

Jayanth_Kurup (10/24/2015)

---

Staging data is transient in nature and behaves similar to a temp table. This means there is going to be a lot of inserts and updates against this...

at any given point in time mirroring requires that only one instance of the database is available for user connections. If the primary and secondary are up and running and...

Staging data is transient in nature and behaves similar to a temp table. This means there is going to be a lot of inserts and updates against this table. which...

Dynamic sql wont be elegant either , upload some sample data and required output , it will be easier to understand the best way to do this.

What provider are you using , Native SQL , OLEDB ,ADONET?

Is the database online on the mirror server ? Did it failover? If it hasnt then whats the point of connecting to the mirror, If it has you can simple...

You could use a ranking function in your query to derive a results like below

Product Date ...