You could avoid the null values by not selecting them.

I wonder why do you use Cartesian product in the "from" part? Do you need to?

Can you try replaceing your "from"...

Do you must replace the hard coded values with variables/dynamic code?

Having those 6 lines of code for those years, and adding some additional could resolve your issue for "forever".

Does it...

If you can afford the above list of actions than it seems very promising that you'll achieve speeding up.

Why "Set all dbs to SINGLE_USER mode"? Don't you need only one...

TDE is not very friendly feature.

You should have a firm reason for doing it.

Have you read the considerations, restrictions and limitations for TDE?

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

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

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

Regards,

Igor

You probably have NULL/missing values for the algorithm.

Go to the tab Mining models, right click on the model and choose "Set Algorithm parameters ...". Find the parameter MISSING_VALUE_SUBSTITUTION and type...

Are you sure that rows

Col1,Col2,Col3Col4,Col5

32Val_AVal_BVal_C

32Val_DVal_BVal_C

are not already existing rows?

I wander why do you run that script? What do you think you will achieve by running it?

The reference in the previous post is just a good pointing. You can use output file or Results to text.

Additionally you could create a temp table with same structure and...

Nothing, not dangerous. Let them sleep :), they do not overload your system.

Regards,

Igor

mote.ajit2 (9/27/2013)

---

Hi All!

I have added check constraint on table. I am calling one function in that check constraint.

Actually I have to prevent two records of same type should not have...

Hi,

You can simply achieve your goal by using the SSIS components. Once you establish a flat file source/connection you need to put a Multicast component and join two destinations to...

polkadot (1/31/2014)

---

I have a query that has 7 joins and aggregates data and runs daily. It takes about 2 minutes to run against the source data and currently there's...

djordan 4543 (2/3/2014)

---

Hi Folks,

I was running profiler on a sql2008 r2 standard instance 10.50.4290. Occasionally I get long duration on batchcompleted for the following query

The explain plan for the query...

Hi

It depends what indexes were changed. If it was a clustered index, then have in mind that REBUILD-ing it does not rebuild the associated nonclustered indexes automatically unless the ALL...

You must be missing something. It's an easy and precise article.

I'd suggest to you to pay attention on the variables and theirs values.

Regards,

Igor Micev