SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Question: Teasing apart a bit-field and storing the results in table rows

  I am developing a system that has hardware devices in the field, with each hardware device having a…

  Gerry Roston

  4 replies

  11 years, 1 months ago

  By: Sporidium

• Difference between Money and (Float or Decimal) Datatype

  What is the difference between Money and (Float or Decimal) Datatype. If we use Float or Decimal i…

  nagesh.prasad

  4 replies

  11 years, 1 months ago

  By: Koen Verbeeck

• AUTOCLOSE OPTION in database

  Hi All, One of the servers in my company using SQL Express and the Autoclose option for user databa…

  WhiteLotus

  5 replies

  11 years, 1 months ago

  By: WhiteLotus

• Add calculated row item - SQL 2008

  I need to add a calculated column item in the same column. Please see SQL Codes for both existing d…

  helal.mobasher 13209

  11 replies

  11 years, 1 months ago

  By: Luis Cazares

• No. of Offline Databases

  Hi there .. I am using this query to find out the database name and when the last time that offlin…

  fawad.majid

  4 replies

  11 years, 1 months ago

  By: John Mitchell-245523

• Back Up a warm standby

  We have a hosted app where the vendor agreed to send us the database via Log Shipping. We want the…

  Randy Doub

  1 replies

  11 years, 1 months ago

  By: Gail Shaw

• how can i get latest records from the below table

  I have a table where i am inserting into temp table ,i mean selecting the records from existing tab…

  mcfarlandparkway

  1 replies

  11 years, 1 months ago

  By: Gail Shaw

• grant access to all databases

  hello experts, i have around 600 databases in my server, a user need select access of …

  Zeal-DBA

  8 replies

  11 years, 1 months ago

  By: pmaceke

• Extract Value from XML Column

  Hi I have table Called as ‘DC_BIL_ActivityLog’ and XML column name is ‘ActivityDescription’ in SQL …

  maruthasalam

  8 replies

  11 years, 1 months ago

  By: Jeff Moden

• Convert RGB color to HEX Color using SQL

  Hello all I have a field in one of my tables that has the RGB colors stored as 255,255,255 format. …

  thomashohner

  34 replies

  11 years, 1 months ago

  By: mister.magoo

• Assitance in Union and Groups

  Hi I have a sql query that lists the pay records(time entries) for the employee by Pay Period ID. I…

  shezi

  12 replies

  11 years, 1 months ago

  By: shezi

• SQL choosing to use the worst possible index

  Hello All I have a box with SQL Server 2008 R2, at the latest SP and CU, 16 cores and 196gb of ram …

  ricardo_chicas

  25 replies

  11 years, 1 months ago

  By: ricardo_chicas

• Can some one explain this behavior i'm seeing with windows function and update

  Hello all, I have some strange behavior I am noticing when trying to use ROW_NUMBER() with a UPDATE…

  thomashohner

  2 replies

  11 years, 1 months ago

  By: thomashohner

• Management Studio Connection Problem

  Dear, I am facing a problem of connecting SSMS using server name. When I use IP address, it connect…

  shohelr2003

  2 replies

  11 years, 1 months ago

  By: vincyf1

• Data types and row size question

  if I have a table with these columns: ID (uniqueidentifier) Create_date (Nvarchar 100) Created (nva…

  Dan121

  7 replies

  11 years, 1 months ago

  By: Grant Fritchey