GilaMonster (11/26/2015)

---

Maybe. And maybe it'll make things worse.

Does the Recompile hint add an unacceptable CPU overhead...

Justin Manning SA (11/25/2015)

---

Are you using your parameters being sent to the procedure in queries directly, o do you assign them to local variables within the stored procedure?

Have a...

Hi,

I'm just trying to run SQL upgrade advisor against 2005 SQl server Database to get all the known issues before i go for actual upgrade.

I just wanted to know why...

Thanks will definitely try this out.

I did using the following code .using northwind database..

with mycte as(select ntile(15) over( order by customerid) as grp1, customerid from dbo.Customers)

,mycte2 as(select distinct grp1 from mycte)

SELECT grp1

, ...

Thanks jason ill look into that.

If you are always loading a finite date range, and its not feasible to index everything, you might be able to index the DateKey column and filter the target using...

Thanks Eddie for your suggestion, will definitely try this.

Hi all,

Any suggestion please for the above issue..

Hi,

If a dimension (SCD) table has both type 1 and type 2 columns then in that case how to use a single MERGE tsql to handle the both the types....

Thanks paul for your suggestion.I'll definitely think of these options.

Hi Paul,

There is one Confirm Dimension common to the two star schema model.

In the first Star Schema model i have 1 fact and 5 dim tables,

In the second (its a...

Any advice please... 🙂

Dim strURL, oBrowser

Dim serverPath

Dim scriptPath

serverPath =...

Hi Phil,

I had to make few changes in my script component code, so as to generate only one consolidated output file. 🙂

If you had seen my code earlier i had...