Viewing 15 posts - 9,076 through 9,090 (of 9,241 total)
SQL King (7/29/2008)
WOW, HOW DO YOU THAT?
eek now i'm getting worried 😀
how are you backing up the databases?
Via a maint plan or a custom job or maunal T-SQL script, etc?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:50 am
GSquared (7/29/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:48 am
the import wizard inside SSMS uses sql integration services so you have to have that installed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:43 am
The Oracle 10 client should be backward compatible with Oracle 8
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 8:21 am
ensure you scroll to the very top
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 8:13 am
why not just allow the sql maint plan or job to delete files after N days
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:39 am
thats what i thought.
when the wizard starts, after the welcome screen the next screen is the choose data source dialog. Drop down the list box "Data source" and "flat file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:37 am
how are you importing?
are you importing via SSMS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:29 am
in SSIS create a new project. Drag a new "Data flow task" from the Control flow items. Edit the new "Data flow task" and in the Toolbox under "Data Flow...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:03 am
filegroups offer managability but more over performance. They are primarily designed to be spread across disks\arrays and unless doing so are not going to be of any benefit to be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 6:59 am
i personally wouldnt boot from the SAN, i would have local disks for the OS, stick everything else on the SAN. You have many options available just be sure to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 2:05 am
Hi Andy
this was exactly the same line of thinking i had. Very informative. I think you're right no-one ever changes the default for stats during the create index
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 1:58 am
yes very important make sure you keep a copy of the enterprise system databases incase you need to bring them back online otherwise you'll need the install cd to repair...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 1:11 pm
Jeffrey Williams (7/28/2008)
I am going to side with both Gail and Perry here
not to mention the tone with which the words echoed to whom i would class as a well...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 1:04 pm
gunna48 (7/28/2008)
sp_dropserver '[YourOldDatabaseName]'--Present Server name goes here
go
sp_addserver '[YourNewDatabaseName]','local'--New Server name goes here ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 28, 2008 at 12:58 pm
Viewing 15 posts - 9,076 through 9,090 (of 9,241 total)