Is there a field taht is unique and even if two records have the same date time it will be incremented or one value is greater than the other? If...

I find most people go with 4 total and some go with 2 per CPU. Check both of these links out.

http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp

http://www.swynk.com/friends/trawick/Perfbase.asp

So in either case 0.985 looks find to me.

"Don't...

I agree with Andy and Chris. It really burns me when a vendor doesn't look into root cause and does a patch method of work. If you enable flasg -1204...

We are talking internal frgmentation, file fragmentation is an external issue and yes it can be avoid if you plan properly. First by placing log files and data files on...

Can you create the variables and it just doesn't pass or you cannot do this even?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Please do not cross post. Other thread is http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4722&FORUM_ID=5&CAT_ID=1&Topic_Title=Passing+in+Variables+into+a+Stored+Prodedure&Forum_Title=Administration

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Normally and to the best of my knowledge a temp table drops almost instantly simple because the data is stored in tempdb and a pointer is associated as the temp...

There always exists a PRIMARY filegroup and you cannot change this. If you need to have a user use a specific filegroup set then have their tables created on another...

What are you trying to get exactly? PerfMon is more of an average overview, where Profiler can pinpoint specific items, but there may be other options too such as DBCC...

Really there is no difference except they may have created the account on the domain which they have direct access to if you block their access in production SQL. Also...

Andy is right. If you click on the item the text will appeqar in the bottom section in full.

"Don't roll your eyes at me. I will tape them in place."...

I use it often and never have issues. Mostly what I use it for is representing 15 minute increments of an hour in a scheduling database. I wanted 24 columns...

Yes that is what I meant. Please post the entire contents, maybe I can see something.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Sorry couldn't help more, cannot find anymore detsail on this. Have you tried to turn logging on in the DTS package itself? May output a bit more detail.

"Don't roll your...

Maybe not, I just double checked, and cannot get to do right off. I thought we had gotten one this way previously in testing but so many changes I cannot...