Viewing 15 posts - 331 through 345 (of 468 total)
i would like to try the sp_OACreate method of doing this. Ive tried to look it up online ( spent the last 45 mins) but all i can find out...
June 16, 2008 at 3:37 pm
hmmm. thats an idea, but is overkill, for something that was supposed to be very simple.
might just send an email to an alias whenever the server is restarted to notify...
June 16, 2008 at 1:22 pm
great. thanks for all your help Gail.
May 28, 2008 at 6:35 am
anyway i can work out cold hard numbers or have more concrete evidence of how easy server traces are on resources? i need to be able to justify it to...
May 28, 2008 at 6:20 am
yea, it does. im not having a problem, im just playing around with backups as i had a few spare minutes and this question kept bugging me. Thanks.
May 9, 2008 at 10:58 am
one more piece of info that may be useful, i can see any databases that were created during the installation of slq server 2008, but the one im interested in,...
April 9, 2008 at 8:31 am
i know it can be done as ive seen blogs where they compare the the restore time of a compressed and uncompressed DB using perfmon.
If i come up with...
April 9, 2008 at 7:59 am
still shows no instances. is there some settings in sql server or new to sql server 2008 that means you have to enable it to be viewable in perfmon, or...
April 9, 2008 at 7:17 am
yea. i have sqlserver 2008 installed.
I have discovered that if in the "Select counters from computer" box i type localhost or 127.0.0..1 i can see all the db's from my...
April 9, 2008 at 7:02 am
Steve Jones - Editor (4/8/2008)
The colored lines are a display feature. Not something you return in T-SQL.
thanks Steve. This again is something i know. I know Perfmon is not part...
April 9, 2008 at 2:12 am
Steve Jones - Editor (4/8/2008)
The colored lines are a display feature. Not something you return in T-SQL.
thanks Steve. This again is something i know. I know Perfmon is not part...
April 9, 2008 at 2:11 am
i had an idea i could do it this way also but i wanted the nice visual colored lines in perfmon for a presentation on how much quicker a backup/restore...
April 8, 2008 at 2:20 am
just out of curosity, is this possible using just the one table ( see DDL code above for table info).
April 1, 2008 at 6:47 am
works perfectly. thanks for the help. with the help here i am getting better, honest! some queries just get me.
April 1, 2008 at 5:54 am
you are absolutely correct.
Ive been staring at the screen for so long ive forgotten the point of the Merge command!
Ive gotten it to work this way:
;WITH OrderInfo AS (
SELECT
oi.ordernumber,oi.customernumber,oi.orderdate,c.customerid
from...
March 31, 2008 at 7:56 am
Viewing 15 posts - 331 through 345 (of 468 total)