Viewing 15 posts - 61 through 75 (of 2,462 total)
Tej_7342 (11/5/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 4:22 am
Make habbit to include schema whenever playing with sql objects.it is good from "standard" as well as "safety" perspective
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 6, 2013 at 1:03 am
you can do SQL 2000 SP4 to 2008 R2 by SQl Server Upgrade Advisor:
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2013 at 6:45 am
Nobody can help you here ..we dont know your data and table definition.
PLease post table defintion along with (sample) data to get the result.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2013 at 2:55 am
USe below query to troubleshoot the resource crunch
--== Blocking queries in database ==--
SELECT DES.Session_ID AS [Root Blocking Session ID], DER.STATUS AS [Blocking Session Request Status],
DES.Login_Time AS [Blocking Session Login...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2013 at 2:53 am
are you creatogn dynamically sql script through app ?
which could be missing schema name in generated script
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2013 at 2:47 am
LOVER OF SQL (11/2/2013)
the problem is because my disk have a 20gb free, and tlog is bigger then 20gb...
is it a dedicated log disk ?
Use another bigger disk...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 5, 2013 at 2:31 am
You havent mentioned in any of ur post that you are managing the logs ? for full recovery .. regular Tlog will be required .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 1, 2013 at 4:25 am
you havent answered my question ? as it might help us to frame resolution for ur issue.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 1, 2013 at 4:01 am
winston Smith (10/31/2013)
I came across a database today that was doing a lot of inserting onto a table. It was taking an exceptionally long time.
How much data you are...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 1, 2013 at 2:27 am
New persopn (10/31/2013)
How can i monitor the complete log usage in that particular time.
As steve mentioned above.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 1, 2013 at 1:46 am
tony28 (10/30/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 31, 2013 at 4:40 am
try this
insert into #tblmain
exec usp_Main_TEST @CustID = '123'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 5:00 am
Koen Verbeeck (10/25/2013)
A clustered index does not sort the rows physically in the pages, but logically.Does a Clustered Index really physically store the rows in key order?[/url].
I also read...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 28, 2013 at 4:50 am
Viewing 15 posts - 61 through 75 (of 2,462 total)