SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to find who changed the database to Single_user mode.

  Hi All, One of our databases changed to single_user mode. But we could not find the exact user, ho…

  Varun R

  2 replies

  12 years, 10 months ago

  By: Megistal

• Stored Procedure is not responding, i am executing but does nothign and donot execute

  I am getting error message when i run SP at the bottom Error Msg: Msg 2714, Level 16, State 3, Proc…

  huum

  5 replies

  12 years, 10 months ago

  By: ChrisM@Work

• help with joining to table with non unique index and duplicate rows

  Hi, I have the below query to join several tables, and retrieve customer data: select sv.SVSEQ, sc.…

  plivingstone

  5 replies

  12 years, 10 months ago

  By: plivingstone

• SQL Varchar(max)

  Hi Team, In sql server 2008R2, what is the max characters for Varchar(max). i've declared a variabl…

  Minnu

  4 replies

  12 years, 10 months ago

  By: Eugene Elutin

• Days Since Last Backup

  Hi How to calculate Days since last Backup

  christo83

  1 replies

  12 years, 10 months ago

  By: Koen Verbeeck

• How to do tempdb utilazation??

  How to do tempdb utilazation in mssq; server ?

  sqldbaonly

  3 replies

  12 years, 10 months ago

  By: Erland Sommarskog

• Transposing two rows of data to one row

  I have a large table of 2m records and I need to combine every two Document No_ to one row and plac…

  alanshawkat

  2 replies

  12 years, 10 months ago

  By: alanshawkat

• tempdb file delete

  ALTER DATABASE tempdb MODIFY FILE (name=tempdev,size=512MB); GO ALTER DATABASE tempdb ADD FILE (nam…

  sqldbaonly

  2 replies

  12 years, 10 months ago

  By: sqldbaonly

• Find out Free Virtual Memory

  Hi How to find out free virtual memory size by sql query

  christo83

  2 replies

  12 years, 10 months ago

  By: psingla

• I want deadlock notification using mail address and record stored in table.

  I want deadlock notification using mail address and record stored in table for mssql

  sqldbaonly

  4 replies

  12 years, 10 months ago

  By: Erland Sommarskog

• how do i select previous date using ssis expression?

  hi i have ssis package and following expression which gives me todays date and time for file name @…

  ashuthinks

  8 replies

  12 years, 10 months ago

  By: ashuthinks

• sqlquery

  which is the programmer develope highest number of package.i have atablre which contain pname,tit…

  mraja617

  1 replies

  12 years, 10 months ago

  By: Koen Verbeeck

• Return Empty is a specific record is encontered.

  Hi all, This seems to be very easy (and probably is!!) but I'm just stuck here. I have a table that…

  FastRider30

  2 replies

  12 years, 10 months ago

  By: Dwain Camps

• Can this be coded better?

  My goal is to get a dataset of orders with their overall statuses. The order overall status is a co…

  Coriolan

  6 replies

  12 years, 10 months ago

  By: Dwain Camps

• Retrieve the TOP 10 Elapsed time (query)

  Hi , Someone can give me a script that return the top 10 sql queries based on elapsed time for the …

  OracleBoy

  6 replies

  12 years, 10 months ago

  By: Luis Cazares