Viewing 15 posts - 8,056 through 8,070 (of 9,244 total)
create index and alter index rebuild are both minimally logged.
What is it leads you to believe they're not?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 3:02 am
hi
can you post a screenshot of the server logins from management studio
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 2:21 am
Jeffrey Williams-493691 (4/19/2010)
there are times when using a local account is the right thing to do.
in my opinion only when using a windows workgroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2010 at 2:02 am
local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you do in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2010 at 2:45 pm
either perform a
RESTORE FILELISTONLY FROM DISK = 'diskpath\filename.bak'
or use the following against the original database
Use yourdb
exec sys.sp_spaceused
this will give you an idea of the space used\required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2010 at 2:36 pm
If you're using VMWare ESX\VI then VMWare don't recommend 4 vCPU's. In extreme cases it can cause the host CPU to max out. All VM's are generally created with 1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2010 at 8:58 am
Grant Fritchey (4/19/2010)
For anything beyond the simplest mom&pop sized database, it's recommendations are so...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2010 at 8:54 am
You only need to licence the physical CPU sockets or in the case of a VM the virtual CPU's.
If you license the VM host machine at SQL Server Enterprise edition...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2010 at 1:00 am
i could be wrong but i believe that should be COPY_ONLY, this stops the backup interferring with the usual backup regime currently in force on the source server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2010 at 3:19 am
Jeffrey Williams-493691 (4/17/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 5:15 pm
Jeff Moden (4/17/2010)
T-SQL or a "C#/Java programmer with some SQL" when I conduct an interview for a DBA or SQL Developer.
ahh that old chestnut. Procedural vs set based 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 5:10 pm
Hi
i'm assuming you want to transfer your Access database to a SQL Server database. If so, try the "Upsizing Wizard" in MS Access 2003
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 3:48 pm
firstly using the SA account to provision access to a sql server database is a really bad idea.
If you restore a database to a different server without exporting the server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 2:46 pm
Steve has the correct solution here!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 2:22 pm
Jeff Moden (4/17/2010)
Man, I was going to jump on this at the first post. Good thing I'm trying to read the whole thread before responding. Good catch, Perry.
ha...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2010 at 2:10 pm
Viewing 15 posts - 8,056 through 8,070 (of 9,244 total)