SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Server 2008 R2 Installation Error

  Hi Folks, In our Production environment, we are trying to add one more additional standalone instan…

  Er.Karthikeyan

  4 replies

  9 years, 10 months ago

  By: Er.Karthikeyan

• Need to split the row values

  Hi All, I have a below row in a table. I need to split this row It need to be split after this valu…

  p.shabbir

  21 replies

  9 years, 10 months ago

  By: p.shabbir

• Performance Check

  Hi, How to check the performance on the SQL Server for which we recently moved the sql server datab…

  Admingod

  5 replies

  9 years, 10 months ago

  By: Grant Fritchey

• Deadlock on simple query

  I've been getting deadlocks in a simple query like: Select {data} From DataTable DT Inner Join Se…

  Chuck Bevitt

  7 replies

  9 years, 10 months ago

  By: Sergiy

• Error: 17827, Severity: 20, State: 1.

  We are running SQL 2008 SP1 on Windows Server 2003 sp2 Enterprise Edition, all 32 bit. We are gett…

  ten_spoons

  4 replies

  9 years, 10 months ago

  By: Ignacio A. Salom Rangel

• rows to columns

  Hi Friends, I am trying pivot the rows but I am struggling to get the query. Here is the sample o…

  Charmer

  15 replies

  9 years, 10 months ago

  By: Y.B.

• Solid Wood F-u-r-n-i-t-u-r-e For Sale Kent

  Solid Wood Furniture For Sale Kent . Go to http://www.furnitureforsale-uk.co.uk

  serama54

  1 replies

  9 years, 10 months ago

  By: Stuart Davies

• Moving Large Table to Different File Group

  Hi, what is the fastest and safest way to move a table (or all tables within a schema) of a File Gr…

  info 58414

  3 replies

  9 years, 10 months ago

  By: johnwalker10

• 50Plus NT AUTHORITY\SYSTEM Logins By Windows Scripting Hosts Every Hour

  We are trying to track down what app/service is connecting to the SQL Server instance in question a…

  YSLGuru

  3 replies

  9 years, 10 months ago

  By: YSLGuru

• Return string between 2 characters from the end of the string

  I have data in a field that looks like this: 'INV CRT IS15000467 1', 'INV CSH 144934 1', 'INV…

  manderson 20961

  18 replies

  9 years, 10 months ago

  By: Jeff Moden

• Licensing - Multiplexing

  I have reviewed the SQL Server 2008 licensing guide (http://www.microsoft.com/sqlserver/2008/en/us/…

  mnDBA

  3 replies

  9 years, 10 months ago

  By: Gail Shaw

• UDF slow even when used as a persisted computed column

  Hi, Today a view of ours slowed down to a crawl. It selects rows from a single table where column e…

  DennisPost

  21 replies

  9 years, 10 months ago

  By: DennisPost

• Data archival method - viable?

  Context Looking to implement a database archival process that could be used across different produc…

  doshea

  2 replies

  9 years, 10 months ago

  By: Steve Jones - SSC Editor

• Scrub Personal Information Data

  q

  Cawie

  2 replies

  9 years, 10 months ago

  By: Lowell

• Reporting Services - Returning Results from Stored Procedure

  I want a simple result set from a stored procedure to display in RS. So when my SP runs SELECT JOB_…

  homebrew01

  3 replies

  9 years, 10 months ago

  By: pietlinden