Viewing 15 posts - 211 through 225 (of 2,462 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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 26, 2013 at 3:26 am
AlexMcCo (9/25/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 6:55 am
i second Talib123 here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 6:42 am
Also check If itemcode must be part of any index , to get the result faster.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 6:38 am
check the states of all sys data bases too
select state_desc, * from sys.databases.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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 ? ??
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 4:03 am
use tempdb
go
select filename, * from sysfiles
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 25, 2013 at 4:01 am
Viewing 15 posts - 211 through 225 (of 2,462 total)