SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Handling foreign key with no value

  i have a database that links a laptop type in a user table to another table (laptop) on laptopid. h…

  mark evans-234981

  2 replies

  13 years, 1 months ago

  By: Ed Wagner

• Read Committed_Snapshot

  "Read Committed_Snapshot" isolation level in sql has any negatives or disadvantages?

  IT researcher

  16 replies

  13 years, 1 months ago

  By: Grant Fritchey

• Bulk Insert via VBA - Operating system error 5

  Hi, I hope this is the correct location for my question. I have written a simple piece of VBA to co…

  peter.griffin 45527

  2 replies

  13 years, 1 months ago

  By: peter.griffin 45527

• Alter numeric(12,6) to numeric(19,4) - is it metadata only or is it recreate table?

  Would be most grateful for confirmation/infirmation of theory below: Changing an existing table col…

  Ol'SureHand

  7 replies

  13 years, 1 months ago

  By: marc.snoeys

• Strange issue with one of the four Sharepoint databases that we Log ship to our DR site.

  On the server that hosts our Sharepoint databases we are log shipping 4 of them to a sql server ins…

  mcdba@russweb.co.uk

  3 replies

  13 years, 1 months ago

  By: AJ@SQL

• System.Data.SqlClient.SqlException (0x80131904): Timeout Expired

  I apologize if this question has been asked before, but we're really stumped and the answers I've s…

  molly.r.maloney

  2 replies

  13 years, 1 months ago

  By: Andrew G

• BULK INSERT Different Data Types in the SAME Columns

  Issue: I have a small csv file uploaded through a web page by an end-user. It has two INT columns. …

  yoffes

  1 replies

  13 years, 1 months ago

  By: AJ@SQL

• Need help to read text file

  Hi, My text file as attachment ~ AG-Persekutuan-Bln-09-2012.txt How to read this file as follows, 1…

  Qira

  6 replies

  13 years, 1 months ago

  By: Jeff Moden

• Data not inserting

  Hi i have written a query to check the insertion but its not working neither getting any error : De…

  kapil_kk

  10 replies

  13 years, 1 months ago

  By: kapil_kk

• SQL Script Help - Need to capture a single transaction from many possibilities

  Here is the DLL IF EXISTS ( SELECT * FROM sys.objects WHERE object_i…

  SQL_Enthusiast

  1 replies

  13 years, 1 months ago

  By: SQL_Enthusiast

• table naming conventions

  we are creating a new database maintaining address and in the future may have more into the databas…

  sqlfriend

  3 replies

  13 years, 1 months ago

  By: Eugene Elutin

• sys.dm_io_virtual_file_stats - Number of Read and Writes

  I looked up http://msdn.microsoft.com/en-us/library/ms190326.aspx for details on sys.dm_io_virtual_…

  sqlstar2011

  5 replies

  13 years, 1 months ago

  By: Orlando Colamatteo

• Can't get rid of Key Lookup in execution plan

  I have a query that has a very costly Key Lookup step in its execution plan. It looks like this: S…

  TheGreenShepherd

  9 replies

  13 years, 1 months ago

  By: Lynn Pettis

• how to combine and convert two integer columns to datetime

  I have date stored in a column as integer type and time stored in a column as integer type. How do …

  Naidu PK

  15 replies

  13 years, 1 months ago

  By: Naidu PK

• how to make a stored procedure return a value when there are no available values

  Here is the script for a stored procedure that i have, i want the stored procedure to return a valu…

  klineandking

  11 replies

  13 years, 1 months ago

  By: Eugene Elutin