You missed what happened over Thanksgiving weekend. On the friday that guy had posted to over 20 threads with exactly the same message, even threads...

Maybe not, but the 2nd branch of the case allows for 'Private Insurance' to be returned when Control_Value1 is NULL...

Why are there quotes around the -1? Is that column a varchar? If so, check for leading spaces.

atramard (12/2/2009)

---

Are you sure this acctualy occur as my log file grew from ~500Mb to over 70Gb (in 3 h) and then another 4h later it had still not...

rahulsony111 (12/2/2009)

---

if i pass a table name like tablenew1 to the @tablename like 'EXECUTE usp_covertdatatype tablenew1'

will the select statement selects the tablenew1?

like 'select altertable tablenew1 alter column column'

And will it...

Doesn't matter. For all SQL knows, that proc...

Turn it into a stored procedure?

UDFs are not allowed to have side-effects (ie they may not change the structure of the database). Since procedures can, it would seem that a...

Why does your script use deprecated objects (that will be removed in future versions) and global temp tables?

Also, if...

Um, the distinction is clustered or heap. A nonclustered index is a separate structure and can sit on either...

Give it two schedules. Schedule 1 - Daily at 7am. Schedule 2 - Daily at 7pm.

Why?

External fragmentation usually refers to file-level fragmentation that's fixed with a...

Don't even...

atramard (12/2/2009)

---

So guys basicaly If your transaction log is as big as your disk allowed and the trasaction is not completed, there is not lot you can do as:

- you...

Making a field unique creates an index. The mandatory part has...

Expose the LUN to the cluster, create a disk resource for it in cluster admin, make that resource a dependency of the SQL Service that will be using it.