SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Regex pattern is throwing error when i'm using it in where Clause

  Hi All, I wanted to use Regex Pattern in my where clause to narrow down the records , but the query…

  krishnamurali2489

  1 replies

  10 years ago

  By: Lowell

• Cannot connect to (local) - how can I copy databases to another computer?

  Yesterday, everything was fine. This morning - open SQL Server Management Studio, the Connect to Se…

  webskater

  4 replies

  10 years ago

  By: Gail Shaw

• The mystery of high memory usage

  HI all, I have issue with memory usage . Available memory is 12 GB and memory usage is 91 % I notic…

  WhiteLotus

  5 replies

  10 years ago

  By: WhiteLotus

• Convert date to MMDDYYYY

  Hi All, I need to export data out to a txt file with the date format of MMDDYYYY - the source date …

  micang

  13 replies

  10 years ago

  By: Orlando Colamatteo

• Data corruption aftermath -- future prevention

  Last week, we discovered that our SQL Server installation had some significant data corruption in i…

  nhansen pcc

  23 replies

  10 years ago

  By: Grant Fritchey

• Import a .xls file to load into SQL database Via SSIS package

  Microsoft Visual Studio 2008 (version 9) I created a SSIS package were I import a .xls file to load…

  mylenechalut

  7 replies

  10 years ago

  By: frederico_fonseca

• Available RAM in SQL 2008 set to SQL 2000 compatability mode

  We are having a discussion about available RAM on an older server. Server specs are: OS - Windows …

  nelsonj-902869

  2 replies

  10 years ago

  By: nelsonj-902869

• How do I get a multi user table created without DBA involved?

  Hello All, I have a situation where I have to pull data from many tables creating & merging mu…

  nikhil_kapoor1712

  10 replies

  10 years ago

  By: Eric M Russell

• SQL Server will only allow remote TCP connections if port is specified.

  Hi All, I hope someone can clarify a connection issue I am having. 1.SQL Configuration Manager i…

  suresh.yadav 82912

  2 replies

  10 years ago

  By: george sibbald

• SQL job is getting Hung with : PREEMPTIVE_OS_PIPEOPS

  I have a job which prints a cards from third party .exe . The SQL job executes xp_cmdshell every m…

  SQL Severe DBA

  3 replies

  10 years ago

  By: jeff.mason

• Object reference not set to an instance of an object

  I have 2 SQL servers, A and B, both run a program to insert records to DB and runs for years and it…

  calvin_wk_wong

  1 replies

  10 years ago

  By: djj

• last_user_SCAN, last_user_Seek, last_user_Lookup, and last_user_Update

  I run job every 10 minute to identify unused databases. Job runs SP which inserts into my table dat…

  New DBA

  5 replies

  10 years ago

  By: New DBA

• Change SQL Data Root Directory

  I am hoping there is a way to change the "data root directory" after a SQL 2008R2 install. I gave …

  lmacdonald

  14 replies

  10 years ago

  By: h2.huang

• NULL values on a LEFT JOIN

  I am unable to get rows where ad.StatusAppDetail IS NULL. I am using the following code. SELECT DIS…

  SQLPain

  2 replies

  10 years ago

  By: jeff.mason

• Use of Trigger on a table which could have 100 hits per second. Will it hamper performance?

  Hi All. Currently in one of our project we have a situation. The server computer is Windows Server …

  shoab.shah

  3 replies

  10 years ago

  By: ScottPletcher