SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• To Index, or Not to Index

  I have a huge table (80 mil) records where I need to append an extra URL column. The query is kind …

  Michelle-138172

  5 replies

  13 years ago

  By: dan-572483

• Virtualized SQL Server

  Hello, I know that is a subject very discussed on the internet, but i need to ask here to have sure…

  rafael_si

  1 replies

  13 years ago

  By: Neeraj Dwivedi

• bcp CSV to DB table

  To all: I am trying to import a CSV file into a database table using bcp, however I am getting the …

  Meatloaf

  7 replies

  13 years ago

  By: Neeraj Dwivedi

• schema bind view

  We need to change a view that is using schema binding. In the view we used a UDF. But when alter it…

  sqlfriend

  4 replies

  13 years ago

  By: sqlfriend

• Alternative for Excell (Access).

  Dear reader, It's not difficult to convince any manager; that storage in SQL-server would be a good…

  ben.brugman

  5 replies

  13 years ago

  By: royce.bacon

• Partitioning Tables - Querying Question.

  Hello, I hope someone can answer a question I was asked but was not sure about. If you partition a…

  Duran

  2 replies

  13 years ago

  By: Gail Shaw

• URGENT: Maintenance plans running as me. I dont want that to happen.

  Hello, I have set up many maintenance plans in the past, but I have found that in one environment, …

  Duran

  6 replies

  13 years ago

  By: Duran

• Assigning Default Constraint to a column based on another Column...

  Hi All, I have two Columns in my Table Status A and Status B. I want to create a Default Constraint…

  ard5karthick

  2 replies

  13 years ago

  By: drew.georgopulos

• Get data from 3 or more tables

  I have tables with following definition' CREATE TABLE [dbo].[items]( [srno] [int] IDENTITY(1,1) N…

  hemal_301080

  18 replies

  13 years ago

  By: hemal_301080

• Query to get system databases

  Hi, I want a query to get list of databases except system databases from sys.databases.I don't know…

  IT researcher

  4 replies

  13 years ago

  By: IT researcher

• SSRS Paramaters

  Hi everyone I have a report in SSRS which contains the paramater @Region. The paramater allows for…

  ByronOne

  5 replies

  13 years ago

  By: bob_armstrong4

• FISQL: DB-LIBRARY error: Data conversion resulted in overflow

  I use fisql to query my SQL SERVER with this script SELECT TOP 10 SUBSTRING(qt.text,1,100), qs.tot…

  OracleBoy

  1 replies

  13 years ago

  By: Lynn Pettis

• Adding to Sales Quantities

  Hi I have a table that forecasts our Sales for the upcoming year. It contains the following column…

  ByronOne

  6 replies

  13 years ago

  By: ChrisM@Work

• SQL Server Errorlog

  Good Day. We are using SQL Server 2008R2 and it ROCKS1!!! I would like to know how one can change t…

  lianvh 89542

  2 replies

  13 years ago

  By: Gail Shaw

• Pushing Data from T-SQL to Visual Studio While Debugging

  I am debugging my T-SQL code in Visual Studio ... is it possible for me to write something in my Tr…

  matt_1ca

  6 replies

  13 years ago

  By: matt_1ca