Viewing 15 posts - 361 through 375 (of 2,463 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...
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...
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 ...
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?
...
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...
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 ...
January 30, 2013 at 3:49 am
Run DBCC CHECKDB WITH ALL_ERRORMSGS ; and post result here
January 30, 2013 at 3:43 am
Radu Costescu (1/29/2013)
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...
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...
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...
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...
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...
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...
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...
January 28, 2013 at 4:03 am
Viewing 15 posts - 361 through 375 (of 2,463 total)