Viewing 15 posts - 8,356 through 8,370 (of 9,244 total)
Paul Randal (3/7/2009)
I can do databases
oh you do those too in your spare time Paul! LOL
we use Redgate and set the redgate extended stored procedure to 'verify', not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:16 am
Sailor (3/6/2009)
Disk time on all servers is pretty low. Only one of them has any sort of activity which around 10%...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 4:16 am
that's a good point Jeff, although Simple and Bulk Logged recovery do minimally log create and alter index transactions
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 6, 2009 at 4:18 am
as already mentioned, you really do need to take a good look at the disk subsystem
minimum you could get away with would be
RAID1 for OS (2 disks)
RAID1 for logs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 3:59 pm
dastagirid
i am assuming from your post that you want a script to generate an insert statement for each row in a table, is that correct? If so, take the following...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 3:13 pm
Gail
i was under the impression that a database backup in simple recovery mode also initiates a checkpoint which will truncate the log file
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 2:37 pm
exactly how many disks do you have available?
what version\edition of windows do you plan to use?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2009 at 2:08 pm
also dont forget to back up the database after the index rebuild as this could fill up the log file depending on database size and no of indexes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2009 at 4:28 pm
what is the result of the following query
select * from sys.backup_devices
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2009 at 10:14 am
exclude the scanner from scanning sql data and program files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2009 at 2:33 pm
you could use VBS something along the lines of
strComputer = "."
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2")
Set colItems = objWMIService.ExecQuery( _
"SELECT * FROM...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2009 at 2:30 pm
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 3:41 am
Viewing 15 posts - 8,356 through 8,370 (of 9,244 total)