Viewing 15 posts - 2,026 through 2,040 (of 49,552 total)
Keep in mind that the isolation levels affect the behaviour of *read* queries, not data modifications for the most part.
Repeatable read vs read committed: can two identical selects within a...
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
December 1, 2016 at 8:15 am
r5d4 (12/1/2016)
are there any performance reasons for not doing so?
There are a lot of performance reasons for not using functions at all (unless they're in-line table), but if you're using...
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
December 1, 2016 at 7:59 am
mack53nico (12/1/2016)
I noticed that the link posted uses 'sp_executesql'. Is there any other method that uses a process that is more secure?
sp_executesql is not intricately insecure.
my boss pointed out that...
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
December 1, 2016 at 5:58 am
CELKO (11/30/2016)
Why? One of the major concepts in RDBMS and SQL is to get away from any physical storage.
Database corruption is the primary reason that I've seen for this.
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
December 1, 2016 at 12:38 am
Gabriel P (11/30/2016)
Closest I can find is DBCC PAGE but that data is unstructured.
Yup, that's how you would do it.
One of the dump types decodes all the rows. It's not...
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
December 1, 2016 at 12:36 am
trhorner (11/30/2016)
Application folks and management are very "nervous" to do in-place upgrade
For good reason. Not something I would do with a prod database myself. Side-by-side (new instance as a named...
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
November 30, 2016 at 3:31 pm
Jim Youmans-439383 (11/30/2016)
I recently came across a large database (1 TB) that had multiple data files spread out among several drives.
It might be an attempt to reduce IO contention, as...
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
November 30, 2016 at 3:28 pm
joeroshan (11/30/2016)
It is recommended to create multiple data files with same size to optimize tempdb to take advantage of proportional fill algorithm and reduce allocation contention.
That is specifically for TempDB,...
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
November 30, 2016 at 3:26 pm
It's not repairable (there's no minimum level to repair line at the end of the output), so your only option here is to restore the last good backup and accept...
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
November 30, 2016 at 6:00 am
trhorner (11/29/2016)
Well, looks like I put way too much "stock" into what compatibility mode does for you.
Compatibility mode is just that, for compatibility. The SQL 2012 server behaves...
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
November 29, 2016 at 1:16 pm
trhorner (11/29/2016)
Normally I would agree, but in this case I was going across two versions.
Two, three, four versions, same thing. Multiple threads means mixed up replies, answers being posted to...
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
November 29, 2016 at 1:13 pm
HappyGeek (11/29/2016)
What is the recommendation on sizing individual files.
All the same size, all the same growth, otherwise the proportional fill won't fill the files evenly, which defeats the entire point...
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
November 29, 2016 at 8:31 am
Please don't post multiple threads for the same question.
No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1838679-1550-1.aspx
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
November 29, 2016 at 8:20 am
No, not possible. A database attached to SQL 2012 is a SQL 2012 database no matter what the compat mode, and databases cannot be restored to earlier versions
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
November 29, 2016 at 8:19 am
They're not SQL system users, but they may be 'system' users for the applications that are running there (users created by the application)
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
November 29, 2016 at 7:15 am
Viewing 15 posts - 2,026 through 2,040 (of 49,552 total)