Viewing 15 posts - 8,431 through 8,445 (of 9,244 total)
i would drop the statistics in the source (sql2000) database. As Gail said they will be re created if needed (assuming you have auto create statistics enabled on the database).
you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:45 pm
kotlas
have you read the links Steve supplied?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:28 pm
scripted backup\maintenance jobs are your best option. Maintenance plans are becoming legacy.
why truncate the log before the backup? What is the recovery model of the database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:19 pm
when rebuilding online simply specify sort_in_tempdb on or off. If a sort is required and you use tempdb just ensure that the location of tempdb has enough space
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 1:17 pm
what version of SQL2005 are you using?
default fill factor if not changed is 0 which means 100%
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 10:43 am
DROP STATISTICS statisticsname
you can list more than one just separate them with a comma
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 12, 2009 at 10:33 am
alter permissions on the table would be required or one of the built in database roles db_owner or ddl_admin. All of these provide way to many permissions just to truncate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2009 at 3:29 pm
tung (2/11/2009)
Support for AWE is available only in the Enterprise and Developer editions and only applies to 32-bit operating systems.
Again, we are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2009 at 11:20 am
kotlas7 (2/10/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2009 at 1:50 am
I use SQL developer even against SQL server databases, it offers me JDBC connectivity to SQL, Oracle, Sybase and even Access.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 11, 2009 at 1:48 am
create a database role and assign permissions to the role, then assign the users to the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 5:31 pm
SQL developer can be used with Microsoft databases you just need to obtain and install the java library
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 5:29 pm
maybe you're confused. You select from a view not execute. As noeld said just grant select on the view to whatever role\user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 2:43 pm
Gift Peddie (2/10/2009)
I have used most and Oracle's SQL developer is not as good as SQL Server Express management studio.
snigger, and you think my statement was emphatic ROTFL
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 2:38 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]One thing to bear in mind: Oracle is far more complex to set-up and administer from my personal experience than is SQL Server.
no one could argue...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 1:39 pm
Viewing 15 posts - 8,431 through 8,445 (of 9,244 total)