Viewing 15 posts - 9,106 through 9,120 (of 49,571 total)
SQL doesn't randomly set databases to single user mode, the command is coming from somewhere. Either an application, a job or another user. Check the error log, consider running traces...
May 9, 2014 at 3:28 pm
Then either there's an application that's sending that command to SQL, or someone's running it manually.
May 9, 2014 at 12:01 pm
How many rows in the table, how many rows does the query return? If it's most of the table, then the table scan could be the most efficient way.
btw, lack...
May 9, 2014 at 9:37 am
william.rees.howells (5/9/2014)
Also, thank link doesn't work btw?
He said it's out next week. Most bloggers write blog posts ahead of time and schedule them, that one's scheduled for the 13th May
May 9, 2014 at 9:34 am
Tell the vendor to fix their garbage (politely). They probably don't have a clue about good indexes.
If you can't drop or change indexes, how do you expect to tune the...
May 9, 2014 at 9:30 am
Firstly, you have multiple redundant indexes on that table.
Let's see...
CREATE INDEX [IX_tbl_extr_items_Collection_Surr_Id_3E6F809B-F53A-48FC-81A1-E6F7504DF641] ON [dbo].[tbl_extr_items] ( [Collection_Surr_ID] ) INCLUDE ( [active]) WITH (FILLFACTOR=100, ONLINE=?, SORT_IN_TEMPDB=?);
CREATE INDEX [Ind_collsurr_prostatus_item_computer_3E6F809B-F53A-48FC-81A1-E6F7504DF641] ON [dbo].[tbl_extr_items] ( [Collection_Surr_ID],...
May 9, 2014 at 9:20 am
Page file isn't something in SQL Server. It's a file the OS uses for 'extra' memory (so it can move apps from memory into the page file if there's memory...
May 9, 2014 at 1:25 am
There's a maintenance plans folder in Enterprise manager, you look through that. Check to see if any of your maintenance plans have the check database integrity task. If any do,...
May 9, 2014 at 12:43 am
Lynn, could you please pm me your current email address?
May 8, 2014 at 2:16 pm
I'm not talking about your backup job.
Look at your maintenance plans. Do you have any which have the database integrity task? If there are, does that task have 'automatically repair...
May 8, 2014 at 1:26 pm
Go look at your database integrity job. Does it have the option "automatically fix minor problems" checked? If so, uncheck it. Then do a full DBCC CheckDB and see how...
May 8, 2014 at 12:09 pm
The majority of those are harmless waits, to be ignored. You need to filter out the meaningless waits. Also, taking a single view doesn't help much, you need to take...
May 8, 2014 at 2:30 am
In that case, unless you have some custom auditing in place, you don't find out. The default trace (which populates that report) tracks DDL changes, but SQL only keeps 5...
May 8, 2014 at 12:44 am
Viewing 15 posts - 9,106 through 9,120 (of 49,571 total)