I have set up a remote server side trace and selected to write data to a table on a development server. Below are the columns created. 60,000 rows inserted in...

The SQL Service is running under a domain account and the mapped drive has been modified to allow the domain account permission to write the file there. This has been...

Can you suggest what event selection items to use? Or which template? I have the trace file going to a mapped drive - not to the server.

I am enthused to know intelligent people are exploring technical solutions to the voting system. I hope they can explain the system to the average voter and build confidence in...

I watched a video on cryptography and voting from googletalks that applies to this discussion. The speaker, Ben Adida from Harvard, explains a system that provides the voter verification of...

That would be very handy. I am interested to see if you are successful.:)

I think this is an area that really needs a technological solution applied. What about those registered voters who are confined to bed in a hospital or without transportation?

I believe...

The question states "is the same as" and the term "equivalent" used in the explanation are essentially equal in meaning. They could be substituted and are generally considered equal in...

I did the same thing, edited the single line to two lines and it worked in QA. I was wondering if anyone had ideas on how this feature (GO 10)...

Carl Federl (7/18/2008)

---

"My Average Wait Time was 6. " No too bad, so now look at more detail:

select * from (

SELECT cast( IoStallMS as float) / ( NumberReads ...

Thanks for the recommendations and brief summary. I am continuing to research the options and will post the result selected by management.

SELECT db_name(DbId) as DatabaseName

,FileId

, Current_timestamp as AsOfTs

,NumberReadsas ReadCnt

,NumberWrites as WriteCnt

,BytesRead as ReadBytes

,BytesWritten as WriteBytes

,IoStallMS

from ::fn_virtualfilestats (default, default )

You should be looking at average wait times of less...

GSquared (7/18/2008)

---

If it's an OLAP database (which is what it sounds like, with infrequent writes and lots of reads), RAID-5 should work well for the data files, but you probably...

tosscrosby (7/18/2008)

---

barb.wendling (7/18/2008)

I do not have this procedure -

select db_name(database_id), * from sys.dm_io_virtual_file_stats(-1, -1)

The current system is using SQL 2000 and the database is loaded with changes from another...

DavidB (7/18/2008)

---

You can get some pretty decent understanding from here - http://msdn.microsoft.com/en-us/library/ms190764.aspx

Ultimately though it does depend on your environment as the amount of read / write activity really...