SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL 2008 Compressed Backups

  Was wondering if anyone is using the new backup compression features in SQL 2008 in production yet?…

  TheRedneckDBA

  49 replies

  15 years, 10 months ago

  By: Green Armchair

• 2 databases accessing 1 database?

  Hi everyone, Does anyone know if SQL 2008 can allow multiple databases to access one database? Wha…

  shahgols

  3 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• SQL Query help - Delete records based on above and below record values

  Hi I need a way to check the next and previous row values depending on another column value.. In th…

  danny09

  11 replies

  15 years, 10 months ago

  By: danny09

• Encryption at a database level on SQL Server

  Hi All, I need to know what options are available for doing encryption at a database level (similar…

  vamshi.sql

  1 replies

  15 years, 10 months ago

  By: Michael Valentine Jones

• how to store indexes separately from data on SAN?

  Scenario: Datawarehouse SQL Server 2008 Enterprise sitting on Windows 2008 Server Enterprise. I'm a…

  Sergei Zarembo

  1 replies

  15 years, 10 months ago

  By: Sergei Zarembo

• Find orphaned users in SQL Server 2008 after the upgrade from SQL Server 2005

  Hi, I have upgraded the SQL Server 2005 instance to SQL Server 2008 and I'm trying to find the orph…

  Mani-584606

  1 replies

  15 years, 10 months ago

  By: WayneS

• Move logins between SQL Server 2005 instance to SQL Server 2008 instance

  Hi, I'm upgrading SQL Server 2005 to SQL Server 2008 using side-by-side upgrade method and trying t…

  Mani-584606

  1 replies

  15 years, 10 months ago

  By: WayneS

• Schedule a job to generate a script

  We can generate a script for an object in SSMS manually. Is there any way to do it in a scheduled j…

  SQL ORACLE

  1 replies

  15 years, 10 months ago

  By: Steve Cullen

• Autogrowth leading to file fragmentation?

  sorry to start another thread on autogrowth but i need a quick answer (as usual)... i found some d…

  jsqldba

  4 replies

  15 years, 10 months ago

  By: Stefan_G

• Copying Table1 to Table2

  hi guys, can you give me some ideas how to do this? i have table1 and table2. i want to copy the co…

  monzulu

  5 replies

  15 years, 10 months ago

  By: Eugene Elutin

• invoke trigger 1'000'000 times?

  Hi all, here is a little example for my situation: At the beginning there is a "statistic" table wi…

  teutales

  1 replies

  15 years, 10 months ago

  By: spaghettidba

• Float field precision

  Hi, is it possible in SQL Server to set the precision of a float field to 2 digits? with no roundin…

  Elie Chedid

  1 replies

  15 years, 10 months ago

  By: Gail Shaw

• Litespeed DoubleClick Restore

  Hi, We are using Litespeed DoubleClick Restore for restoring backup files. When we try to do a rest…

  ganeshc27

  4 replies

  15 years, 10 months ago

  By: ganeshc27

• SSIS & Secure Sharepoint Connections

  Specs: Windows Server 2003 R2 x64 SP2 SQL Server 2008 10.0.2531 (64 bit) Visual Studio 2008 v9.0.30…

  Dirt McStain

  4 replies

  15 years, 10 months ago

  By: dinogas2000-sqlservercentral

• Trying to run an SSIS package in Visual Studio 2008

  Hi, I'm trying to run a SQL Server 2008 SSIS package in Visual Studio 2008 using Attunity 64bit to …

  asawyer 26423

  5 replies

  15 years, 10 months ago

  By: asawyer 26423