Viewing 15 posts - 5,971 through 5,985 (of 22,211 total)
Assuming it's an active query, sys.dm_exec_requests has the database id right in the results. You could join that to sysdatabases to get the database name.
June 8, 2015 at 6:40 am
mister.magoo (6/5/2015)
Jeff Moden (6/4/2015)
The more I see about XE, the less I like it.
Yes, that's why I'm trying to improve my experience 😀
Grant Fritchey (6/4/2015)
June 5, 2015 at 1:51 pm
Jeff Moden (6/4/2015)
The more I see about XE, the less I like it.
Ha! The more I use it the more in love with it I get. What it can do...
June 5, 2015 at 1:47 pm
There are small changes to Adventureworks within any given version of it, but they're not very radical. I use it for all the books I write. Many of the examples...
June 5, 2015 at 1:44 pm
You can download a version of the 2008 database from codeplex that doesn't have filestream enabled. That will make things much easier.
June 4, 2015 at 5:37 pm
I generally suggest outputting a file and querying that. It's still not fast, but you're going to generally be better off, especially in terms of the amount of information stored....
June 4, 2015 at 5:34 pm
I just talked to Wendy Pastrick. They're not going to have one. There are tentative plans for one in March of next year.
June 4, 2015 at 5:32 pm
Are you talking about a virtual machine or Azure SQL Database? If a virtual machine, you can set up a virtual network and then log shipping will be pretty easy...
June 4, 2015 at 5:29 pm
ramana3327 (6/4/2015)
I think extended events are available in enterprise edition only. We are using standard
Extended events are available in all versions of SQL Server.
June 4, 2015 at 5:21 pm
Not way after the fact, no. Even immediately following the event it may be hard to know why it happened. You'd be better off setting up monitoring through extended evens...
June 4, 2015 at 1:09 pm
There's nothing directly within SSMS that does that kind of work.
June 4, 2015 at 11:52 am
Brandie Tarvin (6/2/2015)
I have to say that "hi" and "hello" are among my favs, for no real...
June 2, 2015 at 7:52 am
As long as you're doing a WITH REPLACE, yeah, you can restore the database if it's offline.
May 30, 2015 at 3:46 am
It's hard to understand precisely what's going on. Any chance of posting the query and the execution plan that does work? Can you get an estimated execution plan from the...
May 30, 2015 at 3:46 am
cunningham (5/29/2015)
May 30, 2015 at 3:40 am
Viewing 15 posts - 5,971 through 5,985 (of 22,211 total)