Viewing 15 posts - 361 through 375 (of 2,462 total)
m.rajesh.uk (1/30/2013)
My client want me to check the structure of the SQL Server.
Pretty generic question. Here two things can be done.
First and preferred, Ask him what exactly he...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 31, 2013 at 12:03 am
solomon.jernas (1/30/2013)
two procedure we found , one is insert and another update with same table,...
check whether your indexes are supportiing those queries or not ? , and have...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 11:47 pm
find out the spid by sp_who2 and use dbcc inputbuffer(spid) and pull out the queries which are creating problem.
is it a sudden deadlock occured or lingering from ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 10:31 pm
anthony.green (1/30/2013)
Did you investigate what the SPIDs where doing which blocked you?
THe were some internal processes spid < 50
anthony.green (1/30/2013)
Did you try setting the DB into single_user mode?
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 10:14 pm
i missed to post here but i also tried to change the recovery model to simple but again this also cause blocking (seen by sp_who2) so i stopped in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 4:00 am
this is not actual query (not the actual table too) . Anyways Do you have index on ID column here ?
and do you need complete table in this query ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 3:49 am
Run DBCC CHECKDB WITH ALL_ERRORMSGS ; and post result here
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 3:43 am
Radu Costescu (1/29/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 30, 2013 at 12:25 am
Danah (1/29/2013)
I do tend to "undersell" myself when it comes to salary negotations and so on.
totally based on your confidence how you project your self and you experience infront...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 29, 2013 at 11:46 pm
This put me on surprise, the guy who is having 14+ exp (i must say pot filled with drinking water) getting confused with his title (which doesnt matter often)
the thing...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 29, 2013 at 11:41 pm
imani_technology (1/29/2013)
1) the production backups are located in a place the test systems can't reach
the easy or safer way is , copy the backup to drive which is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 29, 2013 at 11:02 pm
sqldba_newbie (1/28/2013)
You still didnt answer my question.
i cant , without seeing the actual query exec plan (before changes and after changes), post the plans then based on that i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 11:25 pm
purushottam2 (1/28/2013)
Once user start accessing application then only it lead to 100% cpu consumption.
then sql profiler trace might help you , set the trace and try to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 11:12 pm
Another thing which we need to consider is ,look for queries that run under parallelism and test them manually using different levels of DOP using the OPTION(MAXDOP n) query hint...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 4:06 am
mpradeep23 (1/27/2013)
Can i store the database creation script in a table call the script in stored procedure to create new database with tables and stored procedure
Yes this can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 28, 2013 at 4:03 am
Viewing 15 posts - 361 through 375 (of 2,462 total)