|
|
|
|
|
Total Hits: 12 | 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: 113 | Today: 0
|
Author: hong_wei_li@yahoo.com
|
Rating:
|
|
In the SQL Server 2005, after you create a SSIS package ( DTS), you want to create a job and schedule to run it. You will get the error to prevent you to run the job. What is the problem?Here is why: SQL Server 2005 is quite different from SQL Server 2000. In SQL Server 2000, you can create the job and run it without problem. In SQL Server 2005, you need to go through the security layer in order to run the job....
|
|
|
|
Total Hits: 92 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
Database Administrators and SSIS Developers have always come across scenarios where you need to create a comma separated delimited text file for very large tables in SQL Server 2008. Once the delimited text file is generated the files can be compressed and they can be easily FTP to client locations. This is one among the fastest and easiest way to distribute the data. In this article you will see the steps which you need to follow to create a SQL Server Integration Services Package which can be ...
|
|
|
|
Total Hits: 228 | 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: 279 | Today: 1
|
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: 253 | Today: 0
|
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: 253 | 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: 290 | 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: 313 | Today: 1
|
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: 256 | 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: 261 | Today: 1
|
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: 248 | Today: 1
|
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....
|
|
|
|
|
|
