For a customer, I need to load data from excel 2010 spreadsheets into a sql server 2008 r2 database for a one time set of adhoc queries. I will then...
In a sql server 2008 r2 database, I have a question about using a datetime field. I have a column called start_date that is setup in the database as...
My goal is to setup a new database on an existing instance of sql server 2008 r2 database. I do not want to use the default values, but want to use...
I want to add a new database to an existing sql server 2008 r2 instance. I then want to write report builder 3.0 reports to access the database by...
In a new table in sql server 2008 R2 that I will be setting up, I am wondering if there is a problem setting up a column size to be varchar(max) for...
Since I am new to setting up a database on sql server 2008 r2 and creating tables that are referenced by foreign keys, I would like to ask the...
I want to extract data from a specific tab in an excel 2003 workbook using SSIS and place the data into sql server 2008 r2 in an automated, scheduled...
I would like your suggestions on how to make a sql server 2008 r2 stored procedure to run more efficiently. The stored procdure is used as a...
I have the following performance question on joins in sql server 2008 r2. Is there a performance problem when I join 5 tables using inner joins and...
I have a question on how to optimize t-sql statement in a sql server 2008 r2 database. In my company one database is being redesigned into 9 other...
I am new to ssis. My company has the sql server 2005 standard edition for a couple of more months. Later this year my company will be converting to...
I would like to know how to select random records from data in both sql server 2005 standard edition and sql server 2008 r2 using t-sql.
I write out ssrs 2008 or ssrs 2008 r2 reports to a file share using code based upon the link: http://msdn.microsoft.com/en-us/library/ms152787.aspx....
I am new to using sql server 2005 studio. I am more experience using sql server 2000 DTS packages. I would like to ber able to use this environmnet...
I am used to using the DTS package in sql server 2000 to export files to users in a pipe delimited format. I now have sql server 2005 management...
> Is it possible that > the WHERE Clause > ''where customer_number is null'' > is not satisfied,,, and the id was not updated ,,,, and the id...
I am having problems with the debugger in query analyzer. I am doing the following so far: 1. I have setup a t-sql script has a stored procedure,...
Is transforming an excel spread file to an output pdf format an option using dts packages. If so, how would you accomplish this task?
I am relatively new to sql server 2000. I have a transaction log that is 98 gigs in size that has never been backed up. This transaction log file is...
Separate names with a comma.
