No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Unanswered0Votes
Problem when listing Dictionary from ftp using ssis sql server 2008
0) { memStream.Write(respBuffer, 0, ... -
Unanswered0Votes
Merge Statment Not working as expected
I am probably not doing this correctly but i just can't find where the issue is. I am getting data from ActiveDirectory, Store in a stage Table and then i use Merge ...1 Replies | 82 Views | Created by ns100 - Friday, August 02, 2013 7:32 PM | Last reply by Leo N - 22 hours 17 minutes ago -
Proposed0Votes
Drop and Rebuild denormalized tables for updating data
Our SQL database was claimed to be OLAP database that includes billions of sales records. Records are inserted into the database once everyday. To improve performance of data retrieval, the sales ...6 Replies | 229 Views | Created by winipcfg - Wednesday, July 24, 2013 2:57 AM | Last reply by Matt Tolhurst - Monday, August 05, 2013 4:02 PM -
Unanswered0Votes
never ending query
Hi, I have a DW solution and a cube on top of it. when I do a full process 1 of the query never ends... its just a partition like there is a ...3 Replies | 119 Views | Created by Willgart1 - Friday, August 02, 2013 12:58 AM | Last reply by Christian HL - MSFT - Monday, August 05, 2013 4:02 AM -
Answered0Votes
type 2 scd help
hi there, i'm building a type 2 dimension table. From the source to the staging dimension table, i'm generating a hashbyte('md5',concat(col1,col2...)) as ...2 Replies | 123 Views | Created by Red8Rain - Saturday, August 03, 2013 12:31 AM | Last reply by Mike Yin - Monday, August 05, 2013 2:15 AM -
Answered0Votes
SQLServer Agent problem after database recovery
Had an issue with SQL Server locking up so we restarted the SQLServer service. When it came back up our primary database was in recovery mode. After about 25 minutes the database recovered ...2 Replies | 4351 Views | Created by Bendare2 - Thursday, November 17, 2011 3:48 PM | Last reply by tonycross25 - Saturday, August 03, 2013 1:13 PM -
Unanswered0Votes
MDX Query Help
Required OutPut : For all the months I need to get like below June 2013 201306 1172699 JULY ... -
Answered0Votes
SRS Parameter Question
Hi I have created a stored procedure in sql with a parameter called @pay_via. This can have numerous values, such as Visa, Amex, MasterCard etc. ...1 Replies | 102 Views | Created by katiemackie - Wednesday, July 31, 2013 4:07 PM | Last reply by SathyanarrayananS - Thursday, August 01, 2013 3:32 AM -
Unanswered0Votes
how many drives (LUN) I should create for a DW solution?
Hi, we'll receive a new server soon. we'll connect it to a SAN. I have to plan how many LUNs to create. Do I have to create ...1 Replies | 95 Views | Created by Willgart1 - Monday, July 29, 2013 5:31 PM | Last reply by Geert Vanhove DCOD - Tuesday, July 30, 2013 2:22 PM -
Unanswered0Votes
Insurance Policy Submission Cube
Hi, I would like to build a fact table that tracks homeowner's insurance policy submissions. This table would measure policies that were quoted and/or ... -
Answered0Votes
XCOPY command RETRY
Hi All, I have the below command in Stored proc to copy files from Server workdirectory to Netwrok path. But unfortunately it fails randomly for few files. For Eg: if the work ...3 Replies | 255 Views | Created by msb123 - Wednesday, July 17, 2013 7:50 PM | Last reply by Red8Rain - Tuesday, July 30, 2013 5:27 AM -
Proposed0Votes
Looking for best practices regarding: CDC, permanent persistence of change history, and application development
Hello, I work for a university that maintains a large web application. One requirement is that the application track all changes to certain tables (federal financial ...3 Replies | 238 Views | Created by JimmyCarterII - Friday, July 26, 2013 6:33 PM | Last reply by davidbaxterbrowne - Monday, July 29, 2013 1:02 PM -
Answered0Votes
Get Current Month and Current Year
Hi I have created an srs report in report builder 3.0 At the top of my report, I need to add the current month and year (example: July, ...2 Replies | 191 Views | Created by katiemackie - Monday, July 22, 2013 10:45 PM | Last reply by SathyanarrayananS - Wednesday, July 24, 2013 5:36 PM -
Proposed0Votes
How to test reports generated using web intelligence and sql server?
Hi all, How to test reports generated using web intelligence and sql server? One way of validating the data is to write sql query based on the report requirement ...2 Replies | 7275 Views | Created by Eveta - Sunday, October 10, 2010 8:41 PM | Last reply by SathyanarrayananS - Wednesday, July 24, 2013 5:24 PM -
Answered0Votes
How can we find on which particular partition function basis the partition table is linked with from the sys tables?
Hello all, I am having little problem with the finding the particular partition function of particular Tables related to the sys.partition tables. Can anyone tell ...6 Replies | 7322 Views | Created by Anil Maharjan - Monday, January 31, 2011 12:38 PM | Last reply by Harish Kumar rama - Wednesday, July 24, 2013 10:17 AM -
Answered0Votes
Winform app not working with SQL Filestream outside of LAN
Wrote a simple photo storage Winform app that simply stores and lists photos in a grid. Application works %100 even with a non-domain workstation inside the LAN. However, when I attempt run the app ...4 Replies | 197 Views | Created by GroundLoop - Monday, July 22, 2013 2:48 PM | Last reply by Christian HL - MSFT - Tuesday, July 23, 2013 9:22 AM -
Answered0Votes
DW Cube
Hi All, I have a question like what exactly is a cube. Does cube contain query that fires on database. If so then why it is called as cube if it is a query. Does every reporting ...4 Replies | 216 Views | Created by venkatESH RAJAM - Monday, July 22, 2013 2:55 PM | Last reply by Prajesh - Monday, July 22, 2013 7:47 PM -
Unanswered0Votes
Change tracking on multiple tables to one table sync
Hi All, If I have two tables in souce DB syncing to one table in target DB, how do I use SQL 2008 change tracking feature to track it? The following is an ...1 Replies | 6698 Views | Created by meil2000 - Tuesday, February 01, 2011 9:30 PM | Last reply by Prajesh - Monday, July 22, 2013 4:02 PM -
Proposed0Votes
How foreign key references two more tables?
Hi I have created 3 tables with primary keys. create table dbo.test_index(id int identity(1,1) not null , name varchar(255) ...5 Replies | 226 Views | Created by SathyJay - Monday, July 22, 2013 10:45 AM | Last reply by SathyJay - Monday, July 22, 2013 11:29 AM -
Answered2Votes
Resource that explains the design of AdventureWorksDW schema data warehouse
Hi, Lots of the examples from SQL Server resources use the AdventureWorksDW data warehouse. Unfortunately none starts to explain what the schema entails and how it was derived amd ...2 Replies | 207 Views | Created by imiah - Monday, July 22, 2013 1:48 AM | Last reply by Latheesh NK - Monday, July 22, 2013 5:07 AM - Items 1 to 20 of 1149 Next ›