Viewing 15 posts - 1 through 15 (of 319 total)
Would advice you to run tuning advisor and analyse the index it returns..
or see if below suggestion resolves key lookup.
Include below columns in index [HumanaAuditClaims].[dbo].[ClaimLine].[idx_ClaimLine_ClaimSummaryUID]
[HumanaAuditClaims].[dbo].[ClaimLine].ClaimLineUID, [HumanaAuditClaims].[dbo].[ClaimLine].ChargedAmount, [HumanaAuditClaims].[dbo].[ClaimLine].PaidAmount, [HumanaAuditClaims].[dbo].[ClaimLine].RevenueCode
June 5, 2013 at 4:11 am
hvermaak (6/5/2013)
GilaMonster (6/5/2013)
hvermaak (6/5/2013)
Open profiler,File, new trace.
Connect to your sql server.
Use the template -> select Tuning
select save to file -> choose a location with sufficient space
I would strongly recommend...
June 5, 2013 at 2:44 am
SQL Geek (6/5/2013)
Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.
do check which process is taking up high CPU.. is it sqlserver or any other process.
June 5, 2013 at 2:42 am
you can check SQL source control from red gate. Also, having scripts in database is kind of similar a document store. Do more research on document store..
October 5, 2012 at 7:28 am
you can use a version control tool for it.
October 5, 2012 at 7:05 am
Hi Sarab - thanks for the info.. will get in touch
January 25, 2012 at 9:15 am
I didnt. Msg me ur contact details. Probably we can start one 🙂
December 5, 2011 at 10:06 am
what exactly you did??Did you tried to login into the other server with the username you created.
November 12, 2010 at 12:49 pm
create a username in both domain with same name and password. I have tested for a workgroup and domain...
November 12, 2010 at 12:20 pm
does that means that any one with permissions on table can access the data even if it is encrypted?
October 13, 2010 at 9:59 pm
homebrew01 (7/21/2010)
Sqlfrenzy (7/21/2010)
also check for the compatibility level of database. keep it 80.
Why ? You will miss out on many 2005 benefits.
OP: This has been covered many times....
July 21, 2010 at 5:29 am
run the upgrade advisor and look for issues.
If every thing is fine then script out the logins at 2000 - google how to transfer login between sql servers.
Then use backup/restore,...
July 21, 2010 at 4:19 am
got it...a known isu..must have googled before posting .. 🙂
July 20, 2010 at 1:30 am
linked server is on A and am just accessing it from server C.
July 19, 2010 at 10:58 pm
Viewing 15 posts - 1 through 15 (of 319 total)