If you are running a TL backup to tape it could the throughput of the tape drive is the issue. There is a performance counter in performance monitor that can...

When the app is runinng to you retain a high number of apparently open connections? If so thn it may be affecting the connection release. Other than that I would...

Tim is right, it is very odd.

create table x (

ix int,

nx varchar(3)

)

insert x (ix, nx) values (1, 'cat')

insert x (ix, nx) values (1, 'dog')

now try

select * from x order...

Thinking further about this it might be even better to do this

SELECT DATEADD(d,DATEDIFF(d, 0, @DateTime),0)

Which means a common method for first day of month and year.

-- Method Month

SELECT DATEADD(m,DATEDIFF(m, 0,...

quote:

---

I'm not all that technical, but I have wondered why it continues to grab more memory rather than reusing what it has...

Also, look in BOL at AWE memory and how to configure.

You say CPU usage was < 5% but what was the memory usage at that point and besides SQL what was the heaviest user of memory. Also, many people say...

This is set on a per-connection basis. The way to control from the server, open EM and right click the Server in question, choose properties and goto the Connections tab....

Another good site to find information is http://www.aspindex.com

Method 2 would have made better sense to just do

SELECT CONVERT(DATETIME, CONVERT(CHAR, @DateTime, 112))

However, I had not seen method 1 before and I would say I like it very much...

In that statement it is true

quote:

---

In terms of storage and maintenance of indexes

---

beign the key....

Keep in mind if using QA that it has a set of connection options set of which concat null is on. Look at Tools/Options and the Connection Properties tab for...

I am not sure if it can be done and will depend on your Firewall, but the issue (I believe) is the Firwall does not forward those packets sent via...

I wear many hats myself and have so far been lucky enough to be both the Developer and DBA, but I have a good background in SQL and am constantly...

Primary keys biggest bennifit is to prevent insertion of duplicates. However if the majority of your queries do not use the PK column you will see better query performance for...