What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?

Hi Friends,
Any recommendation for DW and BI books ?
Thanks,
Pat

Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (last call): 3 September
2010 --

Is it okay to create a data warehouse on a separate instance of sql server
2005, or is a separate machine required?
We have two Dell PowerEdge 2950 servers with 1.2 terabytes of EMC SAN
database storage, set up in a two-noce active/passive config, running on

has anyone out there written SQLServer 2005 code to populate a Kimball
Recursive Helper table as per  
http://www.bimonkey.com/2009/09/handling-recursive-hierarchies-in-sql-server ?
These is an implementation using Oracle  via

Below is a block process report. I am having trouble identifying which event
was being blocked and which event was doing the blocking. Do you see anything
that indicates that any object is being blocked by another? I have to places
where I have commented with *****1. and *****2 ...

I have a table tbltest with 10 fields and say field A is in a clustered index
and field B is in a nonclustered index ix-B.  I have a query as follows:
Select C, D, E, F, G, H , I, J from tbltest where B ='something'
With the existing indexes, execution plan will do a index seek ...

We are using SQL 2008 64 bit sp 1 std on Windows 2008 std 64 bit for a new
reporting server.  We are planning to buy a dell server with two CPU's.   Is
it true that we should buy as many cores as our budget allows?   So if there
is a 12 core server out there, we should get it.     ...

We are using SQL 2008 std 64 bit on Windows 2008 64 bit std.  We are
configuring a new server for reporting purpose.  The reporting is based a
subscriber database.  There are two configuratons we are considering.  One
has 24 Gbytes of Ram and the speed of the ram is 1332.  The other ...

Hello, I have a bottleneck in a stored procedure.  In the QA environment, I
ran profiler and the stored procedure took over an hour and came back with
1.6 billion reads and row count 39.  I copied the same databases to a
different server and ran the same sproc, this time it ran ...

I'm using SQL Server 2008 and with sa, this works fine
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel
12.0;Database=q:\teste.xlsx', [zz$])
Succeeds for sa, but not a domain user.  I've started morphing the

I stumbled across some behavior in SQL2005 that I consider odd and
surprising, and I'm looking for help understanding more about it.
According to BOL, when you run "CREATE USER user_name LOGIN
login_name", the login_name must be a valid login in the server.  I

We have a SQL 2000 database setup a while ago when we were a much smaller
company.  The security on the tables in the database was done at the table
level so if you were in the group sqlSales you would get read/write access
to the Sales tables, and so on.

is there a way to protect my data base i mean no one can open the tables or
change them ??
pls any idea ??
best  regards

Which is better in use.  Setting up Active Directory groups and using it to
guide your security in the sense that you create a read and a read/write
group and just move users in and out of these security groups and manage
security for SQL Server from Active Directory.  Or use SQL ...

When trying to install SQL2008 R2 Developer Edition x64 on Windows 7 x64, I
am getting an Error:
2010-06-12 22:05:40 Slp:
------------------------------------------------------------

I have been finding that I'm having trouble with the Crystal Reports Server
XI installation failing when it's dealing with SQL.
So, as a thought and in case there was something wrong with my SQL portion of
the isntall. I thought ok, I'll try installing the actual MSDE application

Hello, ran into a weird one...
Recently I attempted to install SQL 2008 x64 Enterprise on a Windows 2008 R2
server via RDP - this is a VM so the only option is to RDP to it (I am using
the /admin switch to connect) - using my domain ID, which is a domain admin

The above problem is well known:
http://support.microsoft.com/kb/968749/en-us
However the workaround http://support.microsoft.com/kb/290301 no longer
applies.

Is it possible to create a SqlServer database at a network drive?
Thanks,
Ben

SQL Maestro Group announces the release of MS SQL PHP Generator 10.8, a GUI
frontend that allows you to generate high-quality PHP scripts for the
selected SQL Server tables, views and queries for the further working with
these objects through the web.

I have a problem scaling the y axis. I have a value axis and secondary axis
and trying to compare two data. Now the thing I want the same scale for both
the axis.
Right now since its auto it cannot compare.

When in SQL Server Management Studio, I can open Log file viewer to see
the SQL Server Errorlog, SQL Agent Log, etc.  This applies to the 2005,
2008 or 2008 R2 versions.
I know there is the Filter option so that I can limit the entries I see

Do you know what the hot trend of today is? I will tell you that one
of the hot trends in footwear today is fitness walking shoes. Not only
are sports shoes, shoes, but the gym floor. These strange shoes are
popping up everywhere. The shoes that started the trend called MBT

I'm fairly new to SQL Server, but using version 2005 and I have SQL
Server Management Studio.  When I run a query, I can right click to
display an execution plan.  However, for certain queries, this graphic
becomes unruly (really, really big).  Is there a way I can have a more

ETL/SQL expert with knowledge of Clarity tool
Location Phoenix
Duration: 3 Months +
More details on Skill set Person should have knowledge of the SQL and

I am a novice at SQL and cannot figure out an effective way to export
a product file that only has products over 25% margin.
SELECT
p.ProductCode AS 'Mfr Part Number'

Job Title                           Sr. Cognos TM1 Developer
Experience Level             6 – 9 + Yrs of IT
Location                           East Hanover, NJ
Start Date                         Immediate

Location: Newark, NJ
Length of Engagement: 9 months (With the option for the client to
extend to a maximum of 18 months)
Targeted Bill Rate:  DOE

Title:                      Oracle DBA
Duration:             3+months
Experience:        Around 4 years
Need Oracle DBAs with RAC and Dataguard Experience.