I assume this was a dev server of some sort?

Moving the files is good for organization, but it doesn't really matter here. I would likely have left them alone and...

Scott has a good explanation, but I agree with Eirikur, get Grant's book:  https://www.sqlservercentral.com/books/sql-server-execution-plans-second-edition-by-grant-fritchey

OK, I assume you mean that you can look at the SQL Server error log and see this. It is also logged to the Windows Application log, and you can...

Closing. Post here: https://www.sqlservercentral.com/forums/topic/not-seeing-failed-logins-in-log-viewer-or-profiler

Wed am. Not going to the opening party, no ticket, but will be in the WSCC until 4-5.

It's a feast or famine year. Not a good showing, though I really didn't have much on my bench that would have helped.

I'll be at Summit Mon/Tue only.

Thanks, edited the article and you are welcome.

Try this in a file, edit the SQLCMD to match what you need.

@@echo off
setlocal EnableDelayedExpansion
for %%x in (*.sql) do (
  set source=%%x
  echo sqlcmd -E...

• This reply was modified 6 years, 10 months ago by Steve Jones - SSC Editor.

Without persisted, this doesn't work. That was what the question tested, not if you can find a way to index a float column.

Good to hear. If you ever want to write up how this works for you, or how you do the imaging, we'd love to see an article.

If memory serves, it's a mix of commodity and cloud. However, they certainly share lots in the cloud, but use hardware to filter this down to reasonable levesl quickly, so...

I'm one of those who is older and this is a concern of mine. I've witnessed this close hand. My father was also in IT. His last position, in...

I think interviewing is...

Good comments, and interesting discussion. I'll give me thoughts on a couple things below in separate posts. I love that you embraced the chance to change minds, Philippe, that's great.

Sorry, @DinoRS,

We did have some migration issues with scripts, but they didn't quite make sense enough to find a pattern, so we've been fixing them as we can. Is that...