SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help with Data type and size of the each row!!!!!!

  In my database there is a big table and format is something like this: CREATE TABLE [dbo].[MyTable]…

  Tac11

  11 replies

  11 years, 1 months ago

  By: Jeff Moden

• turning complex query into temp tables

  Hello, do you have a general rule of thumb for breaking a complex query into temp tables? For someo…

  sqlguy-736318

  26 replies

  11 years, 1 months ago

  By: xsevensinzx

• Size of Data Roadblocks

  Hello! I'm starting to hit some roadblocks with my SQL Server due to the sheer amount of data I am …

  xsevensinzx

  24 replies

  11 years, 1 months ago

  By: xsevensinzx

• Pivot Function

  Hi I've managed to use the pivot function using the code below which gives me the following output:…

  ByronOne

  7 replies

  11 years, 1 months ago

  By: ByronOne

• Changing Order by

  I want to change my order by... @Sort_Option... Is there any way to do this .... except by Dynamic …

  dwilliscp

  6 replies

  11 years, 1 months ago

  By: dwilliscp

• Database in single-user mode; how to change it programmatically ?

  Recently we had multiple production failures because one database was in single-user mode. I am try…

  SQL Guy 1

  5 replies

  11 years, 1 months ago

  By: Jacob Wilkins

• INSTEAD OF trigger on a view

  I have a view made up of a few base tables and another view. I have created an INSTEAD OF trigger o…

  sKreetz!

  3 replies

  11 years, 1 months ago

  By: Gail Shaw

• Getting DeadLock on production server!!

  Hi, I am getting following deadlock message. Can any one explain what is happening in below deadlo…

  Zohaib Anwar

  7 replies

  11 years, 1 months ago

  By: Bill Talada

• Issue of retrieving same identity column value by multiple users

  Hi, I am using following queries in a stored procedure.This stored procedure is executed through a …

  cas001s

  6 replies

  11 years, 1 months ago

  By: ScottPletcher

• create table, set default column value to value of another column

  Hi, when creating a new table. How can I set the default value of the column to equal the value of…

  Marcus Farrugia

  5 replies

  11 years, 1 months ago

  By: Neil Burton

• Help! :crazy: Licence for SQL Server 2008 VM on Windows 2012

  I am confused by latest Microsoft Virtual server licence for SQL Server 2008. We have a Hyper-V ho…

  Blue Mancunian

  2 replies

  11 years, 1 months ago

  By: Blue Mancunian

• Converting the datatype of a computed column

  Hi All, I have a computed column that I want to cast as decimal. The two columns it calculates from…

  crazy_new

  8 replies

  11 years, 1 months ago

  By: crazy_new

• how to make inline function in following situation.

  hi, ALTER FUNCTION udfa(@aa int) RETURNS @tbla table (a VARCHAR(MAX),b VARCHAR(MAX)) AS BEGIN D…

  rajemessage 14195

  3 replies

  11 years, 1 months ago

  By: Gail Shaw

• I might be concerned because practice import me

  I might be concerned because practice import me on a lot right lower center lot of practice so what…

  sophiepeters

  1 replies

  11 years, 1 months ago

  By: Neil Burton

• SSIS 2005 & 2012

  Hi All, I have developed SSIS package In Visual Studio 2010(compatible with SQL2012), But while cli…

  PRAMANA.DBA

  3 replies

  11 years, 1 months ago

  By: Koen Verbeeck