Viewing 15 posts - 8,116 through 8,130 (of 49,571 total)
faisalfarouqi (8/13/2014)
Thanks! Gail, but this is the query that they use from the reporting tool for cube refresh
If it's a cube refresh, then it should be running scheduled out of...
August 13, 2014 at 9:39 am
Just checking... I keep running into people who think full backups without copy_only break the log chain, so....
Worked at a bank 5 years.
Denying permission is probably easiest, unless the damn...
August 13, 2014 at 9:38 am
You have differential backups as part of your backup strategy?
The list of DDL operations that can have a trigger created on them is listed here: http://msdn.microsoft.com/en-us/library/bb522542.aspx, and backup database is...
August 13, 2014 at 9:11 am
You definitely have redundant indexes. Here's just one example
CREATE INDEX [missing_index_133_132_PhoneLink] ON [LP_LIve_Data].[dbo].[PhoneLink] ([CustomerID]) INCLUDE ([ID], [VendorID], [PhoneID], [PhoneTypeID], [DefaultPhone], [LocationID], [ProgramID]);
CREATE INDEX [missing_index_135_134_PhoneLink] ON [LP_LIve_Data].[dbo].[PhoneLink] ([CustomerID]);
You, or whoever created...
August 13, 2014 at 9:06 am
What is anyone going to do with 9 million rows being returned for a report? No one, ever, is going to read more than a small portion of that.
Start by...
August 13, 2014 at 8:46 am
From a quick glance, drop them all and then do a proper index analysis and tuning exercise that doesn't involve creating everything the missing index DMV says. You've got lots...
August 13, 2014 at 8:34 am
From a single glance, very dangerous to guess.
To be sure, you need to record the values from that DMV on a regular basis for at least a month and...
August 13, 2014 at 8:08 am
Ah-hoc query, SQL from an app.
If nothing at all is running in parallel, there should be no cxpacket (though maybe some system stuff can ignore the maxdop setting, not sure)
August 13, 2014 at 7:12 am
Server maxdop can be overridden.
If your instance is MAXDOP 1 and I run a query with OPTION(maxdop 8), my query can parallel up to 8 threads. That's probably what's happening.
August 13, 2014 at 6:36 am
And the profound post of the day award goes to:
In such critical situation you must go with reliable and effortless recover tool.
That's the entire post.
August 13, 2014 at 6:00 am
Plus, adding a nullable varchar column is, as far as I recall, a metadata only operation, so it's going to be extremely fast. It does need an exclusive schema lock,...
August 13, 2014 at 5:59 am
What are you trying to do? The code doesn't make any sense.
August 13, 2014 at 5:48 am
arzmohd2k8 (8/13/2014)
Database connectivity cannot be opened because it is version 661. This server support version 655 and earlierA downgrade path is not supported.
You're trying to attach a SQL Server...
August 13, 2014 at 5:44 am
enriquemallon (8/13/2014)
August 13, 2014 at 5:42 am
Can you temporarily move one of those other databases somewhere else?
Their recovery model is irrelevant, I just want to know if you can make some space on the drive.
August 13, 2014 at 4:03 am
Viewing 15 posts - 8,116 through 8,130 (of 49,571 total)