SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How do I join tables, but select top 1 from 1-many tbl?

  Essentially I have a Contact table and a History table. I'd like to get the join the tables, but on…

  Don.

  27 replies

  14 years ago

  By: ChrisM@Work

• Missing Index

  Hi I'm currently trying to dig around to tweak the performance of our database. One of the tasks b…

  Sarah 38992

  7 replies

  14 years ago

  By: Vegard Hagen

• Use of IIF function in Crystal Reports

  Dear All, I wish to know the use of IIF function in Crystal Reports with some exa…

  anandhaksc

  3 replies

  14 years ago

  By: demonfox

• Where clause on indexed column using a variable

  I have a SQL 2008 R2 table with a few composite indexes and a few single column indexes. I've narro…

  angel.wong 72408

  6 replies

  14 years ago

  By: Gail Shaw

• Need hep wtih a complicated aggregate

  Hello! I've been tasked with generating some data that seems like it's going to be quite challengi…

  Andrew Kernodle

  5 replies

  14 years ago

  By: Andrew Kernodle

• tool that can give the list of depricated features in sql 2000

  Hi All, we are in the process of upgrading our SQL servers 2000 (SP1) to sql server 2008 r2 version…

  mpalaparthi

  4 replies

  14 years ago

  By: mpalaparthi

• need help..cant understand how to approach

  Customer CustomerIDCustomerNameBirthdate 1John Doe1/1/1970 08:31 AM 2Jane Doe1/1/1971 01:18 P…

  WonderPra

  8 replies

  14 years ago

  By: Sean Lange

• Removing constraints for performance.

  First I consider constraints as safetybelts. I think constraints should be used as much as possible…

  ben.brugman

  6 replies

  14 years ago

  By: David Benoit

• System SP for Linking Excel file

  I'm trying to use a system SP for linking an Excel file to my Database... seems it bombs at the fir…

  DaveBriCam

  4 replies

  14 years ago

  By: Lowell

• Parsing out email address in FROM field

  Hello, Can someone please help me to trouble-shoot my query? Here is the scenario. I have FROM fie…

  vu_tran764

  19 replies

  14 years ago

  By: vu_tran764

• Conditional Formating

  I am trying to use this code, keep getting error. Can somone please help. =SWITCH(IIF(Fields!summar…

  deep_patel1

  3 replies

  14 years ago

  By: deep_patel1

• For improve performance of query

  hello i have one task in that , i prepare query to do data extract, but i takes longer time so i ne…

  yogi123

  1 replies

  14 years ago

  By: Sean Lange

• sql server 2008 Partitioning

  Unfortunately we have a very flat database(i.e. not normalized properly) and everything goes agains…

  ericwenger1

  1 replies

  14 years ago

  By: Jason-299789

• Create FTP Connection through script task in SSIS 2008

  Hi All, Please help. I'm new to SSIS 2008. I'm using the code below to FTP File, Question :- 1…

  playb_g

  3 replies

  14 years ago

  By: swetha859

• Business Intelligence - Training Center?

  I wanted to check if anyone has recommendations for training on Microsoft's BI tools. I can get the…

  DataAnalyst011

  1 replies

  14 years ago

  By: CecilChampenois