Viewing 15 posts - 331 through 345 (of 2,462 total)
nick.mcdermaid (2/6/2013)
Those are very general benefits but it sounds like you've convinced yourself anyway.
Honestly speaking database design is under physical design phase so cant tell whether my approach is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 4:05 am
Shadab Shah (2/6/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 3:27 am
nick.mcdermaid (2/6/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 3:20 am
Copy the data for those records
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 12:58 am
Many Joins means "poor database design" & Poor Joins means "poor indexing" 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 12:57 am
nick.mcdermaid (2/5/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 6, 2013 at 12:24 am
i just came to know about one problem while reading an steve jone's article http://www.sqlservercentral.com/blogs/steve_jones/2010/02/14/saving-space-_1320_-vertical-partitioning/
lets say we have one table
create table Customers( CustomerID int identity(1,1), Firstname varchar(50), Lastname...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 5, 2013 at 10:48 pm
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 4, 2013 at 4:20 am
getsimrangujral (2/3/2013)
how many DBA currently accessing same database ? how to check
You specifically cant check who is(DBA or have sysadmin rights)accessing database, instead you can find the persons/tasks accessing...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 4, 2013 at 4:18 am
AccDba (2/3/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 3, 2013 at 11:43 pm
wnarretto (2/2/2013)
i am trying to copy tables form server A to server B using a link server. is there a configuration in the link server that will allow...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 3, 2013 at 11:38 pm
opc.three (2/1/2013)
Is it true that claim to claim_summary will be a 1 to 1, i.e. you're just offloading some columns from claim into this new table claim_summary?
Yes there...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 3, 2013 at 10:42 pm
Divine Flame (1/31/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 4:09 am
i still have one confusion,
Why i was getting "blocking by internal processes" for all above mentioned commands , is it normal (though i havent experienced in past) behaviuor ?...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 4:08 am
increased size could be due to large/unmanaged log too
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 1, 2013 at 3:17 am
Viewing 15 posts - 331 through 345 (of 2,462 total)