SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Win7, Two Monitors and SSMS

  I use two monitors, and IT just migrated me to Win7 (from XP). For some reason when I move from tyi…

  dwilliscp

  3 replies

  11 years, 3 months ago

  By: DeWayne_McCallie

• License connections - core or CAL license ?

  We are running SQL Server 2008R2 on a server performing a fairly isolated back-end application. It …

  alan.spillert

  3 replies

  11 years, 3 months ago

  By: Ant-Green

• Why aren't I seeing the number that I expect?

  Hi Everyone, I don't understand why I am getting all zeros after the decimal point below. I have …

  david.dartnell

  7 replies

  11 years, 3 months ago

  By: Priya004

• At a loss over performance of a TBF

  I have a complex table-valued function with multiple CTEs. When I run it as such: SELECT * FROM db…

  ccappel

  4 replies

  11 years, 3 months ago

  By: SQLRNNR

• Can a JOIN be used here instead of a UNION?

  Hi Everyone, I am in the midst of writing a report which shows the 'Total Sales', 'Gross Profit', a…

  david.dartnell

  4 replies

  11 years, 3 months ago

  By: david.dartnell

• Need some help with Server Side Trace.

  We have been having some issues almost everyday between 12:30AM and 7:00AM. Now I am given a task t…

  LearningDBA

  4 replies

  11 years, 3 months ago

  By: Grant Fritchey

• database locks up and the expanding tables in SQL Server Management Studio clear the problem

  I'm a newbie to this forum so please let me know if I posted this in the wrong place. Thanks. Weir…

  steveneashcraft

  7 replies

  11 years, 3 months ago

  By: Grant Fritchey

• Getting Profiler to Filter User Name

  I suppose I am not the first one who has ever run into this common problem, but I have not found an…

  Like2SQL

  2 replies

  11 years, 3 months ago

  By: MyDoggieJessie

• SSIS won't "spread" data into new fields

  I had an SSIS Package that took data from a flat file and moved it into a SQL Server table. It was …

  ppritts

  5 replies

  11 years, 3 months ago

  By: ZZartin

• Transaction Log Full

  I have a job that runs an ssis package. Its failing with the following error message. The recovery …

  dndaughtery

  3 replies

  11 years, 3 months ago

  By: Gail Shaw

• Operating System error 665 on SQL 2008 R2

  I am getting this error : Operating system error 665(The requested operation could not be completed…

  Grizzly Bear

  4 replies

  11 years, 3 months ago

  By: yup

• ID needs to be populated thru Trigger on the basis of input data

  I have a table and it contains company name,address and city information. I would like to generate …

  joduvil

  18 replies

  11 years, 3 months ago

  By: Sean Lange

• Data masking in SQL Server 2008 R2

  What is the best way to do Data masking in SQL Server 2008 R2? or use any 3rd party tools? Thanks,

  Mani-584606

  3 replies

  11 years, 3 months ago

  By: ygenchik

• populate missing dates and add 1 to column

  Hi, I would like to populate missing rows in a date sequence (per palstkid group) for a table and i…

  phingers

  13 replies

  11 years, 3 months ago

  By: Dwain Camps

• Simple looping problem

  I have a table with 3 relevant columns col 1 col 2 col 3 A date/timesta…

  fizzleme

  5 replies

  11 years, 3 months ago

  By: fizzleme