Viewing 15 posts - 8,371 through 8,385 (of 9,248 total)
Ellis (3/3/2009)
I'm really sorry for the vagueness of this question, I need to expand my knowledge on running SQL Server in a virtual environment, for example using...
March 3, 2009 at 2:20 pm
Mani (2/27/2009)
I created a login abc with default database master and I need to give access to this abc login to a stored procedure SP_ABC in database Mydb.
have you mapped...
March 1, 2009 at 10:06 am
oohhh, this is pork chop territory. Me gonna duck and keep my faceguard on ROTFL
hey Jeff fancy seeing you in this thread 😉 LOL
March 1, 2009 at 10:02 am
Krishna (3/1/2009)
Index Rebuilding etc..
you probably don't want to be\shouldn't nedd to be doing this daily
March 1, 2009 at 3:41 am
or just use the stored procedure
sp_chane_users_login
to resync the server login and database user
February 28, 2009 at 3:32 pm
i assume you mean what are the ideal sizes for the log files?
the answer is how much activity is created against the database?
start off with 10% of database filesize...
February 28, 2009 at 3:30 pm
check BOL for full info on how to set this up
February 28, 2009 at 2:21 am
muthuuu (2/24/2009)
I got following message in sql-error log
Configuration option 'max server memory (MB)' changed from 2147483647 to 8192.
Run the RECONFIGURE statement to install.
SQL Server has encountered 1 occurrence(s) of...
February 25, 2009 at 6:15 am
i would say if you dont have access to it there is possibly a very good reason
February 23, 2009 at 2:28 pm
do you need to restore the db over the original or restore as another name?
February 23, 2009 at 2:25 pm
try a google search and you'll find loads like these
http://www.mssqltips.com/tip.asp?tip=1367
bear in mind if using any scripts that specify rebuild with ONLINE=ON this will only be used if using SQL server...
February 23, 2009 at 2:21 pm
hawg (2/23/2009)
how I can get it to use more?
increase the load on the server. I would set the min and max memory to be the values you want sql server...
February 23, 2009 at 2:11 pm
firstly how much RAM does the server have and how many sql instances?
February 23, 2009 at 2:06 pm
the index rebuild is bugging out before finishing because it cant complete the task i would think.
February 23, 2009 at 1:46 pm
hmm, not what i expected to see. When i carry out index maintenance i always set the recovery to bulk logged and then switch back to full afterwards. Alter and...
February 23, 2009 at 1:35 pm
Viewing 15 posts - 8,371 through 8,385 (of 9,248 total)