Hey Lynda,

We're starting up a PASS Chapter in Southern New England. It's hard work. The only thing that I've found interesting so far is how easy it is to get...

You can't really get these types of counters directly out of SQL Server 2000. But in 2005, you can reference the dynamic management views such as sys.dm_os_performance_counters. Run the select...

Yeah, I'd drop the clustered index and make the PK clustered. It's as you said, the leading edge to the PK is the same as the clustered index, so one...

You basically can't do that.

You can do something like this:

WHERE 1 = CASE

   WHEN evaluate something & return 1 or 0

or

WHERE SomeColumn = CASE

   WHEN evaluate something THEN some value

You're trying...

Hey,

Getting a design is usually very dependent on business needs, but you should be able to set up the database to accept any given start & stop time and then...

Where did you sit? I was in the back corner across from the build server...

So.... you want what? Advice on Training? Solid Quality Learning has some of the best courses I've ever been to.

Books? The "Inside SQL Server" series is a little advanced, but...

Why? It can't possibly be that bad.

I love IT. I'm clean, inside, sitting down, no one is shooting at me, nothing is likely to chew one of my appendages off, I'm well (some would say over)...

This is a bigger topic than the question suggests, but in a nutshell...

You won't be able to manipulate the database of the 3rd party app. Assume that. If it's wrong,...

Since the DATEDIFF was done with 'dd', it's assuming differences in day only. If you're also trying to identify differences in time, which I suspect the Access app deals with...

If you can use identity values, why not use them on the table that you're inserting into?

But, if you can't, you may to look at something like this instead: http://www.sqlmag.com/Article/ArticleID/48165/sql_server_48165.html

If...

When you say "same database" do you also mean on the same server?

This is one well documented approach for performance tuning:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx

Try creating a user defined function that returns your next id and then you can call that function from the select statement.

CREATE Function fn_GetId ()

RETURNS INT

AS

   BEGIN

      ...your code here

  ...