It's also just possible that you're not CPU bound. In fact, it's pretty common to run out of other resources first. Disk I/O and Memory are much more frequently the...

@Grant ,

Yes, that was my intention take a chunk of everyday data rows and execute some sql code/agaent job against the table.I am sure the datatable per day will...

There isn't a way within the database alone to do this. You're going to have to go external to the database and set up something that polls the data. Now,...

You got it. sp_updatestats uses a sample method instead of full scan. It means it's faster, but it's less accurate. There's always a tradeoff deciding which to use, so you'll...

Fragmentation and statistics are two completely different, though somewhat related, things.

Fragmentation is simply about storage on the system. A page gets allocated to an index. Data gets put into it....

This year was my first PASS Summit. I've wanted to go for quite a while but there was no way my employer would spend the money needed to attend...

Because all those objects and processes you list are not stored within SQL Server, there's not a query that's going to return them all. A given SSIS package can be...

I doubt this will be a completely permanent situation. Humans are simply better at communication face to face. That efficiency will reassert itself over time. In short, we'll be back...

The only attachments that survived are just pictures. They're not much use to look at execution plans. Try posting them as .txt files. I think that works.

Slight bit of misunderstanding there. Let's say we have a VARCHAR(50). Now let's say that our data stored there is 'dog'. It doesn't use storage out to 50...

Yes, I know...

Slight bit of misunderstanding there. Let's say we have a VARCHAR(50). Now let's say that our data stored there is 'dog'. It doesn't use storage out to 50 characters. It...

For most of us, most of the time, that's way too much detail. It begs the question, what problem are you really trying to solve.

However, if you want crazy detail...

I haven't experience this, but I'd make sure that I'm running the latest version of SQL Server Management Studio.

Additionally understanding that the WHERE clauses and JOIN criteria (if any) for data manipulation queries are subject to all the same rules as a SELECT query. Something like a function...