I have a design question . I got the requirement of 2 TB starting for
enterprise dataware house in my project. I want to implement next generation
warehousing technique. So want to have a near line storage layer in the
design.

Is there any difference for disk configuration for OLAP systems in
comparison to OLTP ,Please suggest the consideration for disk design and RAID
levels for OLAP systems to get best throughput.

While doing some experiments with SSAS, i got stuck with
transaction being promoted to DTS.
Scenario is as follows:
1. There is an SQLServer2005 database

I have an analytical application, which uses relational database
(actually very close in structure to typical star schema) as underlying
data store. I'd like to redesign its architecture to utilize SSAS.
I've built cube which provides analytical view on data, and I'd like

Are you looking for a Job in India??? You have experience in Java,
Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a
minute and log on to www.itjobguru.com/forum/index.php. It has all
the

We have a SQL Server 2000 instance with 37 databases. Two of the databases
cause infinite 100% CPU usage when selecting (right-click on the db in
Enterprise Manager)[All Tasks][Restore Database]. No dialog appears and the
CPU pegs out at 100%. Three other databases peg the CPU at ...

http://www.sex-version.com
Biggest On demand adult video publishing 70000+ vids and sharing porn website, strongly interfaced with porn video
WARNING: This website contains explicit adult material.
You may only enter this Website if you are at least 18 years of age, or at least the ...

In an effort to increase traffic to our new news group we now offering FREE
UNMODERATED chat and advertising
just go to
free.uk.retail.poundland.staff.chat

Vendo coche seat ibiza, 1999 . en buen estado, color plata, Precio ,4900 euros. Precio 4566 Euros.
Tfno: 91452123334
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de  Anuncios Gratis

Ganhar dinheiro rápido e honesto
meu blog http://jet72.zip.net/

I want to validate whether a user has been added to a particular database
role.  I cannot use the is_member function since it only works with the
current user.

I am trying to connect from ServerA to ServerB using linked server.
Below is the setup script, but it's the basic linked server (RPC is
on, Data Access is on, use login's permissions).
Doing "test connection" works, and if I open catalogs I see all the

box # 1 : SQL Server 2005 Developer Edition , mixed-mode , logged-in as
Windows log-in account ( BUILTIN\Administrators ) :
create a .bak file
box # 2 : SQL Server 2005 Express Edition , Windows authentication mode ,

Ok,
im sure this has been dealt with before but when i read other posts i
kinda get lost in the jargon. Ok the reason for my being here is that
i developed a website that recently got hit by a sql injection attack.

I am trying to get and understanding of the security with SQL and GP.  
Unfortunately, I know alot about GP but virtually nothing of SQL.  Our IT
person handles the SQL side.  The confusion I am running into with with some
of these new tools with GP10 there are rights you have to ...

I install SQL2005 Express with commandline options in our package, but the
installed SQL server always has 'Enforce password policy' and 'Enforce
password expiration' on (box checked) when viewd with 2005 Manager. How can I
specify option(s) in installation command so that both ...

We a have a data under SQL 2005 which has a large log file that's 90% empty.
I'm trying to shrink it by right-clicking the database and selecting Shrink,
as I do with other databases.  However, this specific database doesn't
shrink without any error messages.  The only difference ...

No matter how I log into my work station and with every security
configuration that I've tried, I always get the same error when attempting to
install SQL Server 2008 on XP SP3.  It happens at:
SqlEngineDBStartConfigAction_install.configss_cpu32

I downloaded from msdn subscriber downloads the iso images for SQL Server
2008 both enterprise and standard editions and made to dvd's by isobuster.
I was amazed, that when I try to install the products - either on a standard
or virtual PC - the setup.exe file does not exist on ...

Are you a senior level developer looking for a long term, nine month
engagement with probable extensions?  Are you interested in working
with the some of the latest .NET technologies?   Do you have a
background that includes working on solutions that develop, manage,

I'm using SQL Server 2008 and I'm writing Queries in SMSS.  I find that if I
add a new object (e.g. a new Table) to the database, the intellisense does
not recognize it (i.e. it puts a red underline underneath it) until I exit
SQL Server and restart it.  My queries run OK even ...

SQL Server 2005 Database Engine Tuning Advisor informs me that I should
replace query 1 below with the syntax in query 2 below. I’m just not seeing
the reason since both the “SELECT” statements optimization plans are stored
for reuse. Am I missing something?

Ctrl-Shift-M does not appear to work in this version (for templates), is this
a bug?
Thanks

I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using
the "Generate Script" wizard that only has Drop Index and Create Index
commands. I don’t want the create table command. The database has about 500
tables and it will take me hours to generate a FULL ...

Hi I need to purchase some Sql software to compress  and quickly backup data
files, proactively monitor a whole range of servers in real time and I need
auditing at the log level for ddl events and rollbacks in case of emergencies.
Idera SQL Diagnostic Manager  --for monitoring

If I have a calculated field that returns a value from a udf, does that
field get calculated even when it's not being used in a Select statement?  I
knw that if a calculated field's formula is based on fields in the same
record that the calculation is only performed when one of ...

I have an 3rd-party application that uses a SQL back-end, but uses
Access 2000 (linked tables all using the same DSN) as an
intermediary.  We recently upgraded from SQL 7 to SQL 2005, which went
fine.  Now, however, we want to setup SQL Mirroring to provide

Hey all, I've noticed an obscure little quirk: it appears that if you
use a login with trailing spaces on the name, SYSTEM_USER
automatically trims those trailing spaces in SQL Server 2000, but not
SQL Server 2005.

First post here and let me say up front that I am completely and utterly
ignorant about SQL servers.  I don't know what one is and I didn't even know
that I had one until I was browsing around in my Microsoft Office Accounting
08 Application.  So if you can be helpful then also ...

We use BES (blackberry professional software) on a MS SBS 2003 Premium
and we back-up the whole system with Symantec backup Exec 12.
BES uses an SQLdb for management.
Since the day we installed BES we have this backup error in Backup