question for the experts replying here, would "optimize for ad hoc workloads" help in these cases, or would it be a bad idea? I know its a fairly big...

Yes but only if you did a full backup somewhere along the line and have been doing T-Log Backups on a regular basis since then.

P.S.  I also strongly agree with Scott... there's no way that I'd rely on DateFirst settings never mind actually change them.

I see your description and your code but I still can't figure out what you're trying to do.  Are you simply trying to show what the Thursday week...

pass.org  says the London group can be found at:

https://sqllondon.pass.org/

meetup group at:

https://www.meetup.com/Microsoft-Data-London/

you may have better luck there.

PASS is the Professional Association of SQL Server, and has lots of...

I'm trying to compare weeks based on the start date of the given week being a thursday. Meaning the week count should count the number of weeks based on...

Jeff,

Wow! I think this will work.

This is a OpenText software document. Rows will be added randomly, not fix.

I will check total rows and let you know.

I need to count...

Instead of guessing, why not just do a test?

It is nice when you open up an SSIS package and you have 10-15 well-named steps total in it.  Easy to figure out what is going on; easy to...

Why not ask the people that made the tool?

Two questions...

1. How many total rows do you have in this...

To be clear, you don't mean comments in the actual code itself... you mean comments in a "comment" column in the table itself, yes?

in each database you can set the parameterisation options (right click on the database, go to properties and go to options)

obviously stored procs with nice parameters would be the...

Totally agreed, there.  That's...

Jeff,

I bought my Alienware 17 back in 2014, and lately (past 2 months) it's gotten a little unstable, I think it's time for a hardware refresh but up until...