Viewing 15 posts - 4,891 through 4,905 (of 7,502 total)
Simon Facer (5/5/2008)
that script you published, I spent months getting rid of that very script from our production servers. You really need to add a line that categorically states that...
May 6, 2008 at 1:26 am
Isn't there a primary key / unique key missing ?
I mean, every row should have a unique pointer if possible at all.
My guess is your [id] column may be just...
May 5, 2008 at 2:38 pm
If you can figure out wich filenumber it is writing to, you can load it up to the lower filenumber.
Don't use the "default" keyword, because that will try to load...
May 5, 2008 at 2:27 pm
how about
Select Region
, sum(case Closed when 1 then 1 else 0 end) as Closed
, sum(case Closed when 1 then 0 else 1 end) as NotClosed
from [dbo].[hdRequests]
group by Region
order by...
May 5, 2008 at 9:16 am
You may have to perform this proc more than once because sqlserver can
only shrinkt op to the last active log part.
Source urls are included.
Play it safe, take a full...
May 5, 2008 at 9:11 am
You would have better posted this in the sql2000 forum.
- You could enable "audit login" for all. This reports logins to sqlserver errorlog. (Serverproperties page (Security) in EM)
- you could...
May 5, 2008 at 9:08 am
juts a first glimps:
- alter
select distinct Trust, InitialReview = ISNULL(convert(varchar(10),initialReview),0)
,ReReview = ISNULL(convert(varchar(10),reReview),0)
,TotalReview = ISNULL(convert(varchar(10),TotalReview),0)
--,Approval = ISNULL(convert(varchar(10),Approval),0)
--,QA = ISNULL(convert(varchar(10),QA),0)
,[TotalQAApproval] = ISNULL(convert(varchar(10),[TotalQA/Approval]),0)
,[TotalProcessed] = ISNULL(convert(varchar(10),TotalProcessed),0)
from vW_total_numbers
--where left(trust,8)...
May 5, 2008 at 7:42 am
Thank you for highlighting this valuable feature.
Saving +60% is certainly worth investigating it to the bone, considering the vase amount of backup data we produce.
Nowadays we compress the backup by...
May 5, 2008 at 6:33 am
just to add:
It's not mandatory to have diff backups.
Differential backups can help out if you have a huge log-backup load.
In that case,by using diff backup, you can skip restoring log...
May 2, 2008 at 2:17 pm
- as already mentioned, IO is probably the most slowdown factor.
- do you rebuild indexes (clix / nci) on a regular bases ?
- check your db for "auto update statistics"....
May 2, 2008 at 2:10 pm
...requires a unique key column to display the data....
Keep in mind you'll not be able to use that key column to go back to the db !
Isn't a combination of...
May 2, 2008 at 2:03 pm
- Write the message to a proprietary message table and let the job that is started by the alert read that table and cleanup the data.
- SQLServer Service Broker can...
May 2, 2008 at 7:51 am
Get rid of the cursor !
use this instead:
update P -- I supposed you want to modify UsgSvcMultiProvision.StatusID
SET StatusID = @ProvStatusID
FROM UsgSvc U
inner join Customer C
on U.CustID...
May 2, 2008 at 7:27 am
Job well done ! :smooooth:
Now determine what kind of backups you want to take, what kind of recorvery timeframe you need,...
(also re-evaluating your db-recovery-settings (simple/bulk logged/full)
Read books online for backup...
May 1, 2008 at 3:06 pm
your information schema check executes in context of the current database you are connected with !
If you are not connected to the @dbname, you are validating other data !
So
If...
May 1, 2008 at 2:57 pm
Viewing 15 posts - 4,891 through 4,905 (of 7,502 total)