Viewing 15 posts - 8,221 through 8,235 (of 9,241 total)
Hi
passive nodes first, check this link for further details
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 30, 2009 at 1:14 pm
rgillings (4/16/2009)
Truncate also will RESEED a table.
that is correct
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2009 at 1:54 pm
the 2 biggest differences between std and ent are online index rebuilding and partitioning. Also AFAIK page level restores are only available in sql2005 ent
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2009 at 7:14 am
also, if i remember correctly truncate will reset any seed\incremental value on ID columns,etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 15, 2009 at 6:57 am
yes, i thought of that but running it through SSMS the query takes a short while and thats just on my laptop. Imagine on a server with 4 or more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 4:47 pm
RBarryYoung (4/13/2009)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 10:10 am
this should cut down on the amount of procedures returned
select 'exec sp_helptext ' + name from sys.objects where type = 'P'
and is_ms_shipped <> 1
order by name
you dont want...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:35 am
presumably you are using sql2005 standard x64?
you may want to set the min memory to something sensible!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:19 am
hmm ok, the enumavailablemedia is pretty straight forward but i cant find any usage info for enumdirectories. Currently my treeview is populated with 2 logical drives and some folder entires...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 13, 2009 at 6:16 am
set up a simple server side trace and leave it running for a day or so. Should be able to find out/what is changing the status!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 2:24 pm
has the TCP/IP port number been changed under TCP/IP settings?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 5:38 am
dobrien (3/11/2008)
-c(still don't know what this is for)
David, this parameter stops the service being updated (i.e. running/stopped/etc) in the services.msc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2009 at 5:36 am
Flo\Barry
thanks a lot, i only need the drive name and then the folders underneath. I'll check out the items posted and see how i get on
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 9:41 am
samsql
to start, can you please post the following info
SQL server version/edition:
OS version/edition:
min memory for sql:
max memory for sql:
you say the server has 16GB ram is that correct?
what exactly do you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 6:13 am
i need to populate a treeview object with fixed drives and their folders
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 5:29 am
Viewing 15 posts - 8,221 through 8,235 (of 9,241 total)