Viewing 15 posts - 2,926 through 2,940 (of 49,552 total)
andymay-496937 (6/20/2016)
One little point is that in a data warehousing situation you honestly believe that we're going to add referential integrity?
Given the phrasing of the question, I guess you're...
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
June 21, 2016 at 5:29 am
SQL 2014, I assume, since you mention clustered columnstore.
The clustered columnstore is a clustered index, meaning it is the primary storage of the table, hence add columns to the table...
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
June 21, 2016 at 5:19 am
The memory-optimised tables are memory-resident, they cannot not be in memory. What memory is left over from that is the normal SQL buffer pool and managed as normal for the...
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
June 21, 2016 at 5:13 am
That can happen if there are inserts into the same table on both nodes at the same time. There's a latency on the replication.
This is why the design guidance for...
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
June 20, 2016 at 12:52 pm
It might be in the default trace. If not, then unlikely unless you had some custom monitoring in place.
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
June 20, 2016 at 9:04 am
Estimated plan can be perfectly adequate. Only time you need the actual plan is if you're looking at the row estimates and whether they're wrong. For just finding table/index scans...
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
June 20, 2016 at 9:00 am
Steve Jones - SSC Editor (6/20/2016)
What you're doing to deferring a problem that will come back to cause you issues later.
And if db_datareader didn't 'work', then manually adding exactly the...
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
June 20, 2016 at 7:49 am
That query generates the statement, copy-paste once you've checked it, then run it.
I'll echo, use roles. Directly assigning users to objects causes major admin overhead and debugging pain. db_datareader gives...
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
June 20, 2016 at 7:37 am
andymay-496937 (6/19/2016)
Thank you for your comments Gail, I always thought that good design was a basic requirement for good performance?
Yup, bad design will almost certainly result in sub-standard performance
Your comments...
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
June 20, 2016 at 5:31 am
If you want accurate results, you probably don't want to use a script written for SQL 2000 on SQL 2014. Find a correct one for recent versions of SQL (ie...
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
June 20, 2016 at 5:26 am
andymay-496937 (6/19/2016)
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
June 19, 2016 at 2:45 pm
Depending how the 'table size' is being calculated, it may not take the LOB columns into account.
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
June 19, 2016 at 2:40 pm
VastSQL (6/19/2016)
Table got a column with datatype varbinary(Max) which stores attachment.
That's probably why. Varchar(max) columns are stored out of row, so depending how that 'table size' is being calculated, they...
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
June 19, 2016 at 4:17 am
Don't know what happened to the other thread...
Was that file in a secondary filegroup, or was it part of Primary?
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
June 18, 2016 at 11:38 am
wodom (6/17/2016)
GilaMonster (12/29/2010)
General recommendations are to disable the sa login completely and never use it.Disable, or delete? (And create another login with same permissions for cases where you need it.)
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
June 17, 2016 at 5:18 pm
Viewing 15 posts - 2,926 through 2,940 (of 49,552 total)