SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Does '+' operator collation sensitive or not?

  I have posted bug (from my point of view) on connect.microsoft. I reproduce it's text here: -------…

  Shcherbunov Neil

  7 replies

  11 years, 5 months ago

  By: RodrigoR.Gomes

• Trying to reduce size of Log file.

  From Database Properties Initial Log file size = 25 MB From DBCC sqlperf (logspace) LogSize 2…

  Dan121

  3 replies

  11 years, 5 months ago

  By: Dan121

• convert date to mm/dd/yyyy format

  I am new to SQL and trying to figure this out...Please help.. IU need to convert the following dat…

  JROCK

  2 replies

  11 years, 5 months ago

  By: Steve Jones - SSC Editor

• backup of database

  I have 15 TB of database I want to complete the full backup of the db in less time how can we ach…

  ramyours2003

  4 replies

  11 years, 5 months ago

  By: SQL Guy 1

• Space utilization audit

  Hi all, I have a server with ~25 databases and each database has anywhere between 10 and 500 tables…

  sql_er

  5 replies

  11 years, 5 months ago

  By: sql_er

• difference between covering index and index with included columns

  Hi I have just run a query to get missing indexes from the plan cache. From the results I am advise…

  PearlJammer1

  2 replies

  11 years, 5 months ago

  By: Jack Corbett

• Misbehaving UNION query

  I have a really weird situation - never seen anything quite like it. I have a view defined as a Uni…

  pdanes

  2 replies

  11 years, 5 months ago

  By: pdanes

• is this sql is proeritary or standerd sql.

  hi, Select t.* from t where not exist ( select t1.id from t1 where t1.id=t.id …

  rajemessage 14195

  7 replies

  11 years, 5 months ago

  By: Ed Wagner

• Debugging of query

  I don't have experience in development , how to debug the query?

  ramyours2003

  2 replies

  11 years, 5 months ago

  By: Grant Fritchey

• how to encrupt storedproc in one script.( one go)

  hi, (Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c)…

  rajemessage 14195

  2 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Moving and Data from One Table to Another

  I have a series of flatfiles that I need to import into my database. These files have a name forma…

  Neil Burton

  2 replies

  11 years, 5 months ago

  By: Neil Burton

• Utility explorer error

  I am getting below error while i am enroolling the instnce. Could you please me on this WMI must be…

  santhosh411

  1 replies

  11 years, 5 months ago

  By: chammann

• Covering index and parameter order

  I have a covering index on (City, State). Is the SQL server engine smart enough to use the covering…

  matt6749

  2 replies

  11 years, 5 months ago

  By: matt6749

• Creating a table to be use with user searches

  I have a situation where the developers are creating a dynamic string with each search and we are h…

  dndaughtery

  2 replies

  11 years, 5 months ago

  By: Jeff Moden

• How to get the next Identity within an Merge Insert? Converting RBAR to SET based.

  I am trying to convert a RBAR procedure into a set based procedure. A RIN in the vTable is unique f…

  LinksUp

  7 replies

  11 years, 5 months ago

  By: LinksUp