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
Reminder - Microsoft Responds to the Evolution of Community31 Aug 2010 19:27 GMT-
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?
Book recommendation for DW and BI24 Aug 2010 00:34 GMT-
Hi Friends,
Any recommendation for DW and BI books ?
Thanks,
Pat
Last CFP - Applied Computing 2010: 3 September 201005 Aug 2010 13:39 GMT-
Apologies for cross-postings. Please send to interested colleagues and
students
-- CALL FOR PAPERS - Deadline for submissions (last call): 3 September
2010 --
SQL Server 2005:  Data Warehouse Location16 Jun 2010 17:16 GMT2
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
Recursive Helper Code30 Apr 2010 16:52 GMT2
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

Performance (view all ...)Last Post  Replies
block process report - which object is causing block? see xml code16 Aug 2010 22:48 GMT-
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 ...
index seek with lookup vs index seek with include27 May 2010 08:15 GMT1
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 ...
SQL 2008 with more cpu core26 May 2010 22:57 GMT1
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.     ...
Ram size vs speed18 May 2010 22:29 GMT5
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 ...
Logical Reads30 Apr 2010 17:03 GMT7
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 ...

Security (view all ...)Last Post  Replies
permissions for OPENROWSET02 Sep 2010 22:37 GMT3
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
Users without logins02 Sep 2010 22:31 GMT4
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
Report on table level permissions30 Aug 2010 19:30 GMT1
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.
protect my data base30 Aug 2010 17:42 GMT1
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
Active Directory Groups vs. using SQL Server Groups.30 Aug 2010 16:44 GMT2
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 ...

Setup (view all ...)Last Post  Replies
SQL 2008R2 Install Fails with: Action "PostMsiTimingConfigAction"02 Sep 2010 23:08 GMT5
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:
------------------------------------------------------------
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services02 Sep 2010 22:58 GMT23
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
Installing SQl 2008 x64 ENT on OS - 2008 R202 Sep 2010 22:29 GMT1
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
MSXML 6 is newer --> SQL2005 fails to install02 Sep 2010 21:43 GMT4
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.
Create database at network drive?02 Sep 2010 17:49 GMT1
Is it possible to create a SqlServer database at a network drive?
Thanks,
Ben

SQL Server Tools (view all ...)Last Post  Replies
ANN: MS SQL PHP Generator 10.8 released26 Aug 2010 14:52 GMT-
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.
SSRS Graphs Scaling Issue20 Aug 2010 02:20 GMT-
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.
SSMS Log File Viewer - Filter option18 Aug 2010 10:01 GMT2
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
MBT shoes tell you what the hot trend of today is?09 Aug 2010 07:06 GMT-
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
Better way to display execution plan?07 Aug 2010 05:17 GMT4
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

Other SQL Server Topics (view all ...)Last Post  Replies
ETL/SQL expert with knowledge of Clarity tool (ID2025G) ---Phoenix02 Sep 2010 23:21 GMT-
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
An aggregate may not appear in the WHERE clause02 Sep 2010 22:26 GMT2
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'
Sr. Cognos TM1 Developer (ID2021) ><  East Hanover, NJ02 Sep 2010 18:51 GMT-
Job Title                           Sr. Cognos TM1 Developer
Experience Level             6 – 9 + Yrs of IT
Location                           East Hanover, NJ
Start Date                         Immediate
Project Manager02 Sep 2010 14:49 GMT-
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
Oracle DBAs with RAC and Dataguard Experience.---atlanta01 Sep 2010 19:51 GMT-
Title:                      Oracle DBA
Duration:             3+months
Experience:        Around 4 years
Need Oracle DBAs with RAC and Dataguard Experience.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage




©2010 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.