SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SPLIT RANGE TOOK 10 HRS to Complete

  Hi All, I just split the Range (introduced new range) of my existing Partition Function but it took…

  Ramdas

  4 replies

  13 years, 5 months ago

  By: ScottPletcher

• Truncate Log File

  Hello Everyone I need to truncate Log File. but right now, someone importing data into table. and h…

  yogi123

  1 replies

  13 years, 5 months ago

  By: Gail Shaw

• How to know the latest SQL Server R2 update

  Hi, This is my current version: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 20…

  APA0876

  1 replies

  13 years, 5 months ago

  By: JeremyE

• how to extract value from showplan_xml?

  Hello - "set showplan_xml on" can be used to output the query plan of the current query. I know tha…

  sqlguy-736318

  3 replies

  13 years, 5 months ago

  By: Gail Shaw

• SQL Server 2008 Service SIDs

  Hello, This is just a quick question about the security changes in SQL Server 2008. In 2005 during …

  dbafromthecold@gmail.com

  3 replies

  13 years, 5 months ago

  By: Eric Stephani

• SSRS Save file to folder (Windows File Share) with date as prefix to filename

  Hello - I am creating several reports. Each report runs daily and a team uses each of the reports …

  tammyf

  3 replies

  13 years, 5 months ago

  By: kevin.unglesbee

• query implem

  hi friend i have a small doubt in sql plz tell me how to solve How to find (calculate) median usin…

  asranantha

  1 replies

  13 years, 5 months ago

  By: imex

• Best way to implement partitioning

  I have my own idea on how to handle this, but want to se if there is a different perspective on thi…

  OmegaZero

  26 replies

  13 years, 5 months ago

  By: OmegaZero

• A problem with using full text search with wildcard query

  Hi, I have a weird case with the full text search in Sql Server 2008 R2 SP1 web edition. I have a t…

  eranzo111

  2 replies

  13 years, 5 months ago

  By: eranzo111

• LIKE with and without wildcards in WHERE clause

  I have a set of pretty well tuned queries with indexes and all the appropriate trinkets. This is a …

  pdanes

  25 replies

  13 years, 5 months ago

  By: pdanes

• HOw do I update the another field of table which is not effected by Bulk Insertion .

  HI Friends We want to bulk insert into table table1 Create table table1 { ID, ProjectID, Fname } Cr…

  vikrantkale18

  1 replies

  13 years, 5 months ago

  By: Ant-Green

• Regard to SQL Version

  I have to SQL Server and one has version, Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) J…

  bubby

  1 replies

  13 years, 5 months ago

  By: Ant-Green

• Concatenation of strings with condition check,,,

  hi Team, Need your help............. My table contains below columns with values. ColAColBColCCo…

  Minnu

  4 replies

  13 years, 5 months ago

  By: Sean Lange

• Creating a Stored Procedure that accepts parameters

  Err

  nzu8946

  10 replies

  13 years, 5 months ago

  By: Sean Lange

• Run a Query on a Database Restore

  Hi, I'm looking for how I can have a query run against a database when it is restored. Basically, I…

  lisa_stlaurent

  3 replies

  13 years, 5 months ago

  By: Grant Fritchey