Collation can be set at several levels, server, database, column. You may want to do some checking just to be sure.

Two things you can do. One, increase the max size that the tempdb files can grow. This could be just a temporary fix. Two, find out what...

Yes.

You will probably need to use a SQL Task and write the backup process using T-SQL.

XMLSQLNinja (7/10/2012)

---

Beginning with SQL Server 2005, they included the INFORMATION_SCHEMA which is a better way to access this kind of information.

For columns you can use INFORMATION_SCHEMA.COLUMNS which, unlike sys.columns, provides...

franco (7/10/2012)

---

I have done my tests and I can say that the log do increase rapidly even in BULK-LOGGED recovery model.:exclamation:

Due to the fact that our users stop to work...

What happened to your attachment? I saw one when checking this post a while ago on my phone.

The database mirroring endpoints should not be the same as the port(s) used by SQL Server.

CELKO (7/9/2012)

---

And that is why I use...

SQLKnowItAll (7/9/2012)

---

Lynn Pettis (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

Well, personally, I like my createdBy, createdDAte, modifiedBy, modifiedDate at the end of the table. Of course, it really doesn't matter... but it makes it...

SQLKnowItAll (7/9/2012)

---

Well, personally, I like my createdBy, createdDAte, modifiedBy, modifiedDate at the end of the table. Of course, it really doesn't matter... but it makes it seem more logically...

Personally, I just add new columns to the end of the table. I will do as I am told, but will argue my point as where the column is...

Just to add a little more to this discussion, if there is a large amount of data in the table and you are using SSMS to modify the table; generate...

Lowell (7/9/2012)

---

i wouldn't be fixated on having a primary key just for the sake of having a primary key;

if you will be searching by [logtime] date primarily , i would...

Took a closer look at the code. You weren't checking for = 0 (hopefully). Compare the following with my previous post:

CASE

WHEN (SUM...