SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Restore from a backup with a wildcard ??

  I have a backup that comes to me nightly in the format of XXXX_YY_MM_DD.bak where the date is incre…

  jbalbo

  7 replies

  9 years, 7 months ago

  By: Thomas Rushton

• Display 5 records each time from a table sql script

  Hi Experts I want to display 5 records each time from a column until all records are touched in the…

  SQL_Hunt

  2 replies

  9 years, 7 months ago

  By: SQL_Hunt

• Check all the users have running profiler trace permission

  Hello, Granting the permission to run trace is simple, but if I need to check who all users have ex…

  SQL_Hunt

  1 replies

  9 years, 7 months ago

  By: Sue_H

• dynamic t query -- unable to add the string to the last column as "DBCC SHRINKFILE(<TransactionLogName>, 1)"

  Hi Procters I was trying to gather a query with data to get all the shrink tlog commands, but not w…

  SQL_Hunt

  2 replies

  9 years, 7 months ago

  By: Sue_H

• How to avoid this message : 'Database name 'tempdb' ignored, referencing object in tempdb.'

  Hi, How to avoid this message? I tried to fix this but no luck. ----------------------- Warning ---…

  SQL_Hunt

  6 replies

  9 years, 7 months ago

  By: Jacob Wilkins

• Indexing strategy

  Dear all, I have below query: SELECT apr.POC_ID AS poc_id, DATEADD( DAY, 0, DATEDIFF( D…

  river1

  6 replies

  9 years, 7 months ago

  By: ScottPletcher

• CMDExec Proxy account not working with Domain Service Account...

  I'm working on migrating an existing Server 2003 / SQL 2005 system to Server 2008 R2 / SQL 2008 R2,…

  jasona.work

  5 replies

  9 years, 7 months ago

  By: Rudy Panigas

• SQL Server 2008R2 SP3 Internal Memory error

  Running 2008R2 SP3 (64bit) with an 8GB memory max. One if our Applications is failing with this er…

  Jpotucek

  5 replies

  9 years, 7 months ago

  By: rvsc48

• Isolation level inside stored procedures

  Dear all, I have this stored procedure that has inside: SET TRANSACTION ISOLATION LEVEL READ UNCOMM…

  river1

  2 replies

  9 years, 7 months ago

  By: Sean Lange

• EXEC sys.sp_expired_subscription_cleanup

  EXEC sys.sp_expired_subscription_cleanup throwing error Msg 18482, Level 14, State 1, Line 1 Could…

  Bhuvnesh

  1 replies

  9 years, 7 months ago

  By: SQL_Hunt

• What are the Career opportunities after Sql Server DBA Training ?

  Hi , Am a software engineer in one of the MNC's. I recently completed MS SQL Server DBA Training an…

  camillerabe25

  1 replies

  9 years, 7 months ago

  By: Grant Fritchey

• Space Availability on a network share

  Hi Experts Please provide an useful script to gather the available space in the network drive. Than…

  SQL_Hunt

  1 replies

  9 years, 7 months ago

  By: Sergiy

• How to optimize my current sql query without using a sub query

  In my query, I have two columns displaying a value based on a sub query. If you notice, I have two …

  shezi

  5 replies

  9 years, 7 months ago

  By: shezi

• find high availability configure in SQL server 2008 R2

  Hi, How to find what high availability SQL server 2008 R2 has been set up? Like is my server is con…

  yuvipoy

  1 replies

  9 years, 7 months ago

  By: Sue_H

• Group Concatenate Strings?

  CREATE TABLE #t (a tinyint NOT NULL, b VARCHAR(10), c VARCHAR(10)) GO INSERT #t (a, b,c) VALUES (1,…

  TheSQLGuru

  9 replies

  9 years, 7 months ago

  By: mister.magoo