Viewing 15 posts - 4,366 through 4,380 (of 49,552 total)
Ideally each service should have its own account. That account absolutely should NOT be local admin, they should be limited-permission accounts.
While that's the ideal, in many cases multiple services will...
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
November 3, 2015 at 5:39 pm
Jeff Moden (11/3/2015)
No takers on the job description I posted a while back?
Wrong country.
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
November 3, 2015 at 4:38 pm
The instance is throwing a lot of user errors (that could be just about anything). You'll need to investigate the instance, see what errors it's throwing and fix the errors.
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
November 3, 2015 at 12:28 pm
Indexes aren't going to help much when you're doing select * from view. Indexes are useful when filtering data.
You have scalar functions, they're slow
You have unions, which are forcing SQL...
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
November 3, 2015 at 12:26 pm
Unlikely. Corruption causes high-severity error messages.
You may have an incorrect page space usage. Run DBCC updateusage
Also check the columns in those indexes. If they have lots and lots of columns,...
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
November 3, 2015 at 10:27 am
river1 (11/3/2015)
I mean, why separate objects through the creation of several data files if they are not on different disks?
To allow for piecemeal restores?
Because some consultant told them to...
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
November 3, 2015 at 9:30 am
ChrisM@Work (11/3/2015)
Any folks out there with a little time to spare with this thread - it's just exceeded my comfort zone. Thanks.
No spare time this week, but given the cost...
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
November 3, 2015 at 9:27 am
If you don't use the Order By, you will get a non-deterministic order for the concatenated string values. If you need the values concatenated in a specific order, you need...
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
November 3, 2015 at 9:20 am
CREATE TABLE TableName (
GroupName VARCHAR(50),
variationname VARCHAR(50),
Size VARCHAR(50),
SizeOrder INT,
Colour VARCHAR(50)
);
INSERT INTO dbo.TableName
(GroupName,
variationname,
...
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
November 2, 2015 at 5:10 pm
Hi and welcome to the forums
It's easier for people to help you if the sample data is in an easily usable state. I'm sitting in a presentation at the moment,...
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
November 2, 2015 at 4:52 pm
Try Azure SQL Database rather than an Azure VM.
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
November 2, 2015 at 3:36 pm
To be honest, I'd probably use an instead of trigger rather than an after trigger. I can't think of any method to interfere with an insert/update other than a trigger.
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
November 2, 2015 at 3:00 pm
Fragmentation can increase the space an index uses. It's more likely though that the table just has lots and lots and lots of indexes each with lots of columns.
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
November 2, 2015 at 2:02 pm
biocentrism (11/2/2015)
Thanks for your reply Gila.Some follow up questions:
1. The database is about 100MB. Is that considered small?
There's no value for small. I means small enough that you...
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
November 2, 2015 at 1:33 pm
I *strongly* recommend you don't try using SQL this way.
Technically the data and log files could be created in a dropbox synced folder, however SQL Server takes exclusive locks on...
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
November 2, 2015 at 1:01 pm
Viewing 15 posts - 4,366 through 4,380 (of 49,552 total)