Viewing 15 posts - 8,446 through 8,460 (of 9,241 total)
for your user databases, yes. Either backup and restore to the 64bit server or detach\attach the database files.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 4:14 pm
Andrew Reilly (2/5/2009)
yet when the redundanies came it was all of the most experienced staff (and highest paid presumably) that got the chop.
i've worked for 2 software houses now in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 3:47 pm
Oracle is by far the most powerful and flexible of the two.
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers failover and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 3:42 pm
Steve Jones - Editor (2/9/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 2:57 pm
jbloes (2/9/2009)
I couldn't find a free MS Virtual Server...do you have the link?
http://www.microsoft.com/technet/virtualserver/software/default.mspx
you will need to register, thats the only requirement.
Steve (2/9/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 2:47 pm
select * from ::fn_trace_getinfo(default)
peace2007 (2/8/2009)
My traceid is 2 and fn_trace_getinfo shows nothing for that;)
using the exact command above what traces does it show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 4:03 pm
SQLBOT (2/8/2009)
My advice is when going 12 GB or higher to ditch the /3GB switch..
the official standpoint is 16GB RAM but i have seen situations where systems with a lot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:53 pm
i wouldnt personally enable\use xp_cmdshell
schedule a windows task to run a batch file. The batch simply copies the file from one location to the other (maybe a mapped drive to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:15 am
grab yourself a copy of VMWare server or MS Virtual Server Ent 2005, they're both free.
set up a sql server VM and practice DR on that 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 3:09 am
peace2007 (2/7/2009)
Have you tried running the trace as a server side trace rather than through profiler? That should have noticeably less impact.
1) Start the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:51 am
joba
run the trace server side so as not to use too much resource from the server. Either generate the script yourself (search this site for examples and check BOL) or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:38 am
Tung
sql2005 standard will address RAM to the operating system max, so no problem there. For a machine with 12GB RAM you may want to remove the /3GB switch from the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2009 at 2:34 am
VEB
you really are making more complex than it actually is. The whole point of a domain is to centrally manage obects within the domain. If your SQL server is part...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2009 at 6:23 am
Great article Jonathan, should wet peoples appetites for CLR a little
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2009 at 2:05 pm
th post installation will be on the program menu on the server. Yes run the post install and configure a service. Our sql server is on SQL2005 SP2
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2009 at 6:49 am
Viewing 15 posts - 8,446 through 8,460 (of 9,241 total)