Honestly speaking database design is under physical design phase so cant tell whether my approach is...

Shadab Shah (2/6/2013)

---

Hi Gila i am just a newbie and wanted to know wheather i am correct or not : Leaf/non-leaf of a index is nothing but a Page storage?...

nick.mcdermaid (2/6/2013)

---

Why do want to divide the load? Do you have a performance or design issue requiring this? For population of summary table you could also use views, triggers and/or...

Copy the data for those records

Many Joins means "poor database design" & Poor Joins means "poor indexing" 😀

nick.mcdermaid (2/5/2013)

---

But seriously you are not going to require vertical partitioning for a table with thousands of records. In fact it's quite an extreme design measure to take, it adds...

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...

removed

You specifically cant check who is(DBA or have sysadmin rights)accessing database, instead you can find the persons/tasks accessing...

AccDba (2/3/2013)

---

I will create a new database and put these 45 tables keep actual transactional database small and slim. So its like having a copy of the same tables but...

wnarretto (2/2/2013)

---

hello SQL world-

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...

Yes there...

Divine Flame (1/31/2013)

---

Did you see the command run by internal process (DBCC INPUTBUFFER) ? Or in case DBCC INPUTBUFFER was not providing any result atleast the Command column's value in...

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 ?...

increased size could be due to large/unmanaged log too