Viewing 15 posts - 16 through 30 (of 60 total)
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
September 16, 2008 at 10:41 am
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...
September 16, 2008 at 7:47 am
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...
September 15, 2008 at 1:28 pm
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...
September 15, 2008 at 9:50 am
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...
September 15, 2008 at 9:29 am
I never tried it but I came across this page before
these guys made public their standards for a bunch of things, and they made available one of the...
September 15, 2008 at 8:00 am
both the French and the English questions left me puzzled... I answered the French one
September 15, 2008 at 7:34 am
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...
September 15, 2008 at 7:33 am
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...
September 12, 2008 at 2:12 pm
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...
September 12, 2008 at 2:11 pm
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"
August 19, 2008 at 1:51 pm
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...
August 19, 2008 at 1:47 pm
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%'
August 19, 2008 at 1:38 pm
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...
July 17, 2008 at 4:31 pm
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 ->...
July 17, 2008 at 4:16 pm