SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• select statement recognising apostrophe as a quotation mark

  Hello I'm trying to do a query which includes CASE WHEN LEFT(LASTNAME,2) = 'O'' THEN ....... I'm …

  Tania Mofflin

  3 replies

  12 years ago

  By: Tania Mofflin

• Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

  hello all. I use this script for export query result to existing dbf file : insert into openrowset …

  elham_azizi_62

  3 replies

  12 years ago

  By: prabhu.st

• Loop till max size

  Hi, I have a requirement like need to loop the records until it reaches the max size of the databas…

  yuvipoy

  1 replies

  12 years ago

  By: pietlinden

• charindex patindex substring

  i have a long list of string that look like this: 7/5/2014 0:0:0 AUS UK 7/5/2014 18:21:0 7/5/2014 2…

  girl_bj

  13 replies

  12 years ago

  By: girl_bj

• Reclaiming free space on Log file.

  One of my database has 100+ GB log file size. But it's 99% free. I like to make log file size to 20…

  Tac11

  12 replies

  12 years ago

  By: praveenkshanmugam

• Why are my SSIS data flow steps using a CURSOR to transfer data?

  We have some SSIS packages that were upgraded from DTS. I do not know how this was done as they wer…

  auaiomrn

  4 replies

  12 years ago

  By: Luis Cazares

• Script Generator in table designer?

  I changed some indexes in our development database and saved to a script using the script generator…

  Ncage

  4 replies

  12 years ago

  By: Ncage

• How to Check SQl Driver for MS ACCESS

  Hi, I want to know how to check my server which drivers and what version they are using for SSIS …

  Shaun2012

  8 replies

  12 years ago

  By: Shaun2012

• Is partitioning good option for OLTP?

  Assuming i have enterprise edition, is partitioning recommended for OLTP? My thought is it is good …

  curious_sqldba

  20 replies

  12 years ago

  By: SQLRNNR

• Conflist between collations

  Hi all. My server collation is SQL_Latin1_General_CP1_CI_AS. From sys.databases, all databases incl…

  SQL Guy 1

  7 replies

  12 years ago

  By: Steve Jones - SSC Editor

• Exported data only shows the first column of data

  Hi, I have the following select statement which I am using to retrieve job history: select name, st…

  navtec

  6 replies

  12 years ago

  By: navtec

• Orphaned code

  When I write code in a database, it often turns out that some time later, the code is no longer nee…

  pdanes

  2 replies

  12 years ago

  By: pdanes

• SQL Server alert

  Dear all, I need to find a way of sending a text message preferably when any blocks occur in sql se…

  tt-615680

  3 replies

  12 years ago

  By: Grant Fritchey

• How do I know the Transaction log get increase after the Rebuild/Reorganize process?

  Hi All, I created the maintenance plan for Rebuild/Reorganize Indexes everyday and I want to check …

  WhiteLotus

  5 replies

  12 years ago

  By: Andrew G

• sql question

  Hello, I'm practicing SQL on SQLzoo.net and using the table at http://sqlzoo.net/wiki/More_JOIN_ope…

  mingdash

  8 replies

  12 years ago

  By: Luis Cazares