Viewing 15 posts - 4,651 through 4,665 (of 49,571 total)
Eirikur Eiriksson (9/29/2015)
aymanahmed88 (9/29/2015)
i need to store list of array in one parameter to complete my query
i try the table...
September 29, 2015 at 10:42 am
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...
September 29, 2015 at 10:42 am
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...
September 29, 2015 at 9:25 am
On second thoughts, I think they clear the data cache for the entire instance. It's the plan cache that gets cleared per database.
September 29, 2015 at 9:22 am
It's logged to the error log.
Maybe a server-scoped DDL trigger can catch the ALTER DATABASE?
September 29, 2015 at 7:49 am
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...
September 29, 2015 at 7:47 am
newbieuser (9/29/2015)
If the buffer cache is for the Instance, when does the clear cache happen?
The cache is not cleared completely during regular operation, it would be inefficient to do...
September 29, 2015 at 7:43 am
SQL will use as much memory as it needs, up to the configured max server memory.
September 29, 2015 at 7:34 am
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.
September 29, 2015 at 3:40 am
robinwilson (9/28/2015)
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...
September 29, 2015 at 3:34 am
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...
September 29, 2015 at 3:28 am
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...
September 28, 2015 at 12:01 pm
fizzleme (9/26/2015)
September 27, 2015 at 5:44 am
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...
September 26, 2015 at 9:49 am
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...
September 25, 2015 at 12:25 pm
Viewing 15 posts - 4,651 through 4,665 (of 49,571 total)