SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• GROUP BY Result of Sub-Query

  select MAX(a.InvoiceId),c.SoldTo,(select 'CustomerOrderNumber1' = CASE WHEN c.SoldTo = 'G09905' THE…

  mark.dungey 56406

  1 replies

  12 years, 1 months ago

  By: Keith Tate

• Page life expetancy is low

  I get the following alert atleast 20 times a day for a couple of my production instances: Life Expe…

  Benki Chendu

  26 replies

  12 years, 1 months ago

  By: SQLRNNR

• Downstream query recompile when index is drop and re-created.

  Hi I haven't quite figured out how to prove or disprove this reliably so I'm hoping for a tip. What…

  Zagyg

  3 replies

  12 years, 1 months ago

  By: Grant Fritchey

• Named Pipes Provider: Could not open a connection to SQL Server [2]

  Hi guys, I need your help. I've this query for export the resultset in txt file: EXEC master.dbo.s…

  cms9651

  2 replies

  12 years, 1 months ago

  By: cms9651

• Complex search Functionality with joins

  Hi, Here is the sample table with data with Cooking as ( select 1000 as IDCooking, 'Cooking Waffle…

  born2achieve

  15 replies

  12 years, 1 months ago

  By: born2achieve

• SQL aliase

  Hi, i need to move the database to new server and application owner wants that specified database c…

  bala2

  1 replies

  12 years, 1 months ago

  By: chandan_jha18

• whats in the buffer pages

  I have a query (from an MVP - apologizies to the author for not remembering where I got it) that sh…

  Randy Doub

  7 replies

  12 years, 1 months ago

  By: chandan_jha18

• view pdf in report

  HI Please assist. I have a table with PDF files. I would like to display these files in a report.…

  monique 88355

  7 replies

  12 years, 1 months ago

  By: aframiller326

• Is there a way to generate a list of dates based on date ranges in another table?

  I have a BETWEEN statement that is excruciatingly slow. I'm linking tables by seeing if one date i…

  nonghead-webspam

  7 replies

  12 years, 1 months ago

  By: Jeff Moden

• UNIQUE constraint vs checking before INSERT

  I have a SQL server table RealEstate with columns - Id, Property, Property_Value. This table has ab…

  blasto_max

  3 replies

  12 years, 1 months ago

  By: Jeff Moden

• Columns in primary key

  I have a table where a combination of multiple columns define the business uniqueness. The table h…

  N_Muller

  5 replies

  12 years, 1 months ago

  By: N_Muller

• Max server memory

  I have a SQL2008R2 server that pretty consistently hogs about 47GB of the 48GB of RAM on the box. O…

  robin.pryor

  1 replies

  12 years, 1 months ago

  By: SQLRNNR

• Big transaction log file

  Hi, I found a sql server database with a transaction log file of 65 GB. The database is configured …

  cygne17_2 77208

  16 replies

  12 years, 1 months ago

  By: pietlinden

• Remove bad characters from nvarchar column

  We have some records that have a binary FDFF at the end of a nvarchar column. It shows up as a diam…

  Eric Palmer

  6 replies

  12 years, 1 months ago

  By: Eric Palmer

• When no match with table 2 then return customised row

  Hi I have two tables, let's call TEST2Patient p and TEST2ReferralKPIs r and the drop/create schema …

  mattech06

  2 replies

  12 years, 1 months ago

  By: mattech06