SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• select * from sys.databases shows torn pages detected on prod databases

  Hi Everyone, Hope all is well. I just noticed this morning that on our production server when I que…

  Pyman

  3 replies

  14 years, 1 months ago

  By: Pyman

• Need to find Trace

  Hi All, I need a trace to find open transaction more than 1 hour. Regards, SQLisAwe5oMe.

  SQLisAwe5oMe

  4 replies

  14 years, 1 months ago

  By: Jack Corbett

• Execution Plan Version.

  Hi, I have an execution plan has been cached and reused numerous times -during this time it has bee…

  brk5tr

  2 replies

  14 years, 1 months ago

  By: brk5tr

• Tricky! obtain Stored Procedure Parameters as columns in result

  Hi can I ask for some SQL query help .. How would I return all parameter names for stored procedur…

  C# Gnu

  4 replies

  14 years, 1 months ago

  By: Cadavre

• Need to tune sql

  Hi, SELECT a.dnr_id, a.dnr_type_cd, a.dnr_type_desc, a.dnr_name, a.dnr_cst_guid…

  kiran.rajenimbalkar

  7 replies

  14 years, 1 months ago

  By: Grant Fritchey

• Executing SQL Scripts as an executable (.exe)

  Hey guys With every internal application release we have bunch SQL scripts which are checked into V…

  am-244616

  2 replies

  14 years, 1 months ago

  By: Ant-Green

• Seperate a string from a certain character on

  Hi I'm new to SQL and hope you can help. I want the following: I want a select query which selects …

  Wallertown

  4 replies

  14 years, 1 months ago

  By: Wallertown

• Optimizing Query

  I am trying to optimize the following query which is based on the AdventureWorksDW2008R2 database. …

  slpgma

  7 replies

  14 years, 1 months ago

  By: Phil Parkin

• sql server

  1)why a table can have one primerykey? 2)what is derivedtable in sql server? 3)what is subquery in …

  asranantha

  12 replies

  14 years, 1 months ago

  By: Perry Whittle

• about create plan in SQlServer2008 r2

  Helo Dear, I Loged in with sa user in SQlServer2008 r2 and wanted to Created Plan but I got Below e…

  zsafakhah

  2 replies

  14 years, 1 months ago

  By: zsafakhah

• Multiple Paramaters in sp_db_sendmail

  Hi All Is it possible to parse multiple Parameters in the @subject or @body parameters of sp_db_sen…

  SQLSACT

  4 replies

  14 years, 1 months ago

  By: SQLSACT

• I have a simple question on a select statement.

  Here is the query I am using. However the ID is always 1. How do I bring back a different ID for ea…

  foxjazzG

  2 replies

  14 years, 1 months ago

  By: vinu512

• Update table with id from another table

  Hello everyone/ First of all, i'm not quite sure if my issue is already solved in another thread be…

  nicoalmontec

  23 replies

  14 years, 1 months ago

  By: nicoalmontec

• SQL JOBS

  Hi, I just need to disable sql jobs during holidays. I found few ways for doing that but I don't kn…

  mdkmohan

  12 replies

  14 years, 1 months ago

  By: Preetham Gowda

• How to get the sequence

  Hi, I have an table called type. SeqAttributeTypeTypeid 15 10 21 …

  tonyarp05 61903

  5 replies

  14 years, 1 months ago

  By: Cadavre