|
|
|
|
|
Total Hits: 20 | Today: 0
|
Author: Vuyiswamb
|
Rating:
|
|
In this s Article I am going to explain the technology that came with Sql 2005. This is SSIS which stands for Sql Server Integrated Services. Recently I was working on a project for a client with large sum of Data and there was a need to process the data on a certain time frame. There were lot of technologies available at my Disposal, but this kind of Functionality needed to be streamlined and optimised. Of all the Technologies, i have chosen SSIS. In this Article I will demonstrate on how to ex...
|
|
|
|
Total Hits: 48 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
To execute a stored procedure that returns row, you can run a TableAdapter query that is configured to run a stored procedure (for example, CustomersTableAdapter.Fill(CustomersDataTable)).
If your application does not use TableAdapters, call the ExecuteReader method on a command object, setting its CommandType property to StoredProcedure. ("Command object" refers to the specific command for the .NET Framework Data Provider that your application is using. For example, if your application i...
|
|
|
|
Total Hits: 284 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
I am new to the SQL Server platform and want to break into the field. I have been doing IT work for a while now and I am looking to focus my career on SQL Server. Do you have any suggestions? Where should I start? What should I be prepared for during the interview process? Congrats and welcome to the field. It will probably be a long road, but one of the first decisions that needs to be made is exactly what you want to do. You could work as a DBA, Developer, BI developer, BI Admin or a com...
|
|
|
|
Total Hits: 340 | Today: 0
|
Author: Ray Barley
|
Rating:
|
|
We have chosen MOLAP storage in order to maximize the query performance of our cubes. Since we have a number of cubes we are now focused on coming up with a strategy for keeping the cubes up to date as the data in our warehouse changes frequently. Can you give us the details on how we go about implementing the Proactive Caching feature in SQL Server Analysis Services 2005?...
|
|
|
|
Total Hits: 311 | Today: 1
|
Author: Ray Barley
|
Rating:
|
|
We are looking to automate the processing of our SQL Server Analysis Services dimensions and cubes. We'd like to add this processing to our existing SQL Server Integration Services (SSIS) packages which periodically update our data warehouse from our OLTP systems. Can you give us the details on how the Analysis Services Processing Task can be used in an SSIS package?...
|
|
|
|
Total Hits: 307 | Today: 0
|
Author: Ray Barley
|
Rating:
|
|
We are looking to automate some tasks to be performed on our SQL Server Analysis Services Servers. Can you give us the details on how the Analysis Services Execute DDL Task can be used in a SQL Server Integration Services (SSIS) package? The Analysis Services Execute DDL Task is a very useful one, allowing you to do just about anything with a SQL Server Analysis Services instance. For example you could backup a database, process a cube, create a partition, merge partitions, etc. You specify c...
|
|
|
|
Total Hits: 352 | Today: 0
|
Author: Ray Barley
|
Rating:
|
|
We are anticipating building some very large cubes and would like to get a handle on how to partition our measure groups to provide flexibility in processing and administering our cubes. Can you guide us through the steps to define multiple partitions for a measure group and provide some explanations? The default behavior in SSAS is to create a single partition for a measure group. Creating multiple partitions for a measure group is definitely a best practice when you have very large fact tab...
|
|
|
|
Total Hits: 375 | Today: 0
|
Author: David Bird
|
Rating:
|
|
Setting up an alert to e-mail an operator with a message is a multiple step process. You can setup database mail, define an operator and an alert, but still no e-mail is being sent. So how do you send an alert to an operator? First setup database mail with a profile named SQLAlerts. The profile can be named anything but in these instructions, the profile name SQLAlerts is referenced. If you wish to use a different profile name just substitute accordingly. For procedures in setting up database ma...
|
|
|
|
Total Hits: 326 | Today: 0
|
Author: Armando Prato
|
Rating:
|
|
Microsoft does not guarantee that table and database space allocation information will be maintained accurately. In a high transaction OLTP database or after a large bulk copy of data has been performed, this can lead to inaccurate database space reporting when using the system stored procedure sp_spaceused....
|
|
|
|
Total Hits: 338 | Today: 0
|
Author: Tim Ford
|
Rating:
|
|
We have two SQL 2005 64-bit clusters in our organization: a four-node production cluster and a two-node dev/test cluster. We recently migrated a database from SQL 2000 that relied on an Oracle linked server for some of it's computations. No big deal, right? Install the Oracle client software and create the linked server just like in SQL 2000 right? Be sure to repeat the process on both nodes for failover-sake, right? Wrong. In the case of 64-bit SQL instances we have a few extra steps we ...
|
|
|
|
Total Hits: 314 | Today: 0
|
Author: Edgewood Solutions Engineers
|
Rating:
|
|
Some tasks that are run in SQL Sever take a long time to run and it is sometimes difficult to tell whether these tasks are progressing or not. One common way of determining that status is to look at the data returned from sp_who2 or sp_lock to ensure that things are still working and the process is not hung. With SQL Server 2005 several dynamic management views have been added, so let's take a look at some of these and how they can assist....
|
|
|
|
Total Hits: 293 | Today: 0
|
Author: Tim Ford
|
Rating:
|
|
How many times have you had to troubleshoot or make changes to an existing database that is not documented properly or completely? Even need to look for a specific stored procedure that references a specific table or process? If you have intimate knowledge of the database then this may not be much of an issue for you. What happens if this database is from an external developer, a turn-key solution provider, or developed by another individual within your company? If you utilize the INFORMATIO...
|
|
|
|
|
|
