Viewing 15 posts - 211 through 225 (of 2,463 total)
Sean Lange (9/25/2013)
IM.ItemCode BETWEEN '999999' AND 'CL00000'AND IM.ItemCode NOT IN ('001920', '001921', 'CL01926', 'CN00229', 'CN00230')
[/code]
Sean,
Talking about the selection of "NOT IN" over "Between" i have experienced that...
September 26, 2013 at 3:26 am
AlexMcCo (9/25/2013)
September 25, 2013 at 8:35 am
Grant Fritchey (9/25/2013)
Log backups are different.
But how does the LSN get matched ? i mean their sequence because that will be required to ordered restore
September 25, 2013 at 7:05 am
frdrckmitchell7 (9/25/2013)
No, it's not part of an index in this scenario
Then study the related exec plan and see if it ask for improvement(index addition or updation)
September 25, 2013 at 6:59 am
gary1 (9/24/2013)
I noticed that the sql queries are causing the PLE to drop and I'm trying to find the exact queries.
If there are culprit SP then recompile them...
September 25, 2013 at 6:55 am
i second Talib123 here
September 25, 2013 at 6:42 am
Also check If itemcode must be part of any index , to get the result faster.
September 25, 2013 at 6:38 am
check the states of all sys data bases too
select state_desc, * from sys.databases.
September 25, 2013 at 6:31 am
try sp_lock and see where you have LOCK- X records , check the Spid for that in Sp_who2
and try this too
SELECT
db.name DBName,
tl.request_session_id,
wt.blocking_session_id,
OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,
tl.resource_type,
h1.TEXT AS RequestingText,
h2.TEXT AS BlockingTest,
tl.request_mode
FROM...
September 25, 2013 at 6:30 am
unforturnately ... you probably wont get any response . because people here can help you when you help them/us to help you
MEANS
Post table defintion with sample data...
September 25, 2013 at 5:50 am
bryan 29523 (9/24/2013)
It's a production server, but there only 6 databases. I am considering detaching the DBs, wiping out the instance and re-attaching them.
NO.......
Dont try this ..there are very...
September 25, 2013 at 5:40 am
jacop (9/16/2013)
what can i do to be pro active in this new position?
In your daily list , there must be some monitoring job , some check list...
September 25, 2013 at 5:01 am
IgorMi (9/23/2013)
What is the recovery model of your TempDB? Default is SIMPLE, and it should be.
can we change it ? ??
September 25, 2013 at 4:22 am
ananda.murugesan (9/25/2013)
Can we create both operation in one single jobs via Mintenance plan?
Yes. on the left pane : maintenance plan task .. you will find both reorganize and rebuild...
September 25, 2013 at 4:03 am
Viewing 15 posts - 211 through 225 (of 2,463 total)