SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How do you create a Unique Contraint on non-null values only?

  I have a table, created by a third party product. I want a unique constraint on a column, but only…

  Tom257

  5 replies

  14 years ago

  By: Tom257

• Assigning values using CASE statmenent

  Dear Experts, I have the following fieldnames: CheckNumber, CheckAmount, CashAmount We have a requi…

  simflex-897410

  7 replies

  14 years ago

  By: simflex-897410

• How to put contraints on dates and attributes?

  From the query below, I wanted to pull out just two attributes of the students (sgrsatt_atts_code) …

  todinhkhoi

  2 replies

  14 years ago

  By: todinhkhoi

• Query for multi level dependencies

  Hi all, create table #temp ( ID int ,IntroducerID int ) insert into #temp select 1,1 union all sel…

  Nagaram

  1 replies

  14 years ago

  By: Sean Lange

• SQL 2005 Max Memory Setting on Cluster

  Hello, I have an argument with a Windows SA about these settings, and I would like ask the communit…

  MiguelSQL

  14 replies

  14 years ago

  By: SpringTownDBA

• Will Pivot Table work in this scenario

  Hi Guys, I have a table called Invoice. It has fields like InvoiceNumber varchar(50), InvoiceDate D…

  niteshrajgopal

  12 replies

  14 years ago

  By: niteshrajgopal

• Alternative Solution ForDBCC UpdateUsage

  from Google i come to know that whenever we get the negative unallocated size if we run the DBCC up…

  kumarreddy72

  9 replies

  14 years ago

  By: EdVassie

• Can index metadata identify candidate keys?

  I have landed a brand new table named LabData. It has a sequence number that is the pk, but i can s…

  drew.georgopulos

  2 replies

  14 years ago

  By: drew.georgopulos

• xp_sendmail error...

  All, I am getting the following error I try to execute: EXEC master.dbo.xp_sendmail @recipients …

  Benjamin Shelton

  8 replies

  14 years ago

  By: nikk_Stone

• Better Query instead of loop

  I have to get the average for open tickets during each month for the last 12 months. First I have t…

  uciltas-924976

  25 replies

  14 years ago

  By: uciltas-924976

• SQL Date format

  Hello, this is my first post to the forum 🙂 Anyway, I would like to ask you how can I convert a dat…

  preciolandia

  2 replies

  14 years ago

  By: preciolandia

• How can i read this XML

  Hi I want to read the below xml and take the attribute value tag value in some parameter.please Hel…

  vineet.bhargava

  3 replies

  14 years ago

  By: LutzM

• Strange SQL Server Evaluation of 0 (bit) = '' (Empty string) or even non empty string

  Hi, I am getting a very strange sql server evaluation. I have a table with bit columns with nulls …

  andy.fensham

  11 replies

  14 years ago

  By: andy.fensham

• WHAT IS - The Fastest Method For Removing Available Space In A Data File (SQL 2005)

  What’s the fastest method in SQL Server 2005 to shrink the available space in the data file to as s…

  YSLGuru

  8 replies

  14 years ago

  By: YSLGuru

• UDF Works with literal value but with Dynamic Values

  I know this shoudl work because I found it on a TSLQL Help site were several talked about it and I …

  YSLGuru

  5 replies

  14 years ago

  By: YSLGuru