SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• InPlace update for Included Columns

  The Delete-Insert update happens for key columns of Indexes and that makes sense. But I am confused…

  er.mayankshukla

  3 replies

  11 years ago

  By: er.mayankshukla

• Add todays date to one new record only

  Hello, I’m wondering if you could please help me. I’m wanting a SQL Formula to insert into my Accou…

  jeremy 64107

  3 replies

  11 years ago

  By: mssqlsrv

• Index fragmented quickly

  Hi All, I just did index defragmentation for some databases include MSDB . I notice there are 3 ind…

  WhiteLotus

  6 replies

  11 years ago

  By: WhiteLotus

• Conversion failed when converting the nvarchar value to INT

  Not sure, why the below code is throwing error. Any suggestion please? Declare @specificDB nvarchar…

  SQL_Hunt

  2 replies

  11 years ago

  By: SQL_Hunt

• how to calculate date time

  hi, my data is looks like this, Date---------------------------------------A 2015-03-01 13:38:07.34…

  immaduddinahmed

  7 replies

  11 years ago

  By: Lynn Pettis

• SQL Timeout for client, but no error in SQL logs

  Using SQL 2008 R2 and .NET 4.0 Application on separate Windows 2008 R2 servers. Occasionally, the c…

  tom.sage 70179

  6 replies

  11 years ago

  By: Grant Fritchey

• Windows user with SQL Server Authentication

  I'm almost sure that it's not possible, but I wanted to ask in case that I'm missing something. Is …

  Luis Cazares

  1 replies

  11 years ago

  By: Grant Fritchey

• Anyone Tell me what regular Housekeeping is needed for SQL DB's

  Hi - Just looking for advice regarding what regular housekeeping tasks should be performed on SQL D…

  dax.latchford

  5 replies

  11 years ago

  By: Alan Burstein

• can i solve lokups of non clusterd using clustering index, or i should use the cols in key of nonclusted or includes

  Q1) I have a table which hase clustered on first col (unique identifyer col) I have an other non …

  rajemessage 14195

  3 replies

  11 years ago

  By: ScottPletcher

• spaced used by a col in an index in index page is the total lenght of the col or the data it stores in it.

  i have one col in a nonclusted index which is bigint 8 bytes follwoing result shows min_record_size…

  rajemessage 14195

  1 replies

  11 years ago

  By: ScottPletcher

• Need help in sql query

  I’m trying to do a SQL statement in our application and having some issues. What I’m struggling wi…

  Zohaib Anwar

  5 replies

  11 years ago

  By: Sean Lange

• Logshipping

  where the .tuf file is locatied in Logshipping ?

  ramyours2003

  3 replies

  11 years ago

  By: ramyours2003

• Custom Alert is not emailing operator!!! I am sure I have missed a step.

  Hello, I am trying to create an alert when there are more than 2500 connections to our ailing SQL S…

  WebTechie

  6 replies

  11 years ago

  By: WebTechie

• Review my Update Stats Script. Suggestion and helping me come over "Could not complete cursor operation because the set options have changed since the cursor was declared."

  Create Proc usp_updateStatsAllDbs AS BEGIN SET ANSI_NULLS ON SET ARITHABORT ON SET QUOTED_IDENTIFIE…

  SQL_Hunt

  1 replies

  11 years ago

  By: MadAdmin

• How to determine baseline for SQL Servers

  Hi - I've been put in a situation where I have a number of SQL DB's running on 2005/2008 which I ha…

  dax.latchford

  1 replies

  11 years ago

  By: Grant Fritchey