SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Bad Behavior Creating Stored Procedure

  In our of our recent install scripts was the following statement. Note that there is no GO stateme…

  souLTower

  4 replies

  11 years ago

  By: souLTower

• Turn Field Values into Coma Separated List

  Hi I'm hoping somebody has a slick sql trick that can show me. I have about 100 K records of the f…

  scotsditch

  2 replies

  11 years ago

  By: WayneS

• script to list all database level permissions in a Database

  I found this script online.. SELECT prin.[name] [User], sec.state_desc + ' ' + sec.permission_name…

  Jpotucek

  7 replies

  11 years ago

  By: Jeff Moden

• SQl DBmail problem

  HI All I have configured Sqlserver DBmail in using Gmail,yahoo SMTP server.But I cant able…

  vs.satheesh

  4 replies

  11 years ago

  By: Lowell

• Can I display all the days in a range even with no data ?

  Hi I need to display all the dates within a range even with no data for example right now my query…

  jbalbo

  22 replies

  11 years ago

  By: Jeff Moden

• Data typeof calculated fields

  I'm using the SQL below to work out recruitment figures. The query works well, but I now need to bu…

  M Joomun

  5 replies

  11 years ago

  By: M Joomun

• Performance query issue leading to Timeout

  I have attached query which is having performance issue and its actual execution plan with is takin…

  ramrajan

  2 replies

  11 years ago

  By: Grant Fritchey

• Opinion on automated Deployment to Production

  Hi everyone, I thought I'd poll everyone's opinions and experiences on this subject. How does the g…

  sqlsurfing

  4 replies

  11 years ago

  By: Jayanth_Kurup

• please help me: select is verry slow from table 5 milion record

  Dear all, i having isue is when i select data form my table took more than 10 seconds to get resul…

  mrtran0404

  21 replies

  11 years ago

  By: ChrisM@Work

• Prep for large increase in usage

  Hi all, We have a big ol' increase in users coming in these next few months, so far our systems can…

  JaybeeSQL

  18 replies

  11 years ago

  By: JaybeeSQL

• SSIS Load Data -capture Error

  Hi, Good Morning All, I am having a file with the customer information stored , it may be in xml, x…

  yuvipoy

  10 replies

  11 years ago

  By: Alvin Ramard

• Error while processing the cube in SSAS 2008

  Hi Friends, i am getting the following error when i am processing the cube in SSAS 2008 Errors in…

  satish.banda

  10 replies

  11 years ago

  By: Anthony Robinson

• Perform checksum based on the source table data

  Hello All, I'm trying to load data from old SQL server 2000 to new SQL server 2014. I need to do a …

  SSRS Newbie

  2 replies

  11 years ago

  By: sgmunson

• Comparing a column between two tables with a wildcard

  I have a table containing records of criminal convictions. There are over 1M records and the only …

  j.kalkowski

  5 replies

  11 years ago

  By: Eric M Russell

• Query to generate the report of locked account

  Hi, Just wondering if there is any query which can give me report of locked account in SQL 2008. I…

  crazy4sql

  5 replies

  11 years ago

  By: pradip patil