Heh my last major upgrade which was fortunately around february right before getting stuck at home for months was upgrading my monitors.  Got a pair of 27 inch, 144 htz...

As for "although the 1 extra byte you're talking about would have covered all dates from 00010101 through 99991231 and more", that's just wrong.  There was no 3-byte binary...

I kind of get it for stuff that was done 50 years ago or whatever and people were paying by the byte for storage that saving a couple bytes on...

Maybe, if queries are only using columns included in the non clustered index SQL Server might use that one over the clustered index, whether it's actually a significant improvement or...

Sometimes it makes sense if the alternative is just adding a bunch of...

Yes, you could try something like this,

declare @T table(ID int not null primary key, Val int not null)
declare @row_level int = 3

insert @T(ID, Val)
select 1, 0 union...

This is kind of messy but it should work, there's one more case case that you didn't have in your sample data as well.

;WITH TEMP_CTE AS(
select *
,...

As general issues go does this require ##temp to have global scope?  Also, why make the variables varchar(max)?  I got it to work like this

drop table...

It also depends on what the intended use of the data is.  I had a conversation with a data scientist and they said "I couldn't give a stuff about...

You could do something like this,

CREATE TABLE #ALL_TABLE_KEYS(TABLE_NAME varchar(500),  varchar(30))

SELECT 'INSERT INTO #ALL_TABLE_KEYS SELECT ''' + TABLE_SCHEMA + '.' + TABLE_NAME + ''', <YOUR KEY> FROM...

The issue is that SQL injection isn't a platform vulnerability it's a developer issue so it's never going away.

It looks like you have two single quotes before the select instead of a double quote 😛

There's nothing inherently wrong with granting them permissions to execute a SP in UAT.

But that raises the question of how the procs executed in production?  Shouldn't QA be testing them...

I don't have an actual example of a record not showing up because they shoul all be showing up until end of day 00:00:00

Well since the table has an identity...

• This reply was modified 5 years, 8 months ago by ZZartin.

Do you have any examples of records you think should be showing up that aren't?