If you defined a bulk load in your DTS package it may bypass the trigger. But why do you have a trigger to look for nulls? What do you have...

Only instances I would think is Dev, QA and UAT if ran on the same box. This way you can have a single DB name and backup from each other...

From SQL BOL and yes I used the wrong word.

Floating point data is approximate; not all values in the data type range can be precisely represented.

And here is a nice...

Float is inprecise approximate and may throw off the expected results.

If you want 2 inputs to be int the do as you have but do one of the followiung ways to...

The problem is many of us would avoid it from a perfomance standpoint unless you have enough hardware to do the job. If you do then their may be no...

Yes, your syntax is incorrect in your example. The question, if not answered by the above, is "What is your goal"?

I suggest you look at "Transaction Log Backups" in SQL BOL.

As for truncating, I think it is a bit of a misnomer. With the TL is truncated it does not mean...

Reads to me like you have a FK on one of your columns which is constrained to another tables key column which does not have a matching value. You will...

Actually you should not bother to defrag a drive with SQL databases on it live. If they are open they will be locked and the defrag process will end before...

My most likely suspect would be your system Page file? If a lot of data is being switched in and out of the page file it can bog your system...

Keep in mind Excel has a 64k row limit.

The question I have is what system was he to write this against? Be funny if he get's it wrong due to SQL difference or if the teacher wanted in...

.antares686 th, .antares686 td {border:1pt solid #000000} 

Still trying to figure out the other note to give a logical reason or a way to reduce. But as for your item Sorin, I would look at the number of...

See if this helps

SELECT

 ((SUM(CASE WHEN (PL.Pltat + PL.Plunworkable) > 75 THEN 1.0 ELSE 0.0 END) / CAST(Count(*) as decimal(10,5))) * 100.00) AS Percentage,

 ROUND(((SUM(CASE WHEN (PL.Pltat + PL.Plunworkable) > 75 THEN...