Jeff Moden (6/13/2014)

---

I really don't like integer dates. They're tough to do date math with and they have no built in checks for whether an entry is a legal...

sqldriver (6/5/2014)

---

So then what are plausible alternatives? What can I present as a change to say "you no longer have to risk incorrect results by using NOLOCK because A is...

Sean Lange (6/5/2014)

---

OK all this nonsense about how painful NOLOCK can be has prompted me to write this again. I know I have posted this on this site a few...

Following some standard formatting is important, especially if it it used by all developers for an application

I prefer this style with key words in lower case, but that comes from...

Like everything else, it is a business decision.

Does it lower costs?

Does it increase revenue?

Is it easier to manage?

Is there majors risks associated with either doing nothing or moving to the...

It may not still be the case in current versions of SQL Server, but I thought that was a limit of 255 tables in a query, including tables referenced in...

In general, converting the local times to UTC times is the way to solve the problem.

The real problem is converting the local time to UTC time. It will probably...

Jake Shelton (5/8/2014)

---

Hi all,

Previously I've ran scheduled jobs that backed up and shuffled the .bak files across, but is it possible for a scheduled task on Server 1, to...

Jeff Moden (5/6/2014)

---

ScottPletcher (5/6/2014)

---

No reason for the overhead of reading a table just for that. Or to calculate, say, the first Tuesday or last Friday, etc., of a month....

This will log deadlock info to the SQL Server error log:

print 'Set on Trace Flag 1222 to log deadlocks'

dbcc traceon(1222,-1)

print 'Show all trace flags that are on'

dbcc tracestatus(-1) with no_infomsgs

Depending on the action (backups, transaction log writes, etc.), SQL Server has several different types of IO sizes, so it is worth testing different block sizes.

I test with block sizes...

Michael Valentine Jones (5/2/2014)

---

akhamoshioke (5/2/2014)

---

...Take daily differentials (That way, you can do a restore with stop at if you need to do point-in-time recovery.

or

Take log backups every 15 or 30...

You need to use log backups, not differential backups, for...

jagat.patel (4/1/2014)

---

I have a table with primari key. which is refrenced across 63 columns in 40 + tables

Now when i tried to delete one record in this table it takes...

Have you tried using the ONLINE = ON option in your index creation statement?