SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Get max row based on the combination of 2 columns

  I have the following data in my table. The last 2 columns - OrderDate and OrderTime - come from Dat…

  SQLCurious

  1 replies

  11 years, 11 months ago

  By: Luis Cazares

• Interesting SQL challenge - compare differences in cells and rows

  I have a table... below is a limited version of what it looks like... ID, Received, TrailerID, Tyre…

  sqlservercentral 18091

  5 replies

  11 years, 11 months ago

  By: mickyT

• Set up SQL Server 2008 Express

  So I am very new at the setup process for SQL Server. I have used one, but this is the first one I …

  dalbright 47296

  5 replies

  11 years, 11 months ago

  By: joshdbguy

• Display all fields of the Views as one Table

  Good Morning I would like for each of the queries to have all of the selected fields shown horizont…

  fufu

  1 replies

  11 years, 11 months ago

  By: Robert Klimes

• Problem setting up a Linked Server

  Good Morning Everyone, I normally don't post any topics because I usually find a resolution by sear…

  louie1487 78804

  11 replies

  11 years, 11 months ago

  By: louie1487 78804

• Help with CTE please.

  Hello, I am trying but failing miserably with this CTE. Thank you very much for your assistance. .…

  johnnycougar

  2 replies

  11 years, 11 months ago

  By: johnnycougar

• change recovery model to bulk logged runtime

  Can we change Simple recovery model to bulk logged recovery model in runtime, and again bring back …

  yuvipoy

  4 replies

  11 years, 11 months ago

  By: Gail Shaw

• Cannot create default on column with a user defined data type

  This my not be as simple as it seems in that the default can be created on one server but not on an…

  buddy__a

  11 replies

  11 years, 11 months ago

  By: buddy__a

• Unable to shrink large database (data file)

  I know I know shrinking the data file is bad, but I have a case where I just have to. We have an a…

  samalex

  7 replies

  11 years, 11 months ago

  By: MyDoggieJessie

• Copy DB from Prod to QA

  I need to copy the Production Database to QA and it's running 24/7. Before I do this, I just need t…

  LearningDBA

  19 replies

  11 years, 11 months ago

  By: Jeff Moden

• Data Collector ( MDW )

  Hi guys, someone has experience with this ? Is it possible that default counters caused problem wit…

  tony28

  2 replies

  11 years, 11 months ago

  By: tony28

• SQL beginner - books and material

  Hi Folks, I'm new to this forums. I currently work in System/Network support role and find it to be…

  maniplusa 9705

  6 replies

  11 years, 11 months ago

  By: maniplusa 9705

• Sub Query and Left Joins to isolate data for Merge and Insert

  Hello Data Wizards, I am looking to simplify some a script with joins. I do understand the logic of…

  the.roof

  6 replies

  11 years, 11 months ago

  By: Luis Cazares

• Incremental load from a linked server.

  Hi, I need to do incremental loading from a source (a linked server in my db) to a destination whic…

  qifai3zoi3ziq

  5 replies

  11 years, 11 months ago

  By: Eirikur Eiriksson

• Escaping a close bracket ')' in an EXEC string.

  Hi guys, Im having a problem with the EXEC function in an update program. When running a script I …

  Don.

  6 replies

  11 years, 11 months ago

  By: Don.