|
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: Anton Burtsev
|
Rating:
|
|
Did you ever been asked to find all holes in document numbers (docs are sequentially numbered)? I had to do this search twice. Once for auditing purposes: holes may mean some sort of forgery. And now customers want to reuse numbers of deleted docs. And how do you think holes can be found using SQL ? Assume we have:...
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: Md. Marufuzzaman
|
Rating:
|
|
This is just a simple article to Store any file format into a SQL server database. Recently I completed a project where I need to store various file i.e.Microsoft Office file formats, Pdf, Images etc.). When I start to write code I write a function to store binary, after that I thought why not I am using direct bulk insert from a StoredProcedure....
|
|
|
|
Total Hits: 93 | Today: 0
|
Author: BobP1339
|
Rating:
|
|
Recently, I had the pleasure of working with a data source that returned all of the transactions with one Stored Procedure. However, this meant the Stored Procedure returned 14 result sets and an output parameter. The question was how to get the 15 result sets into SSIS. The answer: use a script component. This article describes the path I took to handle this. All connections in SSIS are handled through connection managers. We will have to have a connection manager to connect to the source datab...
|
|
|
|
Total Hits: 239 | Today: 0
|
Author: Ashish Kumar Mehta
|
Rating:
|
|
Database Administrators and SSIS Developers will often come across scenarios where they need to import a comma separated delimited text file into SQL Server. Providing the data in comma separated delimited text file is a very common practice which is used by many organizations around the world. Once the delimited text file is generated the files can be compressed and FTP’d to a client location from where it can be picked up and loaded into SQL Server 2008 using SQL Server Integration Services....
|
|
|
|
Total Hits: 87 | 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: 136 | 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: 136 | 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: 132 | 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: 153 | 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: 176 | 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: 125 | 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: 147 | 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 ...
|
|
|
|
|
|
