J. R. Bennett

MS SQL & extreme metal fan

[J. R. Bennett @jrb2971]

@GoogleStadia Neither, sports are boring imho

[J. R. Bennett @jrb2971]

@JohnCena I agree, I wish there was a superhero that could eliminate the bullies in the world. The biggie issue is there are many brainwashed idiots who don't know who the real bullies are. They listen to propaganda,misinformation & lack wisdom. This is Russia's excuse for war.

[J. R. Bennett @jrb2971]

@guilda_h Chronic pain is horrible and so debilitating. I have heard of several medications for migraines like the one above that work well. Good luck and take care of yourself. I myself can't wait to have back surgery to fix a recurring herniated disc that caused constant pain/neuropathy.

[J. R. Bennett @jrb2971]

@guilda_h Looks like so much fun. Bring me next time :)

[J. R. Bennett @jrb2971]

@SQLTrooper @jdanton #sqlhelp we are trying to replicate tables and have the target not carry over any columnstore indexes. Qlik replicate does not like them

[J. R. Bennett @jrb2971]

#sqlhelp is it possible to us AAG or replication to push a table to a subscriber where those tables do not carry over the same indexes?

[J. R. Bennett @jrb2971]

#sqlhelp what do you use to replicate data from MS SQL to Oracle? (Read only, one way) I have read MS SQL no longer supports Oracle subscribers?

[J. R. Bennett @jrb2971]

@mskcunning Where is that? It looks bike friendly

[J. R. Bennett @jrb2971]

#sqlhelp I'm still not sure (after googling) some routes to take for using dynamic tsql over 8,000 characters long. Does nvarchar(max) do it? can I use the text datatype? I'm working with someone's code that concatenates huge merge statements. SQL2016

[J. R. Bennett @jrb2971]

#sqlhelp I'm trying to google for how to get a count of inserted, deleted and updated rows when using a TSQL Merge statement. I have found answers for inserted and deleted, but updated I'm having no luck. Is this possible?

[J. R. Bennett @jrb2971]

@jasonhorner Will that delete any data? Or just some memory cache of data in the other files?

[J. R. Bennett @jrb2971]

#sqlhelp is there really no way to disable in memory data on a database if we aren't using any of that functionality? I guess I can always try to recreate the db... I can't even dbcc clonedatabase

[J. R. Bennett @jrb2971]

does anyone use [local_loopback] in their fully qualified sql object naming? Is there any reason to? perhaps having the exec sp call come in as an anonymous or different user? #sqlhelp

[J. R. Bennett @jrb2971]

#sqlhelp just a follow up to my last question. Would there be any reason why someone would wrap some select statements (no writing/updating) statements with a transaction (begin/commit)? My initial answer would be no.

[J. R. Bennett @jrb2971]

#sqlhelp If a stored procedure is wrapped in a begin tran, try,commit,catch, rollback and no actual writing is done to a table, but only child stored procedures are being called, is it worth wrapping the main proc with that above? otherwise using cursors to read data

[J. R. Bennett @jrb2971]

@MassGov I filled out an application for unemployment insurance, since I was laid off last Friday. I got an answer back, it was confusing. It said I had no accrued time. I have been working for 28 years. Is the online system messed up? I can't even get a call back via their form

[J. R. Bennett @jrb2971]

@Ask_Spectrum I have 400Mbps service and I only see 25Mbps down consistently in my tests and pfsense traffic graph (my router).

[J. R. Bennett @jrb2971]

#sqlhelp is there an ssms add-in or tool to easily turn on and off ssms add-ins? I think I want to compare add-ins like sqlprompt, ssmsboost, sql complete...

[J. R. Bennett @jrb2971]

#sqlhelp Is there a way to have SQL ignore a leading key column when it comes to statistics? (and use another column). We have a column we can't remove that has the same value in all rows (in several indexes) and causes the histogram to be useless which moves to the density ...

[J. R. Bennett @jrb2971]

@MattMcgiffen oops, my bad. HASH is snowflake/snowsql function. Just ignore my question. I've been converting ms sql to (ansi?) snowsql.. fun fun #sqlhelp

[J. R. Bennett @jrb2971]

#sqlhelp in TSQL is hash the same as hashbytes? I have googled it but couldn't find a simple clear answer