Viewing 15 posts - 8,116 through 8,130 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 5:59 am
What are you trying to do? The code doesn't make any sense.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 5:44 am
enriquemallon (8/13/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 13, 2014 at 4:03 am
Viewing 15 posts - 8,116 through 8,130 (of 49,552 total)