SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• mirroring

  we configured mirroring on the databases in our production environment ,as part of testing the ap…

  ramyours2003

  2 replies

  13 years ago

  By: Seraj Alam-256815

• Script to find specific schema_owner for all databases

  Hello, Do you know a script to find schema_owner for all databases ? I have this script but I can u…

  ERIC CRUDELI

  5 replies

  13 years ago

  By: ScottPletcher

• Using SET IDENTITY_INSERT with trigger

  Hi, I need to use SET IDENTITY_INSERT ON within a trigger query: ----------------------------------…

  pwalter83

  4 replies

  13 years ago

  By: pwalter83

• Index containing Where Clause

  Can an Index with a where clause be used to eliminate NULL values in the column and make the index …

  Bobby Glover

  3 replies

  13 years ago

  By: Bobby Glover

• Function To Add [n] Days to A Date and Adjust to the Nearest Business Date

  Anyone have a ready-made function that will add [x] number of days to a date and then adjust it to …

  david.holley

  18 replies

  13 years ago

  By: ChrisM@Work

• Help with "There is insufficient system memory in resource pool 'internal' to run this query"

  Hi Experts I am getting this error when Running SSID job please help Hi, We are trying to run an S…

  dba.sql29

  2 replies

  13 years ago

  By: Jack Corbett

• storing output of a Stored Procedure in a vairable

  Hi, I am inserting value in a table Gv_storeAllocation for column STNNo i have created a stored pro…

  kapil_kk

  3 replies

  13 years ago

  By: kapil_kk

• Script

  Script to find the all the db roles of all the users in all the databases in sql 2005\2008

  ramyours2003

  2 replies

  13 years ago

  By: Jack Corbett

• Aggressive Indexes

  Hi everyone. I used Brent Ozar's excellent sp_blitzindex script to discover the below issue. There…

  PHXHoward

  1 replies

  13 years ago

  By: Jack Corbett

• Language British

  I have one of dozen users who is getting the date in US format, this despite running a script to ch…

  andy.clark-651292

  7 replies

  13 years ago

  By: aaron.reese

• Need to change NDF initial size to reclaim disk space

  I've inherited a server with several databases, one which has 7 NDF files. The initial size for mo…

  mariann harper

  1 replies

  13 years ago

  By: Jack Corbett

• Returning datasets in groups of 3 in SQL

  I have a reporting services report that needs to generate multiple forms for the same report. Each …

  velemseni

  2 replies

  13 years ago

  By: velemseni

• Elimination of Table spools

  Whats the best way to eliminateLazy table spools as I have two in a particular query that I'm tryin…

  Jason-299789

  7 replies

  13 years ago

  By: ChrisM@Work

• MODEL database filesizes not being used

  Has anyone else noticed that the MODEL database filesizes and autogrowth settings aren't applied to…

  Philip Yale-193937

  2 replies

  13 years ago

  By: Vegard Hagen

• backup in Logshipping

  can we take full backup when the db is configurred logshipping ?

  ramyours2003

  1 replies

  13 years ago

  By: Gail Shaw