SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Accumulate Hours and Generate finish date

  Hi, I am wotking on work performed in a day create the day when it will finish. considering 8 hrs i…

  Sandeep Saretha

  2 replies

  15 years ago

  By: Sandeep Saretha

• Split delimited column values into multiple rows

  I'm trying to use the query found here http://www.eggheadcafe.com/software/aspnet/31741612/split-co…

  Aaron Prohaska

  4 replies

  15 years ago

  By: Evil Kraig F

• Last time a user was connected

  Is it possible to find out when a user was connected last time?

  DBABC

  3 replies

  15 years ago

  By: Adiga

• Adding a count in cross tab data

  There is a table showing below: A--B--C--D--COUNT X--X---------2 ------X------1 ------X--X---2 X--X…

  adonetok

  1 replies

  15 years ago

  By: LutzM

• Sales quantities columns month

  Hi everyone!!! I have a very large sales data and want to represent it in month columns. Table is l…

  LuisSurf

  5 replies

  15 years ago

  By: LuisSurf

• MapPoint with non-spacial data

  Our system stores customer addresses with street, city, state, and zip, but would this be sufficien…

  samalex

  2 replies

  15 years ago

  By: eric.frost 26025

• ranking functionality in SQL 2000

  Hi, I have used ROW_NUMBER() ranking function in a procedure (SQL 2008) for filtering purpose. Now …

  vinoth-750003

  6 replies

  15 years ago

  By: Dave Ballantyne

• SSMS shows is Busy when right clicking on the Instance Name

  Hi Everyone, Recently I installed SQL Server 2008 R2 on Windows 2003. In SSMS, whenever I right cli…

  dias__84

  3 replies

  15 years ago

  By: dias__84

• Job Scheduling

  I have a job that is now approaching 20 steps. If I were to place each functionally grouped set of …

  Sioban Krzywicki

  14 replies

  15 years ago

  By: Jeffrey Williams

• seeing failed rows from bulk insert

  I have a text file containing millions of rows in a CSV-like format. Ordinarily I'd do a bulk inser…

  e1785

  3 replies

  15 years ago

  By: Evil Kraig F

• SAN disk configuration

  I am in the process of configuring a new SAN for a SQL Server. I am going to use RAID 10 for all r…

  sjs-36273

  1 replies

  15 years ago

  By: Evil Kraig F

• SQL 2008 R2 installation failed on WIN 2008 R2

  Hey, I am trying to install SQL 2008 R2 on top of WIN 2008 R2 using IBM X 350 M2 servers but I a…

  amro.idrees

  1 replies

  15 years ago

  By: steve smith-401573

• Single vs Dual partition

  Palnninga new SQL 2208 box. Current DB size is 2 Gigs, the max i would project its growth to be 20…

  Minnesota - Viking

  4 replies

  15 years ago

  By: Robert Klimes

• Should DBAs allow UNSAFE SQLCLR Assemblies in production environment?

  In our environment we have several SQL-CLR assemblies that have been deployed with UNSAFE permissio…

  Marios Philippopoulos

  7 replies

  15 years ago

  By: GSquared

• Database conversion from one server to another in SQL Server 2005

  Hi All, I'm in the process of converting a database in an existing server to another existing serv…

  mashikoo

  4 replies

  15 years ago

  By: mashikoo