SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• can I safely use top n for select/delete in a while loop?

  Hi, can I safely use top n select/delete in a while loop? For example: declare @FieldVal int while…

  sqlguy-736318

  13 replies

  11 years ago

  By: Matt Miller (4)

• how to audit sql server

  hi, my sql server version:sql server 2008 r2. if keep all the records, i think it may lead to perf…

  owen_zeng

  1 replies

  11 years ago

  By: Sean Lange

• techniques for ensuring isolated temp table scope?

  Hi, what are some common techniques for ensuring an isolated temp table scope? For example, if 2 d…

  sqlguy-736318

  3 replies

  11 years ago

  By: Gail Shaw

• Fully Dynamic Partition Switching

  Hi I'm curious, has anyone ever had to script fully dynamic partition switching? To elaborate the …

  Andy Hyslop

  5 replies

  11 years ago

  By: Andy Hyslop

• shortcut for table variables?

  Hi, are you aware of any shortcut strategies for table variables similar to shortcut strategies for…

  sqlguy-736318

  7 replies

  11 years ago

  By: Jacob Wilkins

• any way to see table variable data in the ssms debugger?

  Hi, is there a way to see the data of a table variable in the SSMS debugger? For example, if I set…

  sqlguy-736318

  1 replies

  11 years ago

  By: Jacob Wilkins

• Best way to add columns to table type

  Hey all, Is there a good way to add columns to a table type? I built several procs which make use …

  Xedni

  11 replies

  11 years ago

  By: ScottPletcher

• list store procedures contents

  Hi, who i can to list the content of all store procedures and funtions in text file ? Thanks flor y…

  elkinfortiz

  3 replies

  11 years ago

  By: Justin Manning SA

• Relational database - rarely more efficient to store snippets of non relational data against a record - thoughts?

  Hi Is it fair to say that as much as you would want a relational database there are rare occasions …

  Hughesy

  16 replies

  11 years ago

  By: Grant Fritchey

• Grouping by records that are already grouped.

  I have results from a query that have anywhere from 1-4 results. I have a subid of 1-4 which is gro…

  brody.rathman

  1 replies

  11 years ago

  By: WayneS

• trying to enable ss 2008 for debug

  Hi, I'm trying to use the debugger within SSMS but when I hit the green arrow in the IDE, SSMS pops…

  sqlguy-736318

  2 replies

  11 years ago

  By: sqlguy-736318

• getdate() from SQL 2008 to smalldate colum on a table in SQL2005

  Hello, Anyone know if this is a bug that we can't insert getdate() value from SQL 2008 R2 to a smal…

  Biank

  4 replies

  11 years ago

  By: Biank

• Backup compression (1st timer)

  I am wanting to use backup compression on a few sql servers (2008R2 and 2012). I have never touched…

  Jay@Work

  4 replies

  11 years ago

  By: Jay@Work

• TempDB size hovering around 45%

  Hi experts, my prod server(only default instance) is configured TempDB 1024 MB data and Log 200MB. …

  Tac11

  6 replies

  11 years ago

  By: Tac11

• Database Mail issue

  On a test instance of sql, I have a sql server login UserX that is a member of the DatabaseMailUser…

  crystal.hoffman

  4 replies

  11 years ago

  By: crystal.hoffman