SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Path to a Database Architect

  Hi Guys, Would you please provide some links or books details to learn to become Database Architect…

  C.K.Shaiju

  13 replies

  13 years ago

  By: Jeff Moden

• Get resultset from query without running query.

  Is there some way to get the result set for a query without running the query? For example take th…

  jobrien9796

  6 replies

  13 years ago

  By: Erland Sommarskog

• Getting this error frequently on SQL Server Error 17832

  Hi Guys, Log Name: Application Event Type:Error Event Source:MSSQLSERVER Event Category:(2) Even…

  Saggy

  2 replies

  13 years ago

  By: Hemant.R

• SSMS Showing Create Object in Sprocs and Views

  Hello Everyone Happy Friday!! I have something rather odd happening in SSMS as of yesterday. I had …

  AndrewSQLDBA

  3 replies

  13 years ago

  By: AndrewSQLDBA

• sp_columns_ex With Link Server to AS400

  I am trying to extract data from an AS400 using SQL Server 2008 linked server. The following are t…

  Bradley Hardin

  1 replies

  13 years ago

  By: Erland Sommarskog

• Time difference

  Hi all, I have a rather basic question, but having difficulty.... I need to calculate the differenc…

  DaveDB

  8 replies

  13 years ago

  By: ScottPletcher

• sp_UpdateStats missing in database

  Hi We recently installed Lync at our company. Lync creates 4 SQL instances and I have set up mainte…

  TDP

  1 replies

  13 years ago

  By: Gail Shaw

• subtract mutlple rows from top row value

  Here is my sample data: order number, location, stop type, stop datetime, column i made pup =1, drp…

  tdanley

  5 replies

  13 years ago

  By: Alan Burstein

• Cumulative total column wise

  I have an issue where I need to count the cumulative total column wise effectively and could not ge…

  meghna.bhargav

  11 replies

  13 years ago

  By: Sean Lange

• Difference Between Restore And Attach

  What is the difference between Attach And Restoring a Database in Sql Server?Looks like a Simple qu…

  Anjan@Sql

  17 replies

  13 years ago

  By: Steve Jones - SSC Editor

• SQL server startup parameters

  Hi, i'm trying to find the startup parameters for sql server 2008 and 2005 using t-sql... for sql 2…

  Robin35

  4 replies

  13 years ago

  By: Robin35

• How to count ALL INSERTS for database for a period of time?

  Hi, Is a simple way to count all inserts for a given database for a period of time without using Da…

  Damian Calkins

  1 replies

  13 years ago

  By: MarkusB

• Database structure question

  I don't know the best way to structure my database. I have a data feed that comes in a CSV format, …

  g-m-l

  2 replies

  13 years ago

  By: Grant Fritchey

• Primary Key and Foreign key on the same column

  Good Day I did some investigation on the database system I inherited (SQL Server 2008 R2 with 2005…

  lianvh 89542

  5 replies

  13 years ago

  By: Grant Fritchey

• Imrort export wizard

  Hi, I am converting data from excel sheet to exixting table with diff datatypes in sqlserver but t…

  karunakar2351

  4 replies

  13 years ago

  By: HanShi