SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• LOB data keeps growing and growing...

  Hi everyone -- Would really appreciate any feedback on this problem. First I wanted to say that no…

  sqlnyc

  7 replies

  11 years, 3 months ago

  By: sqlnyc

• Issue with CTE

  Hi all. I'm having trouble with a reference to a CTE not working in an update statement. here are m…

  smw147

  1 replies

  11 years, 3 months ago

  By: Luis Cazares

• SPACE() And Manual space i.e (' ')

  Hi, Wanted to know the reason, why manual space between two string doesn't work at certain point bu…

  farooq.hbs

  1 replies

  11 years, 3 months ago

  By: Sean Lange

• Insert / Update / Delete them from another DB Instance

  I have the following situation , the SRV - APP03 , source database ( MP - OFC ) with a sb2010 table…

  jleeestevam

  1 replies

  11 years, 3 months ago

  By: Sean Lange

• Cluster query

  Hi, I just wanted to know, at what stage of the windows cluster setup are Quorum and MSDTC created?…

  navtec

  1 replies

  11 years, 3 months ago

  By: Perry Whittle

• Connection setting between two SQL server to access a different database

  Hello I have a question. In SQL server, we can access a table or view in a different database by u…

  kmittal

  1 replies

  11 years, 3 months ago

  By: HanShi

• Importance of RAM for SQL Server 2008 (does bus speed matter?)

  I know SQL Server 2008 needs RAM. When it comes to cost, I think the bus speed is unimportant. I …

  Maintainer

  6 replies

  11 years, 3 months ago

  By: Perry Whittle

• Amend function to include time values

  Hi, I need to customize an existing function to also include time values. The current function only…

  pwalter83

  21 replies

  11 years, 3 months ago

  By: pwalter83

• Query to compare two databases

  Hi, Need a query to compre two database schemas. I have seen lot of comparision tools but need a qu…

  Priya004

  5 replies

  11 years, 3 months ago

  By: sqlsurfing

• Adding new range / Partition at the end

  We have designed partition with BIGINT range. of 1 millions each of 10 millions of ID. If I get new…

  vkundar

  5 replies

  11 years, 3 months ago

  By: dbafromthecold@gmail.com

• check column exist or not if not exist assign null values for that column

  Hi Friends i have small doubt in sql wheil load data from one table to another table i faced one is…

  asrinu13

  1 replies

  11 years, 3 months ago

  By: Vimal Lohani

• Find weekdays between 2 dates

  Hello, I need to find all of the weekdays between a date range. For example, if I pass in 09/18/201…

  Lord Slaagh

  7 replies

  11 years, 3 months ago

  By: Luis Cazares

• TSQL SCRIPT

  Hi All, I have this script which helps me to know my last restore date on my database. My database …

  eobiki10

  2 replies

  11 years, 3 months ago

  By: eobiki10

• [Help] Is there any quick way to tell if an object is a table or a view?

  I am working on a project where the naming conventions are not strictly followed. Developers have u…

  Blue Mancunian

  5 replies

  11 years, 3 months ago

  By: thomashohner

• Calculating 30 days of each month

  Hello everyone, I am trying to create a report that shows how many accounts have been payed in the …

  waseemshaikh345

  7 replies

  11 years, 3 months ago

  By: waseemshaikh345