No announcements
Forums [ view all ]
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointPower PivotSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsSuggestions and Feedback for the ForumsWhere is the Forum For…?Forums Issues (not product support)Off-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server Development
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Unanswered0VotesFirst major ETL project - Potential pitfalls?
I apologize if this is posted in the wrong place. I have been tasked with, pretty much, a hybrid ETL and data modeling project. I have put a lot of thought and work into ...6 Replies | 221 Views | Created by eldroch - Thursday, October 17, 2013 10:35 PM | Last reply by Răzvan-Alexandru Duță - 6 hours 47 minutes ago
-
Unanswered0Votes
exporting data out of sql server
I have reading rights on a sql server where I need to run a sql script to copy data to excel spread sheet. The problem I am having is that most of the columns in the returned data set results have ...2 Replies | 127 Views | Created by al.sallam - Saturday, October 26, 2013 9:41 PM | Last reply by al.sallam - 21 hours 47 minutes ago -
Proposed0Votes
Alternative Reporting Tools
Hi, are there any alternative Reporting Tools as PowerView or PPS? At this time we uses this both tools but we are looking for some other ...2 Replies | 82 Views | Created by Marco Hanisch - Friday, October 25, 2013 8:56 AM | Last reply by Visakh16 - Sunday, October 27, 2013 6:51 AM -
Unanswered0Votes
CDC for Oracle Continually goes to Aborted State - SQL Server 2012
I am setting up a test environment for CDC with an Oracle system. I have everything set up to the point where logs are being read and data appears to be getting added to the CDC tables in SQL ...2 Replies | 100 Views | Created by Jason Dempster - Thursday, October 24, 2013 2:28 PM | Last reply by Jason Dempster - Friday, October 25, 2013 1:57 PM -
Proposed1Votes
T-SQL code
=DateBeginning and DateBeginning would be the start of the previous month AND Service_Date2 Replies | 116 Views | Created by Jigsy50 - Tuesday, October 22, 2013 5:47 PM | Last reply by Tom Phillips - Tuesday, October 22, 2013 9:22 PM -
Answered1Votes
Copy a table in SQL
Hello, Is there a way to copy a table in SQL Server 2008 R2 Management Studio? Brian ...4 Replies | 124 Views | Created by Jigsy50 - Tuesday, October 22, 2013 2:56 PM | Last reply by Jason Brugger - Tuesday, October 22, 2013 3:55 PM -
Answered0Votes
can we schedule rebuild or reorganize indexes using any sheduler
After How many days or uses we should rebuild or reorganize indexes? can we schedule rebuild or reorganize indexes using any sheduler ??? Is it good practice.3 Replies | 124 Views | Created by Ravi kumar shekhar - Tuesday, October 22, 2013 5:01 AM | Last reply by Shanky_621 - Tuesday, October 22, 2013 6:58 AM -
Unanswered0Votes
details on partition switch with aligned indexes
This is a "what's happening under the covers" type of question. I have a table with a clustered index and two non clustered indexes, all partition aligned. When I perform a ...2 Replies | 170 Views | Created by jjm21 - Friday, October 11, 2013 8:29 PM | Last reply by Mike Yin - Friday, October 18, 2013 8:47 AM -
Unanswered0Votes
HR Employee vacation calculation
Hi I am developing HR data warehouse where one of the requirments is to calculate the number of days an employee is on vacation/leave for each month. From the ... -
Unanswered0Votes
Dynamic Parition of a table with date wise
Hi , I need to create an dynamic partition(date wise) to an existing table when new record comes it should create a new partition ,if same date data comes data ...1 Replies | 218 Views | Created by Baddula - Monday, September 30, 2013 8:40 AM | Last reply by altuko - Thursday, October 17, 2013 7:42 PM -
Unanswered0Votes
Query to find Locking SPIDs on table.
I am using SQL server 2008 r2. Is there any query or script which will find locking SPIDs for the table. Thanks in ...3 Replies | 155 Views | Created by Manorath - Thursday, October 17, 2013 1:07 PM | Last reply by Harsh Kumar - Thursday, October 17, 2013 1:23 PM -
Unanswered0Votes
Technical template for a dwh assessment
Hi, in order to matching my doc with any existing technical template for a dwh assessment, I'd like to know about the existence for a such type of ...5 Replies | 177 Views | Created by pscorca - Tuesday, October 15, 2013 5:37 PM | Last reply by Răzvan-Alexandru Duță - Wednesday, October 16, 2013 8:28 AM -
Answered1Votes
Getting "Lock request time out exceeded" error while dropping table.
Hi all, I am using SQL server 2008 r2. We are using windows7 for server system. I am getting this error when we are importing data from ERP system ...9 Replies | 200 Views | Created by Manorath - Monday, October 14, 2013 10:33 AM | Last reply by Manorath - Tuesday, October 15, 2013 12:43 PM -
Answered0Votes
Best practice for keeping historical data in SQL (for SSAS Cube use)
I am working on an Hotel DB, and the booking table changes a lot since people book and cancel reservation all the time. Trying to find out the best way to convert the booking table to a fact ...4 Replies | 181 Views | Created by Mike-007 - Monday, October 14, 2013 12:52 PM | Last reply by Răzvan-Alexandru Duță - Tuesday, October 15, 2013 8:08 AM -
Unanswered0Votes
__$seqval value repeat
Hi, useraccts table is a cdc table. This table has PK column which is an int identity (1,1). select * from [cdc].[dbo_useraccts_CT] r with ... -
Unanswered0Votes
How can we improve query performance with out indexes?
Hello Experts, I have a problem with table(calc) which contain 3 crore records and table doesn't have index, on that table one of the view(View_A) ...0 Replies | 145 Views | Created by Improving performance of Table - Wednesday, October 09, 2013 3:04 PM -
Answered0Votes
New data warehouse - schema generated from wizard results in columns marked allow null
So I have my first data warehouse started, and generated the schema into my DB with the wizard. I noticed alll of the tables, including the main fact table has their columns allowing ...1 Replies | 322 Views | Created by shiftbit - Friday, October 04, 2013 3:30 PM | Last reply by Răzvan-Alexandru Duță - Tuesday, October 08, 2013 7:19 PM -
Unanswered0Votes
Need to write a query to use column values as a column name.
Required dynamic query for each client. I have two CSV files - one is look up and another is fact. I want to extract the respective column alias from look up file and want to use ...1 Replies | 263 Views | Created by Ricky08 - Saturday, October 05, 2013 8:11 PM | Last reply by stephen huo - Tuesday, October 08, 2013 8:57 AM -
Unanswered0Votes
I dont understand the performance issue of my new server
Hi, Not the first time I'm asking the forum about performance issues. but...we have just received a new SQL Server for our DW project. 256GB of RAM, 2 CPU 8 cores ...4 Replies | 292 Views | Created by Willgart1 - Thursday, October 03, 2013 12:02 PM | Last reply by Willgart1 - Monday, October 07, 2013 11:30 AM -
Answered0Votes
What is a Business Key in Data Warehousing?
Hi, Could someone please explain me what exactly is a Business Key in the DW world? A few references I've gone through online are quite confusing. Please explain me the importance ...3 Replies | 270 Views | Created by Bangaaram - Thursday, October 03, 2013 2:25 PM | Last reply by stephen huo - Friday, October 04, 2013 9:27 AM - Items 1 to 20 of 1216 Next ›
.png)
