Viewing 15 posts - 8,341 through 8,355 (of 9,241 total)
hey, your welcome buddy 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 11, 2009 at 2:17 am
i think the windows registry would be the best place to look
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:34 pm
try running it once a week during a known period of low or no activity!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:32 pm
GSquared (3/10/2009)
stuck with going back to your last full backup,
or differential if you have them.
Simple recovery logs just about the same as Full recovery although some transactions are minimally...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:16 pm
what is the error you are seeing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 4:09 pm
in Profiler select the "Audit Shema Object Access Event" and filter it to look for your database name and object name (this should match the name of the table)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 12:39 pm
the following should generate the alter schema commands to change schema for any Stored Proc not owned by dbo
select 'alter schema dbo transfer ' + sch.name + '.' + tab.name
from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 10, 2009 at 12:09 pm
if a manager asks you to setup Perfmon to monitor sql server processes and uses (especially on a multi instance box) he wouldnt expect you to say " yeah i'll...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 3:42 pm
i had a telephone interview last week for a job and the interviewer asked me to provide port numbers for some commonly used TCP ports (e.g. DNS, SQL, POP3,etc). If...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:40 pm
GilaMonster (3/8/2009)
Perry Whittle (3/8/2009)
also depends on if they mean client or server side. Server process is sqlservr.exe
Server or client, how important is it really for a candidate to know that?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 1:32 pm
also depends on if they mean client or server side. Server process is sqlservr.exe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:33 am
Jeff Moden (3/8/2009)
And there is no "run SQL Server faster" button
aww shuks, i been lookin for that one LOL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 8, 2009 at 11:29 am
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
Viewing 15 posts - 8,341 through 8,355 (of 9,241 total)