SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Query to find the size of each row in a table

  Hi, Is there any query available to find the size of each row of a table? Thanks.

  SQL_Hunt

  3 replies

  11 years, 10 months ago

  By: Sean Lange

• Restriction on DML Statements in SSMS

  Hi, I would like to know if there is any option to Restrict DML statements in SSMS for a user where…

  krishna.dhara

  4 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Backup Differential

  When doing a differential backup, is it better to save to a new file or use the full backup file? I…

  djj

  3 replies

  11 years, 10 months ago

  By: djj

• Setting dynamic filters for dropdowns

  Hi, I have a gridview and a dropdown filters in the page. Also I have a date column in gridview whi…

  vigneshkumart50

  6 replies

  11 years, 10 months ago

  By: vigneshkumart50

• Transport-level error referring to "network name is no longer available" - but not referring to name...

  Hi All, I'm continually getting the following error condition from a C#.NET 4.0 console application…

  SystemlordAnubis

  1 replies

  11 years, 10 months ago

  By: Perry Whittle

• Not able to open ssis pacakge

  Hi All , Am trying to open ssis packge but it is giving error saying "There were errors while the …

  ravi@sql

  2 replies

  11 years, 10 months ago

  By: rhythmk

• how to see discarded job history

  Hi All, Is there any way to see discarded job history ? Because I am not able to see the history of…

  Akayisi

  4 replies

  11 years, 10 months ago

  By: amna.asif

• Calculate elapsed time in transaction statement

  Hello everybody, Is it posible to know the elapsed time after I execute a transaction statement in …

  rsoria.03

  3 replies

  11 years, 11 months ago

  By: arnipetursson

• Indicator to remain in one cell

  In SSRS, I have a drill down report with three columns. One column says 'yes' or 'no.' The other c…

  giszzmo

  1 replies

  11 years, 11 months ago

  By: Sean Lange

• Sample Databases like Adventure works

  Hello folks, Does anyone know of any other sample databases other than adventure works for some tra…

  a4apple

  2 replies

  11 years, 11 months ago

  By: a4apple

• Calculate average through recursive CTE

  I am new with CTE and need help from you guys. I have a table FeedFileDetails which stores all the …

  anujjasoria

  13 replies

  11 years, 11 months ago

  By: anujjasoria

• Distribution of data, percentile curve.

  Dear Reader, Fan: Of Percentile curves in Excel. This presents in Excel a value (or a count of valu…

  ben.brugman

  4 replies

  11 years, 11 months ago

  By: J Livingston SQL

• Adding parameters to SQL in Excel

  Hello All, I have excel spreadsheets that I use to connect to SQL Server by ODBC for my end users. …

  RazorbackDBA

  3 replies

  11 years, 11 months ago

  By: Greg Edwards-268690

• Error when opening BIDS 2008 R2 - SQL Server 2008 R2 - Urgent

  Hi, from two days when I launch BIDS 2008 R2 I've an error that says it isn't possible to find one …

  pmscorca

  9 replies

  11 years, 11 months ago

  By: David Burrows

• Stopping a check integrity DB job what will happen?

  Hi friends, i have a huge datawarehouse DB (750 GB) with 30 tables, i have never run maintenance pl…

  rajsin7786

  9 replies

  11 years, 11 months ago

  By: Grant Fritchey