So you want to find any records where there is more than 1 character in the initials column? And you are saying this doesn't work for you?

where len(initiial) > 1

What...

curious_sqldba (11/12/2013)

---

So bulk...

Here is a great post by Erin Stellato that talks about when/how stats get updated. http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/

If covers what you are trying to do and why you should worry about turning...

You will need...

1. The select statement could block if it is part of either Repeatable Read or Serializable isolation level. So, I would first check to see what isolation level it is...

SQL Server will not move the contents of one file to another file just because it was added. Instead what is going to happen is that all new data will...

You are rolling back the transaction after you insert the errors so that is why they are displayed, but not inserted. You need to insert the errors after you rollback....

As was suggested I would:

1. Create a permanent copy table with indexes and all on a separate file group (and underlying disks) from production. Can this copy table be...

Can it be real time i.e. transactional replication or does it have to be off hours? Does it have to be created from scratch every time? or can you gradually...

I would create a Medal table that had each medal and their rank (gold = 1, silver = 2, etc.) then you can use something like this:

create table Medal (tmp_medal_id...

That is simply the name of the output (one of them) from the Compute Scalar operation right before the sort. Also, you have some carnality issues with this query (not...

As far as dealing with RAM and its inherent volatility Hekaton adheres to the durable principal of A.C.I.D., so once committed the data isn't lost. With the limitations and the...

I use database snapshots for some of the reasons mentioned above, but I also use it to run DBCC CHECKDB on my mirror instance instead of running it on the...

Matt Crowley (11/6/2013)

---

You may want to set up a simple profiler trace with just the RPC Completed, and T-SQL completed events being monitored. Run that for a while, then...

It really depends on what you consider to be "utilized". Does that mean resources, i.e. CPU, memory, I/O, etc? Does it mean user connections, batches/sec, etc? Does it mean data...