hi there,

unless you need the ResName to be part of the output you won't need "2. Table Resources" in your query

Try something like this

select c.CompID, t.ResID, t.TaskID, t.Date, t.Hours

from...

so you've got one database that has 300 tables... and 8 to 10 new entries are recorded in each one of these 300 tables every second... and these are coming...

along the same lines as other posters, you can consider creating a new 2k database, then use RedGate SQL Data Compare (you can use the trial for free) to copy...

I just tried SQLAuditor.... the tool available there http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx

It doesn't seem you can create custom rules, the tool will look through the database for violation of standards defined...

yeah for the formatting SQL Refactor can help, although I find the Lay Out SQL feature could use more customizable features... but if you are happy with the way it...

I never tried it but I came across this page before

http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLServerDatabases.aspx

these guys made public their standards for a bunch of things, and they made available one of the...

both the French and the English questions left me puzzled... I answered the French one

je ne suis pas certain de comprendre ta question, le fait que le sujet a été coupé n'aide pas

(comment executer une requet qui fait appel a...)

aussi ce que tu appelles...

if you want to venture into analyzing the execution plan of your proc, look for "Index Scan"... that will give you clues on indexes (or WHERE clauses...) that should...

I will have to agree with the other posters,

a. Proc way too long, makes it really hard to pin point the bottlenecks in it, especially since we don't...

Did you enable TCP/IP on your SQL Server instance? It's defaulted to false with 2005

You can check here

C:\WINDOWS\system32\mmc.exe /32 "C:\WINDOWS\system32\SQLServerManager.msc"

SP2 is the latest one for SQL Server 2005, but Microsoft announced they would release SP3 sometimes in the end of the summer... it could get release any day I...

hi there,

have you considered looking at performance counters? In 2005 there is a system view that provides you lots of information

SELECT * FROM sys.dm_os_performance_counters WHERE counter_name LIKE '%mem%'

If you...

small change to the script proposed,

to get what I need in the right order the code has to be...

SELECT Entered AS EffectiveDateTime

, (SELECT TOP (1) ItemAPriceID FROM ItemAPriceLog...

Thanks to both of you, very clever solutions 🙂 I knew there would be an easier way then what I started doing on my side before posting this...

clustered indexes ->...