Okay, you don't need to be a guru, but if you happen to have a good working knowledge on SSIS and you used some tutorials around the web to get you there, then please share them. I have been trying to find some solid stuff (screencasts maybe), but I am having a hard time. Any solid links would be appreciated and I will add them to this...
I have a fairly good feel for what MySQL replication can do. I'm wondering what other databases support replication, and how they compare to MySQL and others? Some questions I would have are: Is replication built in, or an add-on/plugin? How does the replication work (high-level)? MySQL provides statement-based replication (and row-...
Is there a query in SQL Server 2005 I can use to get the server's IP or name? ...
What are the steps needed to successfully be able to remotely debug a store proc (SQL Server 2005) from within VS 2005? Again both client and server machines are on the same domain. I have never done this so step by step instructions would greatly be appreciated. ...
I have a matrix in SQL reporting and I would like it to print on an A4 page. If the matrix has less than 4 columns then it fits but for more than 4 columns I would like the matrix to wrap and show only 4 columns per page. Is this possible? I am using SQL Reporting 2005 in localmode. ...
I'm just wondering what the optimal solution is here. Say I have a normalized database. The primary key of the whole system is a varchar. What I'm wondering is should I relate this varchar to an int for normalization or leave it? It's simpler to leave as a varchar, but it might be more optimal For instance I can have People =========...
I have an application that is causing a lot of headaches. It's a .NET app connecting to SQL Server 2005 via a web service. The program has grid that is filled by a long running stored procedure that is prone to timing out. In the case when it does time out and a SqlException is thrown, there is no execption handling to close the connecti...
Is it just that nvarchar supports multibyte characters? If that is the case is there really any point, other than storage concerns, to using varchars? ...
How do i store a directory / hierarchy / tree structure in the database? Namely MSSQL Server. @olavk: Doesn't look like you've seen my own answer. The way i use is way better than recursive queries :) p.p.s. This is the way to go! ...
Problem: Ajax suggest-search on [n] ingredients in recipes. That is: match recipes against multiple ingredients. For instance: SELECT Recipes using "flower", "salt" would produce: "Pizza", "Bread", "Saltwater" and so forth. Tables: Ingredients [ IngredientsID INT [PK], IngredientsName VARCHAR ] Recipes [ RecipesID INT [P...
Is it possible to install/register another local server instance in any SqlServer version, besides the default local instance, where only one SqlServer version is installed? ...
What's the best way to store tags for a record? Just use a varchar field? What about when selecting rows that contains tag x? Use the like operator? thanks! ...
How do I connect to SQL Server remotely and administer my datbase objects? I need to connect to my database in the web hosting company's server. I have the server name, IP address, my database username & password. I have an installation of SQL server 2000 in my machine. I searched the net but couldn't find understandable links. Can I use...
I was just browsing through questions on stack overflow, and i've come up to a post where it suggests of deploying database by simply copying the mdf file in the app_data folder and modifying your connection string. I know that some people do create an mdf file in the app_code during development, but for going life, Is this realy a via...
What is the best way to version control my database objects? I'm using Visual studio 2005/2008 and SQL server 2005. I would prefer a solution which can be used with SVN. ...
Within SQL Server Integration Services (SSIS) there is the ability to setup a connection to a flat file that can hold millions of records and have that data pushed to a SQL DB. Furthermore, this process can be called from a C# app by referencing and using the Microsoft.SqlServer.Dts.Runtime namespace. Would a flat file with millions of...
I have a T-SQL table variable (not a table) which has an auto incrementing identity column. I want to clear all data from this variable and reset the identity column value to 1. How can this be done? ...
Like many companies that require all access be through stored procedures, we seem to have a lot of business logic locked away in sprocs. These things are just plain hard to test, and some of them have become silly long. Does anyone out there have a set of best practices that can make it a little easier to confidently test these things?...
We use MS SQL Server and C#. Our database is under sourse control and I will tell you some details of our implementation. We had implemented two operations: Export database to plain-text files. Database schema files: tables.sql relationships.sql views.sql ... and table contents files: Data/table1.txt Data/table2.txt ... It is easy to ...
how can i get the list of available databases in a SQL server? im planning to make a list of that in combobox in vb.net. tnx. ...