Viewing 15 posts - 1,501 through 1,515 (of 2,462 total)
Proxy account
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 5:08 am
James Tech (8/1/2010)
Steve Jones - Editor (8/1/2010)
You can setup a linked server between them, or you can use the OPENQUERY command from one server to get data from the other.
Thanks...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 5:06 am
you can store case conditions in a table (so called metadata) and fetch the conditions from there.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 4:57 am
I think Sql optimizer will create new exec plan acccording to the new statistics( after statistics update).
next Sp/function run would be smoother. am i right ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 4:12 am
le_eli (7/30/2010)
2. "invalid column Name" usually means Invalid column name
Very Good catch:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 4:10 am
Check the database log
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 2, 2010 at 1:11 am
2005_DBA (7/30/2010)
This is an interview question.
Lets say some one come to you and say production server is responding slow. User complain about performance of production system. As a DBA...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 30, 2010 at 3:54 am
can you clarify the issues , so that people can go for precise and close solution
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 30, 2010 at 2:30 am
Jeff Moden (7/29/2010)
Bhuvnesh (7/28/2010)
Jeff Moden (7/28/2010)
you'd need a loop for that.or may be batch approach can make work smoother
The loop would control "batches". That being said, what do...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 30, 2010 at 1:47 am
sushantkumar1984 (7/29/2010)
Exactly where in india ?Jaipur..
What abt u
Regards,
Sushant
Delhi
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 30, 2010 at 12:42 am
Jeff Moden (7/28/2010)
you'd need a loop for that.
or may be batch approach can make work smoother
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 28, 2010 at 11:19 pm
sushantkumar1984 (7/28/2010)
India
Exactly where in india ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 28, 2010 at 10:54 pm
it should be developers or enterprise edition
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 28, 2010 at 7:04 am
Viewing 15 posts - 1,501 through 1,515 (of 2,462 total)