Viewing 15 posts - 2,401 through 2,415 (of 3,061 total)
The more distributed the I/O, the better - you already know that 😉
In regards to which option is the better that's something only you can tell... check I/O for specific...
August 13, 2009 at 4:40 pm
dmw (8/12/2009)
So, if I want to 'create another schema' for a user, I must generate a pseudo user/schema and then grant access to my original user.
The beauty of it is...
August 13, 2009 at 4:33 pm
I'm in agreement but I have a problem with statement below...
doug.williams (8/11/2009)
August 11, 2009 at 12:03 pm
Is it a one time task or a recurrent one?
How many rows?
Either way, a SSIS package woud do the trick.
August 10, 2009 at 12:16 pm
Clive Chinery (8/7/2009)
Thank you. I will just document that the ALTER permission is required.
This is not what Paul said, read again.
August 8, 2009 at 4:26 pm
Just for documentation purposes and to clarify the missleading title that reads "Is CHECK constraint same as TRIGGER?" ... no, check constraint and triggers are not the same.
August 8, 2009 at 4:16 pm
fjmorales (8/6/2009)
The size of a row. I need this info to forecast the amount of space that certain table will occupied after X amount data inserts.
For real world capacity...
August 6, 2009 at 3:37 pm
Nikki (8/6/2009)
I want to prevent them from accessing database information through sql management studio and query analyser.
Wrong. Problem is not the tool, problem is sloppy security.
No reason for an "user"...
August 6, 2009 at 3:03 pm
madhu (8/6/2009)
Is this possible?
Yes. We have done a whole bunch of those.
Just pray developers have not used EE exclusive features and, please remember to script/apply logins, jobs, etc.
August 6, 2009 at 2:57 pm
During a maintenance window I would...
1- Set database to simple recovery model
2- Load table as SELECT INTO
3- Set database back to original recovery model
4- Take a backup
Another alternative would be...
August 6, 2009 at 6:18 am
This is not an optimization issue.
Inline view a.k.a. subquery is returning multiple values, update statement cannot update a single row with multiple values then it fails.
For update statement to succeed...
August 5, 2009 at 11:53 am
david.tyler (8/5/2009)
FYI - I...
August 5, 2009 at 11:37 am
Viewing 15 posts - 2,401 through 2,415 (of 3,061 total)