• High LATCH_EX wait

    What is LATCH_EX wait? Our LATCH_EX wait is very high. What do I need to look at to fix this?

    Rick Martinez585 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • Software to automate backups for SQL Server 2008 databases

    I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up to do this? It's not...

    Phrathepmali30 pointsBadges:
  • SQL server 2008 provide access to SSIS

    Client needs access to SSIS sql server 2008   Thanks, Evgenia

    Evgenia5 pointsBadges:
  • SQL Server 2008 Finding Most Recent Record Only

    Hi there I have a databse that logs letter print activity The fields being Letter_Ref Print_date Any time someone prints a particular letter it leaves a date in print ref What i want to do is find the most recent print date for each letter_ref is this possible and if so how

    Davewaltonuk20 pointsBadges:
  • vb.net 2008 and sql server 2008

    How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan

    Semauel8515 pointsBadges:
  • Reading xml url into SQL Server 2008 Table with OpenXML

    I am parsing an xml file that contains an xml url and a text file url as values. OpenXML appears to be unable to read neither the xml url nor the url to the text file. It reads the urls to pdf and html locations fine. How can I get the process to get the xml url as text into my sql table.  My...

    Rscheinberg595 pointsBadges:
  • Problem with Visual Studio 2010 and SQL Server 2008.

    Hello friends! I am new here in this forum. I have a simple question. I am using Visual Studio 2010. But the SQL Server 2008 that comes with it does not have Management Studio with it. So I have installed SQL Server 2008 again seperately in my machine. Now I want to know how to attach SQL Server...

    Imraja25 pointsBadges:
  • Sql Server 2008R2 on Windows Sever 2008 R2

    When i attempt to install it tells me that my operating system is not supported, rule "Operating system supported edition" failed. however when i check the list of valid operating system it is listed, anyone had this issue before or know why i wont recognize, thank you

    Coopfirst5 pointsBadges:
  • Cost to upgrade to MS SQL Server 2008

    My company is implementing new features in our product line that will force customers to upgrade to SQL Server 2008. I can't make sense of MS's pricing for SQL Server upgrades any longer (i.e., it seems they've gone away from the notion of a SQL Server 'upgrade' license). Does anyone know a...

    Robcom8815 pointsBadges:
  • Is it possible to install SQL Server 2008 R2 on Windows 7 Home Basic 64 bit?

    Hi, Is it possible to install MS SQL Server 2008 R2 installation on Windows 7 Home Basic 64-BIT OS?

    Prateek5520 pointsBadges:
  • SQL Server 2008 R2 won’t install

    I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can't get past the failure. The following error has occurred: An error occurred during the installation of assembly 'policy.8.0.microsoft.vc80.crt, version='8.0.50727.4027',...

    Grabber60 pointsBadges:
  • Read Excel from Sql Server 2005/2008 SQLEXPRESS

    How to read the excel data's from Sql Server 2005/2008 SQLEXPRESS

    Sridhar12350 pointsBadges:
  • how can make this SQL Server query faster

    All, how can I make this query faster? Here is my code of stored procedure: ALTER procedure [dbo].[GetLMPReport] ( @typeId tinyint, @dataType varchar(2), @date date ) AS begin select distinct p.name, ISNULL (td24.price, 0) as '00', ISNULL (td1.price, 0) as '100', ISNULL (td2.price, 0) as '200',...

    Singhal120 pointsBadges:
  • Looking for detailed synchronization logging in SQL Server 2008

    We are in the process of performing a side-by-side upgrade from SQL Server 2000 to 2008 (Standard Edition in both versions). A merge publication is included in the upgrade, and it appears to be working fine on the new server, so there is no functional issue. However, I have grown accustomed to the...

    SBatSI415 pointsBadges:
  • Link Tables in AS400 to SQL Server 2008

    Has anyone set up a link server to their AS400 from SQL Server 2008/5?

    Jaymz69765 pointsBadges:
  • Case sensitive variables in SQL Server 2008

    Our company is using SQL Server 2008 with several databases. We just want one database to be case sensitive to names of variable but we don't want the others this way. We want to change the settings so we can run the following script without errors:DECLARE @A int DECLARE @a intHow can you change...

    ITKE350,945 pointsBadges:
  • SQL Server 2008: INSERT statement

    One of my family members needs some help! He has a table in SQL Server 2008 with the attributes name and ID. The ID is a generated value like this: INSERT INTO table (name) VALUES('bob');Now, he's looking to get back the ID in the same step. How can he do this?

    ITKE350,945 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following