Viewing 15 posts - 16,921 through 16,935 (of 22,214 total)
You may be able to see it in the Schema Changes History standard report.It only shows changes since the last time the service started.
July 23, 2009 at 7:12 am
Locking is a natural and important part of updating data in SQL Server. Intent locks, and others, should be reduced as much as possible, but they can't be prevented or...
July 23, 2009 at 6:29 am
The code is almost always relevant to the problem when we're talking about TSQL.
As several people have pointed out, depending on what was referenced or how things were referenced in...
July 23, 2009 at 5:35 am
The overviews will barely get your feet wet. It's a hard thing to learn, or least I've found it to be so far.
July 22, 2009 at 12:12 pm
Not a problem.
Another option, and it might not work for you, is to pass these values in a comma delimited format and then join against that single variable using a...
July 22, 2009 at 9:49 am
. (7/22/2009)
Steve, if you would prefer I didn't go forward with...
July 22, 2009 at 9:46 am
It could work, but you're going to run into a lot of issues, possibly. Do you have source control available? If not, get something like Microsoft's Team Foundation Server or...
July 22, 2009 at 9:44 am
Are there functions in the WHERE clause?
July 22, 2009 at 9:39 am
If you want to view the cause of a lock, query sys.dm__tran_locks.
July 22, 2009 at 9:36 am
BTW, This is a cross-post. I answered the same question over here:
http://www.sqlservercentral.com/Forums/Topic757335-145-1.aspx
Please don't post the same question in multiple locations. It really diffuses the conversation and duplicates effort.
July 22, 2009 at 9:35 am
The one good source I know of is Allen White's blog. He's also published a couple of articles over at Simple Talk. If you find anything else good, let me...
July 22, 2009 at 9:30 am
Yeah, estimated plans are seldom terribly helpful. It's basically the same plan though. It really looks like, based on what you provided, SQL Server is doing the right thing. An...
July 22, 2009 at 9:18 am
That's a slightly odd looking plan. It doesn't have a SELECT statement or a query or any of the meta data about the plan in the XML. How did you...
July 22, 2009 at 8:38 am
Kit G (7/22/2009)
Grant Fritchey (7/22/2009)
July 22, 2009 at 8:00 am
Ah, right. ALZDBA answered it. You're not forcing the backup, you're forcing the restore, but not even that really, you're just kicking all the users off the database.
July 22, 2009 at 7:24 am
Viewing 15 posts - 16,921 through 16,935 (of 22,214 total)