Viewing 15 posts - 61 through 75 (of 137 total)
Lowell (5/17/2013)
usually it gets rebuilt on connecting to a server, but in...
May 19, 2013 at 9:10 pm
Sony Francis @EY (5/17/2013)
90 also having no compitablility issue
Then why Intellisense is not enabled only on ONE DB.:w00t:
May 17, 2013 at 6:50 am
Lowell (5/16/2013)
i remember that SSMS disables Intellisense for SQL2005 (even though it's possible to enable it);
maybe that functionality is based on checking...
May 16, 2013 at 10:12 pm
Hi,
Anybody having a idea about whats going on here.Need Help on this.
May 10, 2013 at 5:24 am
Thanks for the reply. Really appreciated the time you had put in to reply the question.
April 18, 2013 at 8:46 pm
Scott Thornton-407727 (11/9/2011)
wow, that worked.I had no idea you could use Alias's in the UPDATE clause.
Thanks!
Hi experts,
This solution is working for me as a butter on a hot pan. But...
April 7, 2013 at 11:58 pm
Lynn Pettis (11/9/2011)
UPDATE TELEHEALTH SET
INVOICE_COST = CONSULT_MBS_COST.MBS_ITEM_FEE * 0.50,
ITEM_STATUS_CODE = CONSULT.ITEM_STATUS_CODE
FROM
...
April 1, 2013 at 5:24 am
Thanks Fellas for such brilliant answers. A lot of things to learn from all the answers ... 🙂
March 20, 2013 at 12:27 am
anthony.green (2/18/2013)
whats the output of this query in the DB in question?
select
*
from
sys.dm_db_index_physical_stats (DB_ID(),null,null,null,null)
where
page_count > 1000
and
index_type_desc <> 'heap'
The output of the above query shows...
February 19, 2013 at 4:04 am
GilaMonster (2/6/2013)
February 6, 2013 at 2:07 am
Antony,
Is there any easy way to traverse throught all the database. Because i am finding the above query a little bit of difficcult to understand.
January 24, 2013 at 3:33 am
Thanks antony. Looping through database is what i was looking for . Once again thanks.
January 24, 2013 at 3:24 am
Thanks for the reply, on the same note i remember one more thing, how to find out % out of a string.
Consider i have a name as 'antho%ny' or mis%ter...
January 17, 2013 at 6:27 am
anthony.green (1/16/2013)
Do you get anything from the below query
SELECT * FROM...
January 16, 2013 at 2:07 am
Viewing 15 posts - 61 through 75 (of 137 total)