Viewing 15 posts - 1,906 through 1,920 (of 3,061 total)
abhisek_boy_in (5/28/2010)
May 28, 2010 at 2:04 pm
david.ostrander (5/27/2010)
I have been reading so much on data warehousing that I feel like I should know this but here I go. How does it get installed?
"Data Warehouse" is a...
May 28, 2010 at 1:56 pm
lrodriguessp (5/28/2010)
Create primary key in partitioned table is possible in SQL Server 2008?My table is partitioned by date and I need to create primary key field CodID Int
As far...
May 28, 2010 at 1:49 pm
Interesting... I was under the impression - please correct me if I'm wrong - shared components were:
Client tools
BOL
BI dev studio &
Integration services
May 28, 2010 at 8:51 am
I understand 1 lakh = 100,000 rows?
If yes... that's a small table, no partitioning is needed - as a rule of thumbs I do not even consider partitioning for tables...
May 27, 2010 at 7:36 am
Assuming table names are table1 and table2...
select isnull(a.id,b.id),
isnull(a.salary,0),
isnull(b.salaryabroad,0)
from ...
May 26, 2010 at 3:19 pm
Bradley B (5/26/2010)We are looking at a db that will be over 2 TB, so if that is the case the TempDB will be sized at over 400 GB.
My personal...
May 26, 2010 at 2:52 pm
As far as I remember maintenance plan relies on XP_DELETE_FILE to delete old files - XP_DELETE_FILE is not supposed to leave any paper trail.
I assume some windows scripting may let...
May 26, 2010 at 12:36 pm
Is this table part of an OLTP or a DSS system?
How large is the table today? number of rows, please.
How large will be the table one year from now? number...
May 26, 2010 at 12:00 pm
Barry G Freeman (5/25/2010)
Notice the per-second droputs and lousy transfer rate - this is supposed to be a 1Gb link
Did the ISP promised a private 1GB link or did they...
May 26, 2010 at 11:41 am
Barry G Freeman (5/25/2010)Time too look for another ISP I think.
I would start by taking a look at the contract...
-- Are there any SLAs?
-- Is ISP meeting SLAs?
--...
May 25, 2010 at 9:28 am
PHXHoward (5/23/2010)
Seperate development and production domains.
Any particular reason not to allow read-only access on production to a development side "refresh" account?
Development environment usually holds a volume-scaled-down subset of production data,...
May 25, 2010 at 8:46 am
Did you check app event log and/or sxstrace.exe?
Take a look at this... http://wss.crandalls.net/blog/default.aspx
May 25, 2010 at 8:39 am
rajiv.varma (5/24/2010)
I have the query ready with me. But the problem is its taking too long in the absence of an index. I cant create one since its production server.
In...
May 25, 2010 at 8:10 am
tosscrosby (5/25/2010)Newbie-ism is no excuse for lack of courtesy shown to the unpaid staff here answering your request for help.
Agreed. The new generation has no manners - appalling.
May 25, 2010 at 7:40 am
Viewing 15 posts - 1,906 through 1,920 (of 3,061 total)