We get a MYSQL 5.0 dataset each month (1.7gig) and I need to create a process to migrate this to a SQL Server 2008. This seems a little harder than I first thought... I've tried a few ways: Using the Import wizard Setting up a linked server I've also tried different ways: Using the .net Framework Dataprovider for MYSQL Using MYSQ...
Some dimension tables in my warehouse: DML Site Id bigint Name nvarchar(256) Primary key (Id) DATA SiteId Name 2 Site 2 3 Site A DML UserSite Username nvarchar(256) SiteId bigint Primary key (Username, SiteId) Foreign key (SiteId) referrences Site(Id) DATA Username Sit...
Hello everyone, I am using SQL Server 2008 Enterprise. I want to export the query result into csv file from SQL Server Management Studio. The issue is, the default csv file is comma (',') separated for each result column in each exported row, and I want to make it '\t' separated since comma exists in some of the result column values. A...
I'm using SQL Server 2008. I should be able to "connect" to a user-specified database file (mdf) (using the AttachDbFilename section of the connection string) and save a copy of the selected file. I also have to work with the contents of the database. If I got it right, a single mdf file represents a complete database with tables, store...
Hi Is there any tool or program that show if sql server 2008 is running (like was in sql server 2000) ? how I can see the condition of sql server (if running or not) ? thank's in advance ...
What is the use of SYNONYM in SQL Server 2008? ...
Hello everyone, I am currently using Reporting Service of SQL Server 2008, and I think the user interface is not very elegant. And I want to use Silverlight as user interface to render reporting service backend data. Two questions, Is it possible? Reporting Service exposes interface which Silverlight could retrieve data and render? I ...
I am using SQL Server 2008 Enterprise. I am learning OUTPUT parameter of SQL Server stored procedure. For example, stored procedure sp_add_jobschedule has an OUTPUT parameter called schedule_id. http://msdn.microsoft.com/en-us/library/ms366342.aspx My confusion is, looks like OUTPUT parameter could be provided an input value and also r...
hi there, i've got two tables with time intervals and some settings for each interval, eg 2009-01-01T06:00:00 2009-01-04T14:00:00 1 0 2009-01-04T22:00:00 2009-01-07T06:00:00 2 1 2009-01-07T06:00:00 2009-01-09T13:00:00 2 2 2009-01-09T22:00:00 2009-01-14T06:00:00 3 0 and 2009-01-04T16:00:00 2009-01-05T01:00:00 2 0 2009...
Hello everyone, I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which DB or something. Any existing tools to solve this issue? thanks in advance, George ...
Hello everyone, I am using SQL Server 2008 Enterprise. I will issue a lot of query to SQL Server. And I think SQL Server itself will use some optimization internally, like pre-fetching data into SQL Server internal data cache or accessing frequent requesting data from cache before load from physical page file to improve performance. An...
I have date field that holds the birthdate. I want to calculate the age somthing like [today] - [born date] How can I do it with a SQL Server 2008 query ? And why does the date look like 01-02-2009 when I need it 01/02/2009; how do I achieve that? Thanks a lot for any help ...
Hello everyone, I am using SQL Server 2008 Enterprise. And I am using Linked Server technologies to link another SQL Server 2008 Enterprise instance from another server. I write TSQL to manipulate objects (e.g. tables) from both server instances. My question is, for linked server, is there a big performance issue? If yes, what is the k...
How can I format the number 123.45678 to 123.45 in SQL Server 2008? ...
I find it useful and productive to use the built in Ctrl-Shift-M when creating a new stored proc in SQL Server Management Studio (2008). On one of my machines that keyboard shortcut combo has stopped working and I've been unable to work out how to restore it. There could also be some new utility on my machine that's overriding that but ...
Somewhere in the midst of thousands of records I have a decimal value in a sql column that has an odd value. Specifically, it has a decimal place of .002. The actual amount could be pretty much anything like 238.002 or 543.002 So how can I write a query to find that? ...
I am trying to put together db design for storing images. Many of you might have had experience designing db to store images and the challenges associated with it. The db might store hundreds of thousands of images eventually. I am planning to use SQL Server 2008 db and entity framework. Planning to use FILESTREAM datatype for storing ...
I've run across multiple situations in the last few months where legacy sql SP's are returning a single table made up mostly of redundant information. Example: Select CustomerID, CustomerEmail, CustomerAddress, InventoryLineItem, ShipQty from ... Returns: 55 [email protected] 723 StreetName InvLineItem#1 45 55 [email protected] 723 StreetName InvLineIt...
I have two tables A and B with A referencing a column in B with foreign key constraint. Now, i am trying to add more columns and constraints to table A by dropping table A and creating the table A again with new columns. SQL Server Mgmt Studio provides the "Drop and Create" option to do this where i alter the create table statement to ad...
i am trying to compare two databases on my SQL Server 2008 using the VSTS Db edition schema compare. I am getting an error "schema comparison not supported for sql 2008". ...