SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to Rollback an entire database?

  Hi, In the worst-case scenario where a critical bug has crept through QA, are there any software to…

  Richard McSharry

  13 replies

  16 years ago

  By: TheSQLGuru

• awe

  what is AWE, which scenario we have to use awe

  bala2

  7 replies

  16 years ago

  By: TheSQLGuru

• Store pdf's in database --- text, image, or filestream?

  We need to store several pdf files in our database. They are generally about 300K (or less) in siz…

  Barkingdog

  4 replies

  16 years ago

  By: Barkingdog

• How to avoid first part of the string and consider the rest of it?

  Hi All, I have a table with lakhs of records which can probably be grouped into some 25-30 groups b…

  malavika.ramanathan

  10 replies

  16 years ago

  By: ColdCoffee

• Binary data truncated

  When i am executing the below procedure i got the message String or binary data would be truncated.…

  EasyBoy

  1 replies

  16 years ago

  By: Carl Federl

• function help -

  here are the errors i am getting Msg 102, Level 15, State 1, Procedure fn_DateTime, Line 8 Incorrec…

  erics44

  3 replies

  16 years ago

  By: erics44

• service packs

  I am using SP3 for one applications,SP3 is already installed, in UAT, SP3 is not supporting for tha…

  bala2

  4 replies

  16 years ago

  By: gonzaga.laila

• Table Manipulation Help

  I have a table that I need to manipulate in a different way. I would ultimately like to re-write t…

  mbender

  3 replies

  16 years ago

  By: mbender

• handling null paramters in query

  Hi, I have written one parameterized query which looks like below - select * from table where Colum…

  HakunaMatata

  2 replies

  16 years ago

  By: Gail Shaw

• Unpivot

  I have a table like below: Emp ==== id name -- ----- 1 x now, i want the resuts in t…

  erajendar

  1 replies

  16 years ago

  By: LutzM

• Difference between cursors and while looping

  hello, what is the difference between cursors and looping(while looping) and which is better…

  sasi.tripuraneni

  5 replies

  16 years ago

  By: sasi.tripuraneni

• Query Search Server 2010 via stored procedure

  While this isn't specific to SQL 2008, our MS Search Server 2010 does use SQL 2008 R2, so perhaps s…

  Tim OPry

  1 replies

  16 years ago

  By: Tim OPry

• SQL server Interview Question

  hai, Can anyone post important SQL server interview question..

  jaffrey

  10 replies

  16 years ago

  By: GSquared

• Creating a Globally Unique ID without UNIQUEIDENTIFIER

  I need to generate a globally unique ID for a system I'm working on, but I want to avoid using UNIQ…

  samalex

  4 replies

  16 years ago

  By: samalex

• check strength of password on existing sql accounts

  I am looking for method to validate strength of SQL account passwords, without enabling password po…

  nynj.tech

  1 replies

  16 years ago

  By: GSquared