SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Using REPLACE with a string where I need to replace %anystring% with some new string

  Hi everyone, I am actually fairly new to using the REPLACE function and don't know if I can use reg…

  Jared

  21 replies

  13 years, 9 months ago

  By: GSquared

• Find Usage of Column in Related Views

  Is there a way to find all instances where a column in an underlying table appears in a view? For …

  david.holley

  16 replies

  13 years, 9 months ago

  By: Jared

• Invisible database - Can't drop

  Hi, i was trying a database restore and it threw out Page errors. I had to restart the restore. But…

  Rainmaker097

  4 replies

  13 years, 9 months ago

  By: GSquared

• sql query logics

  hi friends i have a small doubt in sql plz tell me how to solve this task we have following two ta…

  asranantha

  5 replies

  13 years, 9 months ago

  By: J Livingston SQL

• SQL Server replication and tablediff

  Hi All, So my subscriber server had a crash the other day... The result of which meant that some r…

  Antony Symonds

  9 replies

  13 years, 9 months ago

  By: Antony Symonds

• Sleeping mode issue

  Hi All, I have single Database server using 8GB RAM & good space for DB. Issue :- SA us…

  saidapurs

  9 replies

  13 years, 9 months ago

  By: Gail Shaw

• AppDomain 12 (mssqlsystemresource.dbo[runtime].11) is marked for unload due to memory pressure.

  Hi All, I am getting these errors in sql log and windows event log as, 1)AppDomain 12 (mssqlsystemr…

  vinod.saraswat

  6 replies

  13 years, 9 months ago

  By: Gail Shaw

• sql query loice3

  hi friends i have small doubt in sql plz tell me answer A database that has been used in production…

  asranantha

  5 replies

  13 years, 9 months ago

  By: Grant Fritchey

• Creation of dynamic sql query to create a select statement to pick a unique record

  Hi All I am working on a search stored procedure for a website, I have following input parameters:…

  rajawat.niranjan

  16 replies

  13 years, 9 months ago

  By: rajawat.niranjan

• sql query logics2

  hi friends i have smal doubt in sql plz tell me answer whicch query give more perfomance annd how…

  asranantha

  2 replies

  13 years, 9 months ago

  By: asranantha

• Successful logging Auditing

  Guys, I am using a SQL Server 2008 R2 (SP1) box, the logging auditing is set to "failed loggins onl…

  Satish-1028188

  2 replies

  13 years, 9 months ago

  By: Satish-1028188

• How data will get search in partitioned table which is having index ?

  Dear All, How data will get search in partitioned table which is having index ? Regards, KoteRavin…

  ravi@sql

  8 replies

  13 years, 9 months ago

  By: Gail Shaw

• Trigger disabling and re-enabling causes performance increase

  Hi all, Suddenly the performance of one of our sprocs (multiple SELECTs, multiple tables) went from…

  ricklivesey

  9 replies

  13 years, 9 months ago

  By: ricklivesey

• While Loop into a Set Based Insert

  I was wondering if anyone is able to provide me with any help turning this while loop inside a stor…

  Richie T

  8 replies

  13 years, 9 months ago

  By: rhythmk

• sql query logic

  hi i have small doubt in sql query plz tell me the logic how this query running declare @a int ,@b…

  asranantha

  1 replies

  13 years, 9 months ago

  By: deepzzzz