SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Querying NULL dates

  Is it redundant to write something like this in the where clause............? where AdmitDateTime i…

  NineIron

  4 replies

  9 years ago

  By: NineIron

• 'dbo' owning user-created database schemas

  Could someone help me understand why it is best practice for 'dbo' to own user-created database sch…

  adaml.hardman

  4 replies

  9 years ago

  By: Chris Harshman

• Aggregating from multiple join tables

  I have 3 tables: UserAccount LoanAccount SaveAccount The first is a joining table for the oth…

  Paul Tracey

  2 replies

  9 years ago

  By: Paul Tracey

• Securing Database

  Hi All I am using SQL 2008 R2, I am seeking your advice to secure my database from any types if ri…

  satish 61764

  10 replies

  9 years ago

  By: Grant Fritchey

• Can't restore differentials from backupset

  Hi All I can’t figure out why I can’t restore the differential backup.  I have verified that i…

  cathryn.crane

  3 replies

  9 years ago

  By: cathryn.crane

• How to take database backup between 2 dates (database partitioning)?

  Hi,i want to ask something regarding DB backup.Can we take backup of database backup between 2 date…

  saklanivijay87

  9 replies

  9 years ago

  By: Jeff Moden

• case when sum

  how can i sum into 1 row. total | menu1    | menu230    | chicken  | fish …

  girl_bj

  1 replies

  9 years ago

  By: Thom A

• SQL agent restart

  Hello Team, Our SQL instance was restarted couple of days back. Later we got to know that some…

  atulyan.aries

  3 replies

  9 years ago

  By: Thom A

• Problem with Linked Server Connection

  I have two servers that I am trying to link through a linked server connection. Server #1 is SQL Se…

  dobbie

  4 replies

  9 years ago

  By: curious_sqldba

• Table Function to show biggest increase

  Hi, I want to create a table function which will show when passing the RefNo it will return one row…

  SQL_Kills

  7 replies

  9 years ago

  By: SQL_Kills

• how to update gender = M or F in a table that has gender values as null

  Hi Any help on how to update gender = M or F in a table that has gender values as nullneed a random…

  db8

  9 replies

  9 years ago

  By: SQLRNNR

• Number of files in different filegroups

  Would there an advantage creating the same number of files (e.g. 8) for all filegroups of a databas…

  Johan Bijnens

  2 replies

  9 years ago

  By: Johan Bijnens

• Backup database to disk for insufficient disk space

  I am facing trouble for database full backup to my local disk as there is no sufficient space in an…

  mohan.bndr

  2 replies

  9 years ago

  By: Jeff Moden

• Need to set library for CREATE VIEW in EXEC @SQL script

  I have an EXEC @sql script which creates a view.Reason for the EXEC @sql script is that the libra…

  chas.1

  9 replies

  9 years ago

  By: chas.1

• Login is a dbowner of the database but not shown up as a user of the database

  We have a tech that need to install a vendor product tool , but the database need to be on one…

  sqlfriend

  1 replies

  9 years ago

  By: ScottPletcher