Viewing 15 posts - 2,986 through 3,000 (of 9,703 total)
David Burrows (12/17/2014)
A repeater control populated with a datasource containing...
December 17, 2014 at 5:34 am
BTW, can anyone with Visual Studio coding experience take a look at my question here?
I've been fighting this on and off for several months now and just can't seem to...
December 17, 2014 at 4:55 am
That makes me feel somewhat better. Thanks, Koen.
December 17, 2014 at 4:47 am
Brandie Tarvin (12/16/2014)
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.
Current execution...
December 17, 2014 at 4:42 am
WHOO! #HappySnoopyDance
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.
Current execution time ......
December 16, 2014 at 12:13 pm
ramana3327 (12/13/2014)
We are assigned public server role to that...
December 15, 2014 at 6:02 am
ramana3327 (12/11/2014)
SA account is already disabled. so I need to give public server role and map as dbowner for remaining databases right?
Yes. That will prevent them from accessing server level...
December 12, 2014 at 5:20 am
ScottPletcher (12/11/2014)
Have you compressed large indexes when useful?
Have you reviewed that you have the best clustered index on each table? After that,...
December 12, 2014 at 5:19 am
Brandie Tarvin (12/11/2014)
ramana3327 (12/10/2014)
Hi,We have a login with windows authentication. That login has sysadmin and public server roles. But We didn't map that login to some user databases.
There is your...
December 11, 2014 at 1:02 pm
If you are sure that your growth rate holds steady at 70 GB per month, then take that number multiplied by the number of months you're projecting. Add that to...
December 11, 2014 at 11:37 am
So again, what are you trying to accomplish?
Without that context, your original question is rather meaningless to the rest of us.
December 11, 2014 at 10:40 am
As much as it pains me to say this (because it could cause performance issues), I think your best bet is to put in an AFTER trigger to rollback the...
December 11, 2014 at 7:19 am
I've never actually disabled any login except the sa and guest (old days) logins. And so far as I know, that's a server-level setting only. I'm pretty sure that once...
December 11, 2014 at 7:17 am
I think you are correct. I would advise creating a server level public login to go with that DB login, though, for ease of maintenance and to prevent it from...
December 11, 2014 at 7:02 am
GilaMonster (12/11/2014)
There's no need to have free space on the drive, as long as there's free space in the database...
December 11, 2014 at 7:00 am
Viewing 15 posts - 2,986 through 3,000 (of 9,703 total)