most of the spam starts with https:// as the title, maybe suggest to the webmaster that we might block that kind of title?

I did notice that these come from different...

the same principle, a key value pair (maybe)

the brilliant pair of database engineers (mr boyce and mr codd) - (google them) devised normalisation in databases

1st normal form (remove repeating data...

when are you finding tempdb grows? is there a pattern? at weekends, every day?

i'm suspecting maybe sort in tempdb

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/sort-in-tempdb-option-for-indexes?view=sql-server-ver15

but there are other things that can cause this - joins or...

I have a bit of an issue with the questions table

you are fixed to option a,b,c,d

why not make a "question option table" and make it a key value pair -...

actually you guys have changed my mind, i'd like 2 people to be engaged in the process of changing the SA password

I got one right...

jeff- you just made me laugh out loud and spill my tea all over my new keyboard about job security. I was chatting to a guy I work with last...

if you look at recursive CTEs you can build a list of dates within your boundaries

then use SELECT DATEPART (DAY,GETDATE()) and exclude the Saturday and sunday values then count...

i iknow...

interesting.. i'll have a read later.

one of the things we were taught(more than 20 years ago) was how to do capacity planning, how many rows per page, work out what...

and maybe stick some transaction management in there begin tran, commit , rollback etc

That kind of control, while well intended, may mask a bad DBA or admin.  I've seen rigid change control policies set up but management still does not question a...

Great question, Mike.

I'm thinking that it's...

the only way that can happen is if it is in the same session and the previous cursor did not shut down correctly

put a try catch block around the code...

another question - it's so blindingly obvious that I forgot to ask.

when you are shrinking, are you using truncateonly in the dbcc script?

lol - then we work 150 miles away from each other, but we do the same thing.

keep up the good work