Viewing 15 posts - 91 through 105 (of 368 total)
Phantoms are indeed possible under read committed snapshot, it allows the same data anomalies as read committed does, ie non-repeatable reads and phantoms
It's not the same, and there are two...
February 11, 2013 at 8:26 am
When you enable read committed snapshot on a database level, it starts to use row versioning instead of locks to maintain transaction consistency and isolation. Locks are still there, but...
February 11, 2013 at 7:09 am
It should, try it.
"public" is the database role that every db user is in. If a user emerges you don't want to give that right, you are in trouble. It...
February 10, 2013 at 10:36 pm
For the transaction log initial size and filegrowth setting, see here: blog.sqlxdetails.com
February 9, 2013 at 9:18 am
Instead of loop, you can just:
grant execute to public
That includes all procedures that will be generated in the future in that database and all scalar functions.
What would you like to...
February 9, 2013 at 2:22 am
No difference. One is synonym for the other, cant remember which one.
February 8, 2013 at 4:47 am
who much it makes differnce with or without clus index?
Without clustered index (that is, on a heap table) you cannot do partition switching. This is the deal-breaker for me.
Rebuilding a...
February 8, 2013 at 1:50 am
Clustered index key: start_time + policy_id.
Partition by start_time. You cannot partition by "policyid + start_time".
Use sort in tempdb option or filegroup on a drive with enough space.
February 8, 2013 at 1:28 am
Do you connect with the same user (Login) to sql server in both cases? Is SSMS started with "run as admin" ?
February 7, 2013 at 5:36 pm
I have no script, but this will probably be faster than pure ALTER COLUMN method on very large tables:
1) Use SELECT * FROM INFORMATION_SCHEMA.COLUMNS to find the tables and column...
February 7, 2013 at 5:32 pm
It's a good practice to check all your large tables if their FK columns are indexed. Especially if you know that parent table (PK table) will regularly execute deletes.
February 6, 2013 at 2:47 am
does that mean all my FK columns should really be indexed?
No, just those on (potentially) large tables whose parent table will ever execute delete command.
On delete, SQL internally SELECTs child...
February 6, 2013 at 2:30 am
Viewing 15 posts - 91 through 105 (of 368 total)