SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Can anyone clarify a PATINDEX phrase?

  Can someone tell me what this phrase is doing? Found it in some code I'm inheriting: WHEN PATINDEX …

  SQLalchemy

  3 replies

  11 years, 10 months ago

  By: ScottPletcher

• If Else or similar in the WHERE clause section

  Hi, I have a situation where if a parameter passed in by the user is equal to 'No Group' I want to …

  mattech06

  8 replies

  11 years, 10 months ago

  By: Sean Lange

• strange db log file size number

  First of all, my sql2008 R2 instance is running normal. The SSMS Database Properties screen shows t…

  seaport

  2 replies

  11 years, 10 months ago

  By: seaport

• SELECT IN CLAUSE

  I have this table: CREATE TABLE [dbo].[Hosea_tblDef_Cloning_Table]( [ID] [int] IDENTITY(1,1) NOT …

  hoseam

  2 replies

  11 years, 10 months ago

  By: ChrisM@Work

• created a index rebuild job want to understand what happens when it runs

  Dear Experts, I've created an index rebuild maintenance job for one table which has 9 indexes, the …

  rajsin7786

  9 replies

  11 years, 10 months ago

  By: Jeff Moden

• Error: 18210, backup failed error mesg?

  Hi, DB: MS SQL2K8 32 bit with SP3. Backup completed successfully but These error messages apperard …

  SQL Galaxy

  8 replies

  11 years, 10 months ago

  By: Grant Fritchey

• Audit when using Service accounts

  We have an application, which is configured to run under service account. It connects to database u…

  sathishchandrahyd

  3 replies

  11 years, 10 months ago

  By: sathishchandrahyd

• some UDF FUnction help, please....

  I would like to turn a ranking statement into a function.. . I THINK I need a Table valued functio…

  CptCrusty1

  6 replies

  11 years, 10 months ago

  By: CptCrusty1

• Update a date field with a Trigger when a transaction is posted to another table

  Hello, I’m wondering if you can please help me. I have two tables. Customers.UniqueID and Transhead…

  jeremy 64107

  27 replies

  11 years, 10 months ago

  By: jeremy 64107

• Filestream Multiple Columns?

  So I managed to create a database and a table with one filestream column. And I even managed to fil…

  Henk de W

  1 replies

  11 years, 10 months ago

  By: Henk de W

• Alter Authorization on Schema Statement

  Hi Friends. I was unable to delete a user because they were db_owner for a particular database. I e…

  ganteng1

  2 replies

  11 years, 10 months ago

  By: ganteng1

• Replicate Schema but not table Rows

  Hi, i have SQL Server 2008 R2 and i need perform the replication between two database, production a…

  dafioga

  2 replies

  11 years, 10 months ago

  By: dafioga

• SQL JIT DEBUGGER

  SQL JIT DEBUGGER is disabled on my Server with SQL Server ...Will it impact anything, especially ap…

  Jai-SQL DBA

  1 replies

  11 years, 10 months ago

  By: Steve Jones - SSC Editor

• connection count question

  1. how many connection there is on SERVER? 2. how many connection there is on the DATABASE? suspen…

  Tac11

  3 replies

  11 years, 10 months ago

  By: Eirikur Eiriksson

• SQl server is running slow

  I will try to provide with as much information as I can Problem: Sql server is running slow. On the…

  LearningDBA

  8 replies

  11 years, 10 months ago

  By: LearningDBA