Abdel Ougnou

I can't find any documentation on TF1811 ? #SQLServer #SQLHelp

#sqlhelp how fast is it for a table with Billions of rows: ALTER TABLE table1 SWITCH TO table2

incase anyone else needs it :)

#sqlhelp How to write a query to get every other Friday? #tsql

--part2 WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday' ) select * from cte1 where rn % 2 != 0

--part1 with cte1 as( SELECT ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) as rn, Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num) FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n

that gets every Friday, now how to get "every other Friday"?

SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num) FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) = 'Friday'

@kevchant it says its working on: Processed 130299320 pages for database 'VLdb', file 'PrdDt1' on file 1.... and it has to do a few of these files but because it's a 26TB DB it takes sometimes hours to complete this part after it has already reported Restore 100% complete

I track 26TB restore when it gets to 100% completed it keeps PROCESSING files and that takes hours to complete. 100 percent processed. Processed 130299320 pages for database 'VLdb', file 'PrdDt1' on file 1...... How to track the second part? #sqlhelp #sqlfamily

Script only tracks 1st part: SELECT session_id as SPID, command, a.text AS Query, start_time, percent_completeFROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')

@SQLsensei thanks that's what I did.

@aougnou Hmm, sounds like a settings inheritance or object groups issue. Email S1 support and they'll help you figure out what's going on.

#sqlhelp I have created many alerts for long running query > 1 hr. in TSQL but I am having a hard time figuring out how to do it using #SentryOne. Any Blog posts or articles out there on how to do it? My Google-Fu is failing me on this one. Thanks in advance @SQLFamily.

@SQLsensei @SQLFamily The problem am having is that it's not responding to my threshold when I customize it to duration >= 30 minutes. It's still going by the default (I believe 1 hr. or 250%). Top SQL: Duration Threshold Max and [Event Duration.Total Minutes] Is greater than or equal to 30

@aougnou @SQLFamily It's easy - add the Top SQL: Runtime Threshold Max condition and a Send Email action. See here: #topsqlsource" target="_blank" rel="nofollow noopener">docs.sentryone.com/help/alerting-… and sentryone.com/blog/patrickke…

@SQLsensei @SQLFamily thanks Greg

@AngelaTidwell that should be captioned: "Internals of Table Fragmentation How it Works".

@Kevin3NF @GFritchey @cl @Kendra_Little @unclebiguns *cough* automation and scarydba.com/2020/03/24/bei… 😉

Every time leadership asks to speed up production I think of that chocolate factory episode from The Lucy Show 🤣

@GFritchey Yes please, I think we are all starting to smell you from here 😝

Shower? The fact that I'm thinking about it probably means the answer is yes.