Viewing 15 posts - 526 through 540 (of 611 total)
I was confused the first time I saw a table had 75% fragmentation and nothing could be done to reduce it. Other tables I could reduce to 3-4% fragmentation....
March 25, 2013 at 7:37 am
24tjf (3/25/2013)
I needed to text qualify the data as some of the data had commas in it, e.g. ACME, Inc.
http://msdn.microsoft.com/en-us/library/aa174646(v=sql.80).aspx
I think you will find BCP can perform that function in...
March 25, 2013 at 7:32 am
runal_jagtap (3/19/2013)
Jeff, No we would never need a data a month old, incase if someone needs the data we can retrieve it from Archive DB..but whats the best approach???:w00t:
Would it...
March 25, 2013 at 7:18 am
Hi there,
If you want to impersonate a user and that user exists in AD, then you need to create a login for that user before it can be impersonated. ...
March 25, 2013 at 4:58 am
I think I have understood what are asking! When not then I am sure you will let me know!
We have Groups in AD and obviously These Groups are populated...
March 24, 2013 at 1:09 pm
Ahhh.....the Beauty of Oracle!
Restoring a table can of course be done by extracting the table from a dump but easier is to ENABLE_ROW_MOVEMENT on the table in question.
You can then...
March 21, 2013 at 1:26 pm
The ability to recover tables is in my opinion one of SQL Servers weakest Points. For us that was so critical for a particular application that we opted for...
March 21, 2013 at 12:50 pm
Nice answer! You may not love but it is certainly a challenge!
The 'sa' account as you have mentioned becomes a risk if someone can get hold of the password...
March 21, 2013 at 8:12 am
Hi folks,
I just want to point out that although I have been ranting on about the benefits of attach/detach for a database test machine, I have to concede I have...
March 21, 2013 at 3:46 am
Good point. I actually just wanted to say that if was disabled in Windows authentication it would remain disabled in mixed-mode. You have cleared that point up!
March 21, 2013 at 3:40 am
You would love my environment then! I have 30 instances on a single box!
For the two instance argument it means I can protect the databases that run Integrated Security...
March 20, 2013 at 11:52 am
i hear your point but....
A. They only have themselves to blame then
B. They only have themselves to blame then
C. see point A
You aren't doing yourself any favors...
March 20, 2013 at 9:22 am
I see your point. Thanks for the comment!
March 20, 2013 at 9:16 am
And that is my argument for at least two instances on each database server.....one with and one without! 🙂
March 20, 2013 at 8:50 am
george sibbald (3/20/2013)
to everyone out there, attach with rebuild log is a last resort, please don't replace restores with it.
Apart that only a restore can replace a damaged mdf file,...
March 20, 2013 at 8:48 am
Viewing 15 posts - 526 through 540 (of 611 total)