One other thing I'd like to add about deploying ad-hoc change scripts; I also wrap the DML or procedure calls in a transaction and add assertions on the expected number...

In the past, whenver a "data fix" was required in production; a change order was created, and I'd write a T-SQL script which would go though the normal version control,...

Ukon (5/28/2011)

---

Hello again! I agree, using Linq with stored procedures, I believe would work quite nicely. I have no objection to that at all. I was only concerned regarding the...

You can bind LINQ to stored procedures, but it would involve more coding. As a compromise you could offer to create a collection of views for use by their application....

sqldba_icon (5/23/2011)

---

This job runs once everyday. I have nailed it down to a select statement which has the issue. So if i run this select first time, it will take...

Managing backups has never been my role, so I'm not too familiar with the technicals of how the various 3rd party solutions manage the keys. My question is: Does the...

As already suggested, look at the query execution plan to know what happending. To help things, I'd suggest inner joining that table SaveSets instead of using a sub-select in the...

Lawrence Moore (5/23/2011)

---

Hi Eric,

Many thanks for your post.

It is true that DMVs offer lots of useful information, some of which could be applied for requirements discussed in my article.

However, DMVs...

virtualjosh (5/23/2011)

---

I use system tables to see if the table has been updated:

SELECT @expiration_dt = [modify_date]

FROM [mydb].[sys].[tables]

WHERE [name] = 'mytable'

If I detect @expiration_dt to be newer than my stored...

SQL Server maintains statistics, which includes counts and timestamps, whenever table indexes are updated. This meta data can be queried from an interesting data management view called sys.dm_db_index_usage_stats. For some...

Just show up for their next monthly meeting.

http://www.sqlpass.org/PASSChapters.aspx

The most obvious way would be a SQL Profiler trace. The TextData column of the SQL:BatchCompleted event class will give you the StartTime and name of the procedure call and...

GSquared (5/20/2011)

---

Eric M Russell (5/19/2011)

---

My guess is that either the transaction has already completed or you've rebooted the server by now. However, I found an article on Microsoft's CSS site...

I guess it depends on how you define a bug. If an application or database functions within the parameters defined by the requirements, then it has no bugs; even if...

My guess is that either the transaction has already completed or you've rebooted the server by now. However, I found an article on Microsoft's CSS site about troubleshooting and resolving...