If you use float data type then it's normal,.. and to have fixed decimal places you need to use another numeric type, e.g. decimal.

Do you use some formatting in your...

Iulian -207023 (9/26/2014)

---

Hi Igor, what options are you thinking to ?

I see the questions as a chance to challenge various aspects of the...

The question requires two options.

hakan.winther (9/23/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is...

xp_cmdshell should be disabled from the security risk aspect. When you have xp_cmdshell enabled you're allowing processes outside sql server to do changes to databases.

I usually do that for...

For e.g. if only the collation is different on the servers (which is normal to be), you'll have...

Taka a look at this - http://technet.microsoft.com/en-us/library/ms143761(v=sql.90).aspx

Yes you can, and you should!

If you have big tables in your database, then you can additionally use trace flag 2371 - http://blogs.msdn.com/b/saponsqlserver/archive/2011/09/07/changes-to-automatic-update-statistics-in-sql-server-traceflag-2371.aspx

balasach82 (9/17/2014)

---

Igor,

Shrinked log file. It didnt frag the indexes in the tables i am testing the Ola Hallengren script.

I have to understand the script to better customise it for my...

Hi

No doubt for the Ola Hallengren scripts.

But because you're curious, I'd recommend you to just shrink the database. It should introduce high fragmentation to database tables.

select c.ID,count(*) [Cnt]

from dbo.Consumer c

where c.Resource in ('RG','MI') and c.ID=119319004

group by c.ID

having count(*)=2

If you haven't had issues with one tempdb file and you have the possibility to put extra files on separate physical disks (better option) then you shouldn't worry. I think...

Actually you didn't :). You'll forget about this. He'd better posted it on a forum for maths.

However, interesting ...

How about to see the CDC option for that table.

Link to start - http://technet.microsoft.com/en-us/library/bb522649(v=sql.105).aspx

Excellent, thanks