Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum

Tip: Looking for answers? Try searching our database.

General

Recently updated threads


Thread preview

Data Warehousing (view all ...)Last Post  Replies
EDW Design question26 Aug 2008 06:41 GMT-
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.
OLAP disk configuration for best throughput19 Aug 2008 13:26 GMT1
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.
SSAS, linked server, unwanted distributed transaction14 Aug 2008 11:13 GMT-
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
Application architecture redesign to utilize SSAS13 Aug 2008 12:43 GMT-
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
IT Job Guru12 Aug 2008 20:21 GMT-
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

Performance (view all ...)Last Post  Replies
100% CPU when selecting Restore only on a few databases26 Aug 2008 19:38 GMT3
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 ...
Looking for beta tester win free pass for life www.sex-version.com23 Aug 2008 15:22 GMT-
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 ...
Free Advertising12 Aug 2008 03:40 GMT-
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
Anuncios Gratis www.AnunciosGratis.de01 Aug 2008 11:42 GMT-
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
ACREDITE FUNCIONA!!!!!27 Jul 2008 17:22 GMT-
Ganhar dinheiro rápido e honesto
meu blog http://jet72.zip.net/
: QUER GANHAR UM BOM DINHEIRO? FAÇA COMO NÓS !
: COMO TRANSFORMAR 12 REAIS EM NO MINIMO DOZE MIL REAIS !!

Security (view all ...)Last Post  Replies
How to verify whether a user has been added to a database role?29 Aug 2008 02:02 GMT8
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.
Linked Server - name not getting passed over?28 Aug 2008 23:31 GMT10
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
restore backup : access denied28 Aug 2008 19:45 GMT1
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 ,
Website & SQL Server Security28 Aug 2008 17:59 GMT1
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.
Understanding SQL and Microsoft GP28 Aug 2008 17:01 GMT3
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 ...

Setup (view all ...)Last Post  Replies
How to disable password policy with install command option of SQL29 Aug 2008 01:20 GMT1
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 ...
Shrinking the database28 Aug 2008 22:20 GMT1
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 ...
"Access is denied" error when installing SQL Server 2008 on XP28 Aug 2008 21:19 GMT5
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
SQL Server 2008 Enterprise and Standard installation failed28 Aug 2008 20:51 GMT4
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 ...
.NET Developer, Senior Level, State of Wa - Office of Financial Mgmt28 Aug 2008 20:45 GMT-
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,

SQL Server Tools (view all ...)Last Post  Replies
intellisense not updating29 Aug 2008 03:51 GMT11
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 ...
Database Engine Tuning Advisor suggestion to replace syntax.29 Aug 2008 01:56 GMT4
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?
SSMS 2008: Ctrl-Shift-M29 Aug 2008 00:25 GMT-
Ctrl-Shift-M does not appear to work in this version (for templates), is this
a bug?
Thanks
Can I create a Scipt with only create index command?28 Aug 2008 08:11 GMT2
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 ...
Sql Sever 2005 Vendor tools27 Aug 2008 20:11 GMT4
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

Other SQL Server Topics (view all ...)Last Post  Replies
Calculated fields...29 Aug 2008 03:17 GMT-
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 ...
ODBC DSN connection fails from MS Access 2000 after SQL2005 mirror     failover29 Aug 2008 00:22 GMT-
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
SYSTEM_USER automatic RTRIM of trailing spaces in 2000, but not 2005?28 Aug 2008 22:58 GMT5
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.
Optimizing Application Purformance28 Aug 2008 22:22 GMT9
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 ...
newbie: error backing up DB28 Aug 2008 19:54 GMT1
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.