Eirikur Eiriksson (9/29/2015)

---

aymanahmed88 (9/29/2015)

---

i design SP for insert data in 2 tables

i need to store list of array in one parameter to complete my query

i try the table...

You can't, that's not how snapshots work.

When you create a database snapshot, any changes you make to the source database of that snapshot, the original version of the page is...

Use the table-type parameter, that's the point of that data type.

It's read-only within the proc that it's passed to, if that's a problem you can always create a table variable...

On second thoughts, I think they clear the data cache for the entire instance. It's the plan cache that gets cleared per database.

It's logged to the error log.

Maybe a server-scoped DDL trigger can catch the ALTER DATABASE?

When I'm tuning a system, I look at the aggregate IO, CPU and duration of the queries over a fixed period of time, usually an hour or two, in peak...

The cache is not cleared completely during regular operation, it would be inefficient to do...

SQL will use as much memory as it needs, up to the configured max server memory.

The data cache is not per-session. It's one data cache for the SQL Server instance.

DBCC DROPCLEANBUFFERS clears the entire data cache for the instance.

robinwilson (9/28/2015)

---

TempDB Splitting

TempDB has now been split into 8 separate files, each 20GB. This seemed to be the recommended way to set it up so there was 1 for each...

If you're using Enterprise or Developer edition, you can create a database snapshot before you run your tests and revert to the snapshot afterwards. It's not a backup, snapshots are...

It's updating the page references.

If we take a page in the leaf level of an index, it'll have pointers to the next and previous pages in the index (next and...

fizzleme (9/26/2015)

---

I think I have a basic question here that many might have encountered. When I run a query in SQL Server it will load in memory all the data...

Write the simpler stuff in-line in the select, write the data-accessing stuff as a table-valued (inline) function. Yes, you're going to duplicate code. Your choice, duplicate code or poor performance

Scalar...

There's about 16 million reasons why something could timeout sometimes and not others. Put some extra logging into your app to record exactly what was being done, then once you...