Viewing 15 posts - 211 through 225 (of 49,552 total)
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
April 4, 2018 at 1:53 am
You're missing a close bracket.
Should be
CAST (D.Duty_Rate as decimal(22,8))
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
April 3, 2018 at 3:06 pm
tmmutsetse - Tuesday, April 3, 2018 9:08 AM@Gila The backup is on the default server setting
And is the server default to compress...
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
April 3, 2018 at 9:42 am
You cannot have both sites writeable. SQL's HA features do not scale out writes. There's peer-to-peer replication, but then you really need to localise writes (and at the table level,...
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
April 3, 2018 at 9:38 am
They're separate settings, they do different things and, tbh, when I'm doing audits and I find DBs with both enabled I flag that as a potential problem.
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
April 3, 2018 at 9:34 am
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
April 3, 2018 at 6:54 am
Is the backup compressed?
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
April 3, 2018 at 6:53 am
You can put the tables with the file in specific filegroups and move the files in those filegroups to a different drive, or set limits on file sizes.
Growth 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
April 3, 2018 at 5:49 am
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
April 3, 2018 at 5:07 am
You can't do cross-DB referential integrity, so just have to hope the app is written correctly (or use triggers, but they have problems too)
Why is this being done?...
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
April 3, 2018 at 2:42 am
Start by asking the 'security' person where they get these ideas from.
Does every application in your environment use individual logins to the DB for each different person using...
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
April 3, 2018 at 2:39 am
It's not a 'best practice', and finding justification will be rather hard, as people seldom write articles on 'this non-existent security practice is not a good idea'
See my...
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
April 3, 2018 at 2:35 am
2008 doesn't support the same ones that 2014/2016 do
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
March 28, 2018 at 8:19 am
The first problem is, the 4th row by what? Tables have no defined order, so saying the 4th row in the table is a meaningless statement.
You're probably better...
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
March 28, 2018 at 6:31 am
That makes sense.
Yes, to implement the partitioning, you need to rebuild the heap/clustered index, as well as any nonclustered indexes you want partition-aligned, onto the partition scheme.
Splitting...
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
March 28, 2018 at 6:00 am
Viewing 15 posts - 211 through 225 (of 49,552 total)