Viewing 15 posts - 106 through 120 (of 2,462 total)
Some space you need to reclaim from the drive where mSDB resides ( and i suspect that all sys databases will on same drive) try to gain space...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 8:48 am
aeri_q (10/17/2013)
But when i wrote stored procedure using the same query it inserted the first row in my table....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 6:33 am
born2achieve (10/17/2013)
but i am unable to remove the file groups.it keep on says "it's being used"
YOu cant do that if the data (table/index ) sitting on that...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 6:17 am
and do you have tlog back scheduled ? because if transaction log has not been backed up recently, backup might be what is preventing log truncation
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:26 am
Read about "Index fragmentation" OR you can more elaborative about this question here to get some specific
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:23 am
What is the recovery model ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:15 am
Good question
and thanks SqlNaive for sharing the info about how to check value in XML plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:13 am
aeri_q (10/17/2013)
How can i get able to read all the rows and insert them in table , with the help...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:04 am
aeri_q (10/17/2013)
Now i want a stored procedure which could read each row and insert it into a table .
Any specific reason ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:03 am
bugg (10/17/2013)
What are your thoughts on the new column approach?
One thing i can say here is .. it will be protective approach.
create a new column with new dimension...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 5:01 am
ananda.murugesan (10/17/2013)
It is production server.. all the partition in RAID 5There is no meaning data file and log file placed on different dirve if server HW have single array controller..
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 4:36 am
navakanth_yenreddy (10/16/2013)
I need small clarification on your query. These transactions are hitting from the application to database ?
I have my requirement as below, could you please check it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 4:04 am
Here i dont think you need to use any parapmeter with Stored Proc.
see below code
create proc p
as
select 1 union select 2
declare @t table (id int )
insert...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 3:58 am
ananda.murugesan (10/16/2013)
Yes, Instance have multiple database available and also all database data and log file located same "D" drive.Tempdb location another drive in C drive..
This could be reason.
ALTEAST...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 3:19 am
L' Eomot Inversé (10/16/2013)
Bhuvnesh (10/16/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 3:08 am
Viewing 15 posts - 106 through 120 (of 2,462 total)