SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Can I use the same alias for different tables within one store procedure?

  Can I use the same alias for different tables within one store procedure? For example, does code be…

  adonetok

  3 replies

  15 years ago

  By: parthi-1705

• Regular Expressions in Find and Replace in SSMS?

  I have a table def I need to modify. I thought to myself, it sure would be nice if Find and Replace…

  Stamey

  4 replies

  15 years ago

  By: Stamey

• Error turning Varchar into Numeric

  Hi All. I am newish to SQL and I have seen a few similar posts but am still struggling. I am basica…

  jamesrichardadams

  2 replies

  15 years ago

  By: LutzM

• Intellisence not working via SSMS2k8 on SQL 2k8 SP1

  Hi All Was just wondering if anyone would know why intellisence would stop working? I have google'd…

  Ant-Green

  3 replies

  15 years ago

  By: Ant-Green

• Backup multiple databases concurrently

  Hello, can anyone tell me how SQL Server treats the backup of multiple databases simultaneously on …

  Marc Bonjean

  2 replies

  15 years ago

  By: Adiga

• showing stored procedure input arguments in sys.dm_exec_query_stats?

  I'm somewhat familiar with the DMV sys.dm_exec_query_stats that show SQL Server's query performance…

  kevin.wu

  2 replies

  15 years ago

  By: jude.pieries

• Upgrade SQL 2008 R2 CTP to SQL 2008 R2 RTM

  Hi , I have an issue that one of production box has SQL Server 2008 R2 CTP evaluation version and a…

  subbu_e

  8 replies

  15 years ago

  By: S. Kusen

• SQL Server 2008 R2 Developer Edition SP

  Does anyone know which is the latest SP for SQL Server 2008 R2 Developer Edition SP. I am copying a…

  salman788

  2 replies

  15 years ago

  By: S. Kusen

• Create index in table variable

  How to create index in table variable? The code below will get an error: declare @order table ( mem…

  adonetok

  8 replies

  15 years ago

  By: WayneS

• Find Trace IP

  Hi All, I am using online database... How do i trace the user system IP (Means :- some one use…

  saidapur_satish

  5 replies

  15 years ago

  By: saidapur_satish

• SQl Server 2008 Function Error

  I'm running a query like this select sum(signal_wait_time_ms) as signal_waits_time_ms ,CAST(100* (…

  @SQLFRNDZ

  4 replies

  15 years ago

  By: @SQLFRNDZ

• PCI - Payment Card Industry Compliance

  We all know highest level of PCI complaince (as far as DB part) can be acheived with SQL Server. T…

  Minnesota - Viking

  2 replies

  15 years ago

  By: SQLBalls

• Does a database restore eliminate file fragmentation?

  I will be moving databases to a new server by doing a backup and restore. I just wanted to confirm…

  sjs-36273

  1 replies

  15 years ago

  By: mrdenny

• insert data using dynamic open row set

  Hi all, i have 20 servers in each server we have sp with name ].[SP_SQL_Server_Info_HADB_ToReport]…

  syamala.popuri

  1 replies

  15 years ago

  By: Robert Klimes

• Data file not shrinking

  I brought a copy of our live DB down to our DEV server and have deleted a lot of data. This now lea…

  Casper101

  2 replies

  15 years ago

  By: shump66@yahoo.com