Reputation
Next tag badge:
572/400 score
77/80 answers
Badges
8 104 163
Newest
 Enlightened
Impact
~1.6m people reached

Apr
20
comment Best fill factor for GUID clustering key
I can't remember which presentation it was in where he specifically discusses a case study with GUIDs and how they arrived at a fill factor. Possibly an MCM readiness video or a SQL Pass session. The gist of that point was that if you have the luxury of applying it frequently you would likely need to allow less free space than if you don't though.
Apr
20
comment Best fill factor for GUID clustering key
Have a look at one of Paul Randall's fragmentation videos. You also need to take into account frequency of maintenance Windows to reapply the fill factor.
Apr
20
comment Help undoing an accidental restore on SQL Server 2014
At least Redgate will allow you to identify tables that are identical and can be ignored or just have trivial easily fixed differences. You'll probably find the number that you actually need to look at in detail is much less than 100.
Apr
20
comment Help undoing an accidental restore on SQL Server 2014
Sounds do-able then with a bit of luck but I don't think you'll find a magic easy solution. Redgate can help identify the different rows but you'll still need to determine whether these are inserts or updates and where there are identity column clashes ensure the new id is also used when copying over all child records.
Apr
20
comment Help undoing an accidental restore on SQL Server 2014
What kind of database is it? Will people be trying to log in and update records they added yesterday that have now disappeared from live? Can you take it offline whilst you fix things as best as possible? How financially or legally critical will any discrepancies be?
Apr
20
comment Specific TempDB insert of UserDB select results in SOS_SCHEDULER_YIELD to ENCRYPTION_SCAN
A relevant recent blog post confirming all the info here blogs.msdn.microsoft.com/psssql/2016/04/19/…
Apr
19
revised How to return rows between two datetimes stored as date and time?
deleted 16 characters in body
Apr
19
comment How to return rows between two datetimes stored as date and time?
This will not be sargable if the OP has any indexes on date or date,time.
Apr
19
revised How to return rows between two datetimes stored as date and time?
added 182 characters in body
Apr
19
revised How to return rows between two datetimes stored as date and time?
added 68 characters in body
Apr
19
answered How to find out the content differences between 2 SQL tables and produce sync SQL
Apr
19
comment How to find out the content differences between 2 SQL tables and produce sync SQL
AFAIK it's legit as long as it as an ontopic answer to a genuine question and you state you have a connection with the product. So would have thought it's fine.
Apr
19
revised How to return rows between two datetimes stored as date and time?
deleted 18 characters in body; edited title
Apr
19
answered How to return rows between two datetimes stored as date and time?
Apr
19
comment Partition by ascending and descending performance
@AdamMartin count(*) over (partition...) would require a scan of the partition first to count the rows though. SQL server would add each partition to a spool, do the count, then replay the rows. There are more optimal solutions.
Apr
19
revised Does SSMS follow the same support lifecycle as SQL Server?
edited tags
Apr
19
answered Update with default values in case clause
Apr
19
revised Partition by ascending and descending performance
added 82 characters in body
Apr
19
comment Partition by ascending and descending performance
BTW that concatenation approach will be able to use a hash aggregate if no indexes at all exist but I don't fancy writing it as (a) you haven't provided table structure (b) I'm on iPad and it would be much easier to write on a PC.
Apr
19
comment Finding count of null values in 500 columns of a single table
The solution here is to simply not worry about that warning. Count(colname) doesn't count nulls by design.