Viewing 15 posts - 4,651 through 4,665 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2015 at 7:43 am
SQL will use as much memory as it needs, up to the configured max server memory.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2015 at 12:01 pm
fizzleme (9/26/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2015 at 12:25 pm
Viewing 15 posts - 4,651 through 4,665 (of 49,552 total)