Viewing 15 posts - 736 through 750 (of 2,462 total)
Aadhar Joshi (12/5/2012)
But i am looking for solution which can operate through trigger..:(
trigger ? you want to work on row level ? i dont think its a good idea...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 2:02 am
Kenneth.Fisher (12/4/2012)
if you are going to accept remote connections?
can you please explian this ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 1:07 am
sqlnes (12/4/2012)
I tried to modify the size of autogrowth for one of the data files in my database. However, it took a long time and could not be done. After...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 1:06 am
cooljagadeesh (12/4/2012)
according to my viewboth are functionality wise same
can you explain it ?
And for reading http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 1:06 am
Aadhar Joshi (12/4/2012)
We need to find the solution which executes only when value get change.
it this case too , you need to trigger job, job itself doesnt put any...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 5, 2012 at 1:02 am
Bhuvnesh (12/4/2012)
hemant.raibole (12/4/2012)
this connectivity issue due to network failure
this cant be the case as OP posted above that he is abble to connect with other databases.
This might be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 4, 2012 at 2:45 am
I am completely aware of the approach you people take during the release night. see there is no any specifc procdure to deply these kind if scripts. totally based on...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 4, 2012 at 2:41 am
hemant.raibole (12/4/2012)
this connectivity issue due to network failure
this cant be the case as OP posted above that he is abble to connect with other databases.
This might be bacause...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 4, 2012 at 2:24 am
Minnu (12/4/2012)
am using below query for searching in table 1, how to include table 2 for searching.
you need to make JOIN with second table with first one.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 4, 2012 at 2:19 am
naga.rohitkumar (12/3/2012)
it is a having indexes properly in both the tables
NO use of here as both the tables are going for table scan plus parallelism too for puling out...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2012 at 3:58 am
Mithra (11/30/2012)
I can see the max memory allocated is 50MB for my instance.
are you sure for this no ? and task manager can give you estimated value for sqlserver.exe
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2012 at 3:28 am
Jayanth_Kurup (12/3/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2012 at 1:30 am
MyDoggieJessie (11/29/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 2, 2012 at 11:51 pm
1. take create temp table approach instead of select into approach coz it also lock the main base table and i dnt think here you require to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 30, 2012 at 9:08 am
data will need space its his nature plus our requirement too , you need to see the growth percentage and based on that you need space additionally soon you will...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 29, 2012 at 8:04 am
Viewing 15 posts - 736 through 750 (of 2,462 total)