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...

It should be considered a good practice for a DBA to setup a notification or report of what objects are created or updated on the production server. That way one...

I think it's the title of "Babe" when juxtaposed with that avatar of a cute little puppy that throws people off.

😀

Would "working harder" within the context of programming would mean taking fewer breaks?

I walk into the office at 8:30ish and leave about 6:30ish, setting aside about 2 hours a day...