Viewing 15 posts - 2,026 through 2,040 (of 49,571 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...
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...
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...
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.
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...
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...
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...
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,...
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...
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...
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...
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...
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
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
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)
November 29, 2016 at 7:15 am
Viewing 15 posts - 2,026 through 2,040 (of 49,571 total)