SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Changing Execution Plans in Cache

  Hello, I've exerpeinced something I've not noticed before, We have a heavily stored procedure in on…

  Djcarpen11

  4 replies

  13 years ago

  By: Djcarpen11

• Reinitialize log shipping in sql server 2008 R2 after activate Secondary server DB

  Hi All, I have set up logshipping between server A (Primary) and server B (Secondary), and tested l…

  tsdsuresh

  4 replies

  13 years ago

  By: rajeshsdba

• Give access to SQL Server Agent ONLY?

  Just wondering if it is possible to give someone SSMS access, however only allow them to run jobs w…

  hambo12

  1 replies

  13 years ago

  By: rajeshsdba

• Ranking Query

  Hi All, i have a requirement to find out which employee pass three exams continuously if you observ…

  cooljagadeesh

  4 replies

  13 years ago

  By: ChrisM@Work

• Comparing Two Different Tables, Showing Values In Table 1 Not in Table 2

  Hello, I'd like to compare two tables, and show values found in table 1 which are NOT in table 2, t…

  VegasL

  1 replies

  13 years ago

  By: ChrisM@Work

• Large dataset in one table or several small tables

  Hello. Here is my question: Is it better to store a "large" set of data in one table or break it ac…

  Tom Rippetoe

  2 replies

  13 years ago

  By: Tom Rippetoe

• Combine data from 2 tables and insert in another table

  I have following 3 table definition with data SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CRE…

  hemal_301080

  5 replies

  13 years ago

  By: Jeff Moden

• Turn off Predictive Typing

  Hi, There does anyone know how to turn of the Predictive Typing feature in SQL Server 2008 and 2008…

  brunm

  11 replies

  13 years ago

  By: Jeff Moden

• sql:space at the end of string

  I have a sql code like shown below declare @str nvarchar(max),@i int set @i=0 set @str='abc ' dec…

  IT researcher

  4 replies

  13 years ago

  By: Jeff Moden

• Database Query

  Hi, I have couple of questions related to sql server, though I googled it, did not get any definite…

  Pravasis

  7 replies

  13 years ago

  By: Jeff Moden

• Copy a table from one db to another including all configurations

  How to copy a table from one db to another including all configurations, such as index, primary key…

  adonetok

  8 replies

  13 years ago

  By: Sean Lange

• Procedure Execution Plans

  Hi all, I have a question regarding the best way to approach a situation where an application user …

  jrmcnesby

  5 replies

  13 years ago

  By: Gail Shaw

• LOB and OLTP

  Hi Guys, I have see people talking about relational databases as OLTP but now I have started to ear…

  river1

  9 replies

  13 years ago

  By: Robert-378556

• RFI: what do you do during production instances?

  The CEO of our company wants to know what all the different departments within IT (server operation…

  Mike Stuart

  5 replies

  13 years ago

  By: Lowell

• Update query help

  Hi, I need an update query which will get the 'scenario' and 'actType' values from all the rows in …

  maxlezious

  11 replies

  13 years ago

  By: Sean Lange