It's hard to know if it will create a deadlock or not without being able to compare other code to understand where locks might occur. Will it create a blocking...

Sort operations also hit tempdb. If you have read committed snapshot enabled on any of the databases, they're going to use tempdb. There are just lots and lots of uses...

If the column has statistics on it, those represent the data distribution as SQL Server understands it. You can use DBCC SHOW_STATISTICS to see the density, also known as selectivity,...

You'll need to monitor the size of your logs and possible the tempdb. Make sure you have enough disk space for all the additional information.

Filestream would be the preferred method if you have to store things within the database. You can store them in a varbinary(max) column, but you have to deal with special...

hisakimatama (1/8/2013)

---

No kidding. I saw the SQL-related bits and figured the salary was acceptable enough, then I caught the rest of it... Ack. Amusingly, there's another corporation...

They want ALL that and only want to pay $55k? I'd tell 'em where to shove that. That's crazy.

Yeah, not sure. That syntax looks a little odd. It's not a sqlcommand parameter. It' not a normal parameter. Best thing would be to go back and reread whatever documentation...

Sounds like whatever transaction was running stopped and the tempdb emptied back out. Normal, if unfortunate, behavior. I'd try to track down where that query came from because, if your...

Differentials only capture data changes since the last full backup. And, differentials won't help you with the logs. The best answer is to follow Gail's advice and run more frequent...

I don't suppose you still have the original question? Anyone else searching for similar help can benefit from the question and answer. Editing it away makes it more difficult for...

I'm with Joe and Dwain.

You do have an option, but it's somewhat dangerous. SQL Server has a function called SOUNDEX that sounds out how a word would be spoken. This...

There's almost no difference between the two. Both are likely to cause HUGE issues. Updating that much data using a cursor AND through individual INSERT & UPDATE statements is going...

When looking at the wait stats, order them by the total wait time and you can see what is causing things to slow down. This is a simple version of...

Like I said, sys.dm_exec_requests combined with the locking and transaction dynamic management objects.