Viewing 15 posts - 8,431 through 8,445 (of 9,241 total)
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
out of interest, what are your current min and max memory settings?
how many instances of sql?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 7:00 am
Steve
yes i read into it that he just wants to test and sanitise the actual restore processes required so if he ever has to do it for real he'll have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2009 at 6:10 am
hey dont get me wrong i like SQL server and as you say price\performance you cant beat it. By flexibilty i am referring to the scalability of the Oracle cluster,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2009 at 4:35 pm
Viewing 15 posts - 8,431 through 8,445 (of 9,241 total)