I am not sure what is going on and why this isn't as easy as I thought. I am trying to import data into a new database from an identically set...

MDB

08-17-2009 07:11 AM
Tim G-J

hi guys, i have a table this way: id keyword 1 banana 2 apple 3 cherry 4 orange 5 orange 6 apple 7 orange

moonsulu via SQLMonster.com

08-17-2009 05:55 AM
moonsulu via SQLMonster.com

Hi, I have created a maintenance plan which performs the following (in order, on all databases): - Check Database Integrity - Reorganize Index -...

Dragon

08-17-2009 04:03 AM
Dragon

Hello At present, I'm running Standerd Sql server 2005 on Windows Standard 2003 (X86). We have just received a new hardware with Windows 2008...

Fabrice

08-16-2009 04:20 PM
Jeffrey Williams

I'm hoping someone can confirm or deny my understanding of one of the differences between Oracle and SQL Server. AFAIK it is possible to scale...

Charles

08-16-2009 01:52 PM
Simon Harvey

Asking for suggestions on monitoring admin tool. Have 80instances and need produce backup reports , get version of all instances and every month need...

Rick

08-16-2009 08:14 AM
David Hay

According to our knowledge, the scheduled tasks run by SQL Server 2005 are stored in the MSDB database. However, as there is no SQL Server Agent in...

Patrick

08-14-2009 08:00 PM
Patrick

Where can I find a decent description of what was added in 2005 & 2008?

Jay

08-14-2009 07:02 PM
Alan Brewer [MSFT]

Hi SQL Gurus, Curious to know what exactly does SQL Server cache. It is just the execution plan. Or Execution plan with data. Or Both. And how long...

Dan

08-14-2009 05:02 PM
Dan

I'm mostly knowledgeable in 2000 and seem to have some time on my hands :) I'm wondering if I should study 2005 first and then 2008, or jump right...

Jay

08-14-2009 04:56 PM
Jay

We are running 64Bit SQL Server 2005 SP2 and 32 Bit SQL Server 2005 SP2 on a same machine. SQL Server 2005 was installed as 64-bit and a 32-bit...

InforEAM

08-14-2009 04:32 PM
Erland Sommarskog

Hi, I have not been able to solve VC80.ATL problems (as posted by me earlier today) so I'm now considering removing and re-installing all slq...

Bogdan

08-14-2009 04:10 PM
Erland Sommarskog

Hi I installed SQL 2008 developer on Windows 7 RTM. I was first told, that I need to install SP1 of SQL 2008, after installing SQL. Trying to...

Patrick D.

08-14-2009 03:08 PM
Aaron Bertrand [SQL Server MVP]

Hello I am running full recovery mode with point in time recovery. Can I add log shipping to create a standby server? JB -- JB

JB

08-14-2009 12:00 PM
bass_player

We have installed a SQL Server 2005 Express Instance (that comes along with an application) in the C drive. However, since we don't have...

Patrick

08-14-2009 10:53 AM
bass_player

Hi, This morning I noticed a generic svchost.exe error on an XP Pro machine running sqlexpress 2005. After rebooting it neither of sqlexpress 2005...

Bogdan

08-14-2009 08:26 AM
Bogdan

Hello. I think I am still a newbie to database world. Currently, I am responsible for maintaining a Sql Server 2k host of my company. I notice...

Tao Lei

08-14-2009 07:37 AM
Tao Lei

I'm trying to convert this query field to 3 decimal points. The result of the below line varies, but i want to keep all retrived data to...

fiaola

08-14-2009 01:08 AM
Tom Cooper

Hello I am running the full recovery model where I backup the database once in the evening while I backup the transaction log every 2 hours during...

JB

08-13-2009 10:33 PM
bass_player

Hello, Does Query Analyzer client tool (SQL7) connect to a SQL2008 instance? I thought it didnt and mention the same to a developer, but he was able...

Abba

08-13-2009 10:23 PM
bass_player

I have SQL Server Developer RTM and have previously successfully installed it on server 2003 os. Have vs 2008 ver 9.0.21022.8 RTM intalled , which...

Bob Lamberson

08-13-2009 10:08 PM
Bob Lamberson

Dear All, We have a VB application provided by a 3rd party company that runs on a SQL Server 2000 enterprise edition which currently uses 12GB RAM....

Alastair MacFarlane

08-13-2009 02:24 PM
Lucas Kartawidjaja

Hi, Is there any way to find, through a query, if a database is empty (I mean no user-objects, like tables, views, etc) The reason is, I want to...

bz

08-13-2009 02:04 PM
John Bell

Hi We use a packaged Helpdesk application Track-IT which we need to upgrade. Their support articles require the installation of both of the above...

Jimbly

08-13-2009 12:44 AM
John Bell

Hi all, wondering if anyone can help me out here... I have a table with 3million rows and I want to get the records only that have 1 unique...

SQL Server

08-13-2009 12:34 AM
Uri Dimant

Periodically I am unable to log into my SQL Server 2005 database with the error listed below. Please help me resolve this issue. Thank...

Joe K.

08-12-2009 08:52 PM
Tibor Karaszi

Platform : Windows 2003 Server VS 2008, SQL Server 2005 I have developed a database application. Database connecting to my application is placed...

vijay singh

08-12-2009 04:58 PM
Erland Sommarskog

Hello After backing up the database I backed up the transaction log and then I had to use dbcc shrinkfile command. The question is: Since I used...

JB

08-12-2009 04:40 PM
Erland Sommarskog

Hi. I want to alter the table and change the datatype char and varchar of clumns to nvarchar in one go instead of changing datatype of each column...

Muhammad Bilal

08-12-2009 04:34 PM
Erland Sommarskog

Hi sql serrver experts, I have a uniqueidentifier column, I forgot to specify NOT NULL when adding it to the table. I executed the...

Pingx

08-12-2009 04:27 PM
Pingx

Gurus, Running SQL Server 2005 SP2 on a cluster (two nodes, SQL instance running on each, active/active design). Under the SQL Configuration...

Spin

08-12-2009 03:55 PM
Spin

anyone have any input on this? are they any performance hits or gains with one over the other. I'm looking for comparative numbers on a server...

esource

08-12-2009 03:35 PM
Russell Fields

with BOM (PINBR, CINBR) AS ( select PINBR, CINBR from PSTRUC) , BOMCTE (PINBR, CINBR) AS (

dkraeer via SQLMonster.com

08-12-2009 03:14 PM
Plamen Ratchev

Hello masters of the database - I am not. Unfortunately find myself in an awkward position. We have an in house web app with SQL backend. It has...

billd

08-12-2009 10:31 AM
css

Hello, it's possibile to shrink logfile for a mirrored database? dbcc shrinkfile does not work and backup log with truncate_only is not possibile as...

d00mfl1ght

08-12-2009 09:45 AM
Andrew J. Kelly

Hello All, I installed a SQL2008 SP1 named instance along side a SQL2005 SP2 default instance on a DEV machine. Installation went fine, but...

jameseiv

08-12-2009 08:41 AM
jameseiv

I want to check my database for duplicate records and have written a stored procedure: CREATE procedure . as select Vendor number, Invoice number,...

René

08-12-2009 08:06 AM
Plamen Ratchev

Hi, I have a question regarding length of the stored prosedures. How many lines should a storeprocedure be? Best practices? Posted...

Nully Girl

08-12-2009 06:04 AM
Linchi Shea

Hi All, I came across SQL SERVER enviorment with german interface,Where they have configured 2 node active/active clustering.My question is...

Prashan

08-12-2009 01:31 AM
Prashan

I have a database with a transaction log that grows rapidly due to large amounts of activity on the database (it's the database for Microsoft...

Bradley Morris

08-11-2009 08:25 PM
Tibor Karaszi

Hi, I imported a excel chinese sheet/plan. On excel shows the characteres correctly. But when it's imported, I do select on the table and...

Paulo

08-11-2009 03:50 PM
Paulo

Hello I created a database using the Enterprise Managers therefore it used the default file sizes. I have been backing up the database but not the...

JB

08-11-2009 03:31 PM
Rick Sawtell

Hello all, I was given a .data file that is a Delete (Ascii 127) separated text file. I am trying to figure out how to get this data imported into...

Mike B

08-11-2009 01:37 PM
Linchi Shea

Hi. I want to compare two cloumns n two different tables excluding spaces. Let tbl1.col1 tbl2.col2 john j o h n when these two column are...

Muhammad Bilal

08-11-2009 01:03 PM
Russell Fields

Hello, I'm hoping someone here can shed some light on this situation that has me a little bewildered. My company has inherited a SQL 2000 server...

Scott

08-11-2009 12:28 PM
Aaron Bertrand [SQL Server MVP]

Hello All, I have an mirrored database on SQL 2008 whose tranastion log is beginning to fill up the disk, since Maintenance Plans didn't run during...

Zoran

08-11-2009 11:35 AM
Tibor Karaszi

Hi friends, in our sql server, the process "sqlservr.exe" is using more than 2,5GB... can I run any rutine or procedure to try clean or release...

herba98

08-11-2009 10:53 AM
Iain Sharp

I used code below to get data. It works fine. SELECT OrderName CASE WHEN = 'region1' THEN SUM() ELSE 0 END AS , CASE WHEN = 'region2' THEN...

aspfun via SQLMonster.com

08-11-2009 10:47 AM
Iain Sharp

We would like to store scanned image (photo) in our HR system. We would like to know what data type should we use ? Is it the same for both...

Patrick

08-11-2009 09:06 AM
Linchi Shea

Hi, Does somone know if there is possible to run alter synonym or do I have to drop and then create them? By the way I am using ms sql server...

Nully Girl

08-11-2009 06:56 AM
Aaron Bertrand [SQL Server MVP]