Viewing 15 posts - 8,341 through 8,355 (of 22,215 total)
The best thing to do is not share resources with anything. sQL Server just doesn't play well with others. But, it doesn't sound right that just reducing the amount of...
April 23, 2014 at 12:25 pm
You can use a statement level trace event, but, be very cautious because those generate a ton of data and might have a negative impact on performance, even if you...
April 23, 2014 at 12:22 pm
Differences in statistics are the more common explanation for differences in execution plans.
April 23, 2014 at 12:20 pm
If the files are "locked" it sounds like a SQL Server instance is actively using them. You may want to look into the process for taking a database backup to...
April 23, 2014 at 12:18 pm
rodjkidd (4/23/2014)
I'm over for some more SQL Skills training, so thought I might as well attend.
Looks as though a...
April 23, 2014 at 10:30 am
You sure it's a complete rebuild? Nothing has inserted a row? It's not doing an incremental build? The behavior is pretty consistent from what I've seen. But then, if it's...
April 23, 2014 at 8:19 am
It has to do with if there have been rows inserted into a table since it was created. If you have tables that are new or truncated, you'll see the...
April 23, 2014 at 8:11 am
David Burrows (4/23/2014)
Or OPENROWSET as referenced at the bottom of the link 🙂
Yeah, this. I said OPENQUERY, but OPENROWSET was what I was thinking about.
Thanks David.
April 23, 2014 at 7:59 am
Since we're talking SQL Server 2012, I strongly advise against using trace for this. Extended events are much more efficient at this type of data collection. The amount of data...
April 23, 2014 at 3:46 am
The problems are much more often located in the T-SQL code and the database structures than they are on the hardware. SQL Sentry does a good job of identifying the...
April 23, 2014 at 3:44 am
Unfortunately, there really isn't any sort of automated method for tuning queries. It's actually somewhat hard work requiring quite a bit of specialized knowledge. The two books down in the...
April 23, 2014 at 3:41 am
Another way to do it is to use OPENQUERY. There are examples at the link.
April 23, 2014 at 3:39 am
But triggers aren't read by the query optimizer, foreign key constraints are. You can actually get better execution plans because of enforced referential integrity.
April 23, 2014 at 3:37 am
Yeah, hard to argue with you Kevin (like it's ever easy). 8gb of RAM for SQL Server is probably barely adequate. My local VMs running on my laptop get more...
April 22, 2014 at 8:19 am
I'd say you have a critical I/O issue, but it looks like there are other things at play in there as well. The I/O issues start at 0200 and run...
April 22, 2014 at 7:02 am
Viewing 15 posts - 8,341 through 8,355 (of 22,215 total)