SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Importing excel file stored in sharepoint into SQL

  I have an excel file that is stored in a sharepoint document library. I am trying to use SSIS to im…

  Steve-443559

  4 replies

  9 years, 6 months ago

  By: chucklesthemilkmanmage

• Getting the username of the user from the program into a audittrail

  Hi!, I'm getting confused and I would like to ask for help, you see, I have this trigger alter TRIG…

  joshua 15769

  7 replies

  9 years, 6 months ago

  By: Eirikur Eiriksson

• SQL Server Database mail fails 'a recipient must be specified'

  Hi, I'm using SQL Server 2008 R2 SP2 Standard to send email using msdb.dbo.sp_send_dbmail stored pr…

  jcvv76

  8 replies

  9 years, 6 months ago

  By: Sue_H

• Add column value depending on other value in same row

  Hi All, I'm working on this for some time but ran into a dead end I'm afraid. So hope to get some h…

  Super_Grover

  9 replies

  9 years, 6 months ago

  By: Super_Grover

• Search string for matching pattern

  I thought this would be fairly simple but it has not been. I am using TSQL to search for a string …

  karen.ferrara

  4 replies

  9 years, 6 months ago

  By: drew.allen

• ranking query with nulls

  I have a table create table temp(Companyid varchar(10) not null,companyname varchar(100) not null,D…

  rash3554

  4 replies

  9 years, 6 months ago

  By: drew.allen

• Need Suggestion on How to work on Parsename command with dot or decimal?

  Hello, I need to divide the fields into four parts. Right now, parsename command is working 95% of …

  Tamrak

  2 replies

  9 years, 6 months ago

  By: Jeff Moden

• How to improve the efficiency of a conditional join

  If this has been answered before, please point me in the right direction; I'm just not sure what te…

  kyle.marvin

  3 replies

  9 years, 6 months ago

  By: kyle.marvin

• MAXDOP setting mystery in VM SQL performance .

  We have production issue going on , every day we run multiple instances of jobs to process reports …

  SQL Severe DBA

  5 replies

  9 years, 6 months ago

  By: SQL Severe DBA

• using MAX is working fine until I add QuantityShipped and then it gives every order and if the order did not have the item it gives 0

  I want to solve for every item I have I want to see when a customer last order a item, order id and…

  kat35601

  2 replies

  9 years, 6 months ago

  By: drew.allen

• How to get the previous weeks data based on week ending

  I need to get a weekly count of records with Friday being the end of the week. So, the report will …

  NineIron

  21 replies

  9 years, 6 months ago

  By: NineIron

• Alerting if table is empty

  Hi All, I am looking for a way to get an alert from SQL Agent if any table is empty in a database w…

  ramana3327

  2 replies

  9 years, 6 months ago

  By: RTaylor2208

• High lob logical reads on a query with just 2 simple tables

  /* Table1: NotificationType (NotificationTypeID INT PK Clustered, NotificationCriteria xml, TypeNam…

  Santhoshkumar KB

  8 replies

  9 years, 6 months ago

  By: Santhoshkumar KB

• Summary table for roll-up

  Hi, I'm working with a large table (70 mil rows, 100+ columns and growing) used in reports which ar…

  SvetNas

  7 replies

  9 years, 6 months ago

  By: SvetNas

• Backup database only if changes happen

  I have SQL2008 database with some 100s of tables. Every 2 hours transaction log backup to tape is t…

  Chandu-212374

  12 replies

  9 years, 6 months ago

  By: Wayne West