SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Edition Upgrade from 2008 R2 Express to Workgroup Edition, 10 GB limit

  Hi all, I have a customer that has run into the 10 GB limit of SQL Server 2008 R2 Express. We saved…

  gerhard.hofmann

  1 replies

  14 years, 1 months ago

  By: CapnHector

• sql small discusion

  1)what is covering index?when we use in sql servr? 2)what dynamic management view and when we use …

  asranantha

  6 replies

  14 years, 1 months ago

  By: Jared

• Dynamic CoulmnName in Select with assignment

  Hello, Please edit the following line and explain what is the problem Declare @MyColumn nvarchar(5…

  Mando_eg

  14 replies

  14 years, 1 months ago

  By: Mando_eg

• Huge amount of index_size and unused in syscolpars

  Hi, I'm hoping if you can help me. I'm reviewing a SQL2008 database that had over 1 million views c…

  Steve Smith-163358

  5 replies

  14 years, 1 months ago

  By: Gail Shaw

• Rewriting with NON ANSI

  abcdefghijklm

  ramrajan

  1 replies

  14 years, 1 months ago

  By: Eugene Elutin

• Suggestions for a very long transaction

  Hi I have a web application in .net which is used for movie ticket booking. There are around 12 tab…

  S_Kumar_S

  28 replies

  14 years, 1 months ago

  By: Dwain Camps

• Need help for joining 3 tables with Group By

  Hi all, I have a requirement where I have to show the data’s in a grid from 3 different tables from…

  abivenkat

  4 replies

  14 years, 1 months ago

  By: vinu512

• Help in Getting Closing Balance from Opening balance

  Hi all, create table Opening([Date] date,item_id int,location_id int,qty int) Insert into Opening S…

  GuruGPrasad

  2 replies

  14 years, 1 months ago

  By: vinu512

• Query to obtain Ratio to parent

  I want to calculate ratio to parent for a table named Level1Level2 with this values: Level1Level2…

  antonela

  3 replies

  14 years, 1 months ago

  By: Dwain Camps

• Compare two tables and return result

  Hi All, Im curious if this can be done and if it can what would be the best way to achieve it, I ha…

  .Netter

  31 replies

  14 years, 1 months ago

  By: vinu512

• sql discusion

  Hi friends, i have small doubt in sql plz tell me supose 1st table data like billno, amount…

  asranantha

  2 replies

  14 years, 1 months ago

  By: vinu512

• Best Books for Development

  fg

  ak08

  6 replies

  14 years, 1 months ago

  By: Koen Verbeeck

• Procedure

  How to create a dynamic procedure to insert multiple data into two or more tables

  arddd1

  2 replies

  14 years, 1 months ago

  By: vinu512

• index basic

  hi all i am very new to sql, i cant understand many things especially INDEX concept.please give …

  selvakumar.sms

  2 replies

  14 years, 1 months ago

  By: vinu512

• An Integration Services class cannot be found - How to resolve

  Hi, I am using SQL Server 2008 R2 I have created an SSIS package and executing it thr asp.net a…

  rvasanth

  9 replies

  14 years, 1 months ago

  By: vinu512