Viewing 15 posts - 481 through 495 (of 2,008 total)
I can’t help much if you don’t provide the details. If you want to learn it, I can suggest you few articles (on BOL).
Fill Factor
http://msdn.microsoft.com/en-us/library/ms177459.aspx
fill factor Option
http://msdn.microsoft.com/en-us/library/ms191005.aspx
Reorganizing and Rebuilding Indexes
December 31, 2011 at 2:32 am
How big is the table? What’s the use of table (transaction / master)?
December 31, 2011 at 1:52 am
SQLRNNR (12/30/2011)
Roy Ernest (12/30/2011)
Before I forget, Let me wish you all a very happy and prosperous New Year, 2012.
What if we decide to visit your casino - do you still...
December 31, 2011 at 1:41 am
CELKO (12/30/2011)
The purpose of SQL is to store , retrieve and maintain the integrity of data. It...
December 31, 2011 at 1:35 am
BSavoie (12/31/2011)
December 31, 2011 at 1:30 am
If somebody has already truncated the table and auditing is not in place then it’s difficult to track the user. If it’s just a thought & you want to safeguard...
December 31, 2011 at 1:23 am
Per BOL:
As modifications are made to the data in the base tables, the data modifications are reflected in the data stored in the indexed view.
For More: http://msdn.microsoft.com/en-us/library/ms187864.aspx
December 31, 2011 at 1:18 am
BSavoie (12/31/2011)
December 31, 2011 at 1:12 am
kavyap.kp (12/30/2011)
ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,
Start with Normalization Principles...
December 31, 2011 at 1:09 am
No easy way. Confirm the IP with your team & document it at a safe place.
December 31, 2011 at 1:02 am
BSavoie (12/30/2011)
That was definitely my first thought, but it doesn't really enforce the "two members per team" rule; whereas the other way around enforces it quite explicitly.
Maybe I...
December 31, 2011 at 12:58 am
Welsh Corgi (12/30/2011)
Clecko,I read your post and it makes me want to go out and buy all of your books.
What a great way to start the New Year.:hehe:
ROFL :hehe:
December 31, 2011 at 12:52 am
It depends on various factors. For example network bandwidth, server utilization, RAM, the table structure itself and calling query. We can’t guess with the minimum information provided by you.
Performance Tuning...
December 31, 2011 at 12:36 am
Your table is badly designed. Day column should appear in rows it would make your query a lot easier.
SELECT COL_NAME
FROM YOUR_TABLE
WHERE DAY=’SUNDAY’
If you can’t change the table design, you should...
December 31, 2011 at 12:29 am
Viewing 15 posts - 481 through 495 (of 2,008 total)