Stefan Krzywicki (10/17/2012)

---

dwain.c (10/17/2012)

---

Stefan Krzywicki (10/17/2012)

---

I really hate automatic reboots of desktops because of "security patches". If I come in and it tells me I need to reboot, fine. I...

Restore a backup copy of the database and extract the correct procedure from that copy.

You could set up a DDL trigger to capture this kind of changes into a table....

To add to Gail's reply, the optimizer parses the literal values in the IN predicate and extracts unique values.

Here's an example using your code:

DECLARE @T TABLE (

Column1 int,

Column2 int

)

INSERT INTO...

The log file grows because creating the index requires a lot of data modifications, that get recorder into the transaction log. Even under the simple recovery model, the CREATE INDEX...

Sean Lange (10/9/2012)

---

Gianluca Sartori (10/9/2012)

---

Sean Lange (10/9/2012)

---

Reason #91029037403884 you should ALWAYS use the proper datatypes. Datetime should ALWAYS be stored in a datetime column. Otherwise you end up pulling...

Let's see if I get it right:

- 44 K rows inserted every day

- no updates

- frequent selects

- no primary key

- an identity column

I assume there's no clustered index on the...

Sean Lange (10/9/2012)

---

Reason #91029037403884 you should ALWAYS use the proper datatypes. Datetime should ALWAYS be stored in a datetime column. Otherwise you end up pulling out your hair over...

OK, I updated the code, but I don't have a working report to test it.

So, if you want to try it, it's totally untested, but should work.

Hope this helps

Gianluca

CELKO (9/22/2012)

---

In T-SQL we can use a VIEW using a little-know feature, the WITH CHECK OPTION clause. It will force you access Personnel only thru this view, but it works....

So, I guess it worked, didn't it?

GilaMonster (9/20/2012)

---

Be very, very careful with that option. It's undocumented for a reason, it does not always work, it's not completely tested. If it leaves your databases damaged, MS will...

It worked for me many times on 2005.

You could also try a different path.

There's an undocumented startup parameter that allows changing the collation for the whole instance, including all user databases attached to it.

You could set up...

IIRC Gail has a nice example on her blog.

You could tweak it to fit in your database.

Another option is querying sys.extended_properties directly.