Viewing 15 posts - 12,406 through 12,420 (of 22,214 total)
Have you checked the execution plans in the morning and in the afternoon? Use the dynamic manage objects (DMO) such as sys.dm_exec_query_stats and sys.dm_exec_query_plan, to pull the plan out of...
June 8, 2011 at 5:49 am
Since it's so specific, you might want to look at the Configuration Manager and see if there's an alias created on the server that might be affecting how connections are...
June 8, 2011 at 5:46 am
sql@sql (6/8/2011)
Otherwise change in join order of tables in query may solve your...
June 8, 2011 at 5:16 am
GilaMonster (6/7/2011)
The client-from-hell is no more.
Yay! Need help hiding the bodies?
June 7, 2011 at 12:42 pm
Jim Murphy (6/7/2011)
Grant Fritchey (6/7/2011)
WayneS (6/6/2011)
If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started it... he can...
June 7, 2011 at 12:42 pm
Basically, I'd set up two, identical databases with the two different collations and then run a set of queries against each database, one at a time, capturing a full set...
June 7, 2011 at 9:39 am
Does location matter? Meaning, could people work remotely? I know several people (including me) who have lower rates for remote work.
June 7, 2011 at 7:22 am
There are just scads and scads of articles and books out there on managing log files (I know because I've added to the heap several times). It's not that hard...
June 7, 2011 at 7:17 am
Haven't had one yet this week, but the week is young for me. Stay tuned, I'm sure to have 3-5 before Friday.
June 7, 2011 at 7:13 am
John Mitchell-245523 (6/7/2011)
Gus is right.I think sp_delete_backuphistory is date specific, not database specific, so you may end up throwing the baby out with the bathwater if you use it.
John
It is...
June 7, 2011 at 7:04 am
Learn, use, and love the Books Online for SQL Server. They really do have almost every possible basic explanation you could ever need. Here's the entry on Join Types in...
June 7, 2011 at 6:56 am
I would not suggest putting them in a schema in the same database as your operational tables, no. You're going to hit the log & data files on your main...
June 7, 2011 at 6:53 am
Gianluca nailed it. You get new statistics during an index rebuild. You will not get updated statistics during an index reorg.
June 7, 2011 at 6:49 am
If you've already defined which queries are causing you pain, you're past the starting point. Once you identify the queries, then yes, absolutely, the execution plans are the way to...
June 7, 2011 at 6:48 am
Unless those are covering non-clustered indexes (meaning, all columns needed by the query are included in the index), then you're probably also seeing an RID operation. Posting the execution plan...
June 7, 2011 at 6:46 am
Viewing 15 posts - 12,406 through 12,420 (of 22,214 total)