Hello: Well, I downloaded it. I think I installed it right, but I do not know enough to be sure. Now, what? Can someone please point me to what I...

Gene Wirchenko

07-28-2010 04:45 AM
Erland Sommarskog

Hello, I am trying to load a csv file using bulk insert. Everything goes fine but no data is loaded! All I get is a message saying "(0...

ableport@gmail.com

07-27-2010 05:28 PM
Erland Sommarskog

Title: QA Lead Location: Portland OR Duration: 6 months Job Description: QA Lead should be a strong...

Maple MRS

07-27-2010 02:54 PM
Maple MRS

Hi! There is a way to connect to a MSSQL server and to count the number of CAL? Maybe a view on the server? Thank you Alberto

Alberto Amati

07-25-2010 04:06 PM
Alberto Amati

Hi I'm fairly novice to SQL Server and am trying to make a computed column in my database I have the following columns in tblJobs...

jobs@thomassharp.com

07-25-2010 01:18 PM
Erland Sommarskog

I am trying to run a query from a C#.NET application using the standard SqlClient connected to a SQL2005 database. Basically the query is: select...

Joe Cool

07-24-2010 06:42 AM
Erland Sommarskog

How do use ADO.NET from unmanaged C++? Do I need to use COM? Not sure if the is the right group? Lars

Lars Schouw

07-22-2010 04:22 PM
Erland Sommarskog

It seemed to install fine but when I run Managment Studio (2008 R2) I can only log into the existing 2005 instance. Add/Remove Programs (well, the W7...

dgk

07-22-2010 04:20 PM
Erland Sommarskog

Hi, I have a relatively large table which has around five million records. When I run a query like: Select A, B, C where A='AA' and B='BB' the...

Mo

07-21-2010 05:31 PM
Erland Sommarskog

I have a database that runs on SQL 2000. The machine and database have all the server packs. The machine is a quad-core intel machine with 3GB ram....

Elijah

07-20-2010 12:03 PM
Elijah Campbell

Hi, I restored a full db backup, then applied point in time TX log restore (I picked a time that is earlier than the accumulated log backup...

xo

07-17-2010 08:58 AM
Erland Sommarskog

Hi! What application server are available to publish sql server 2008 spatial data on the web? Thanks a lot Injektilo

Injektilo

07-16-2010 07:02 AM
Injektilo

Currently the client app connects directly to the database, like this: <--> For various reasons we need to develop a piece of software that...

jbdhl

07-15-2010 05:10 PM
Erland Sommarskog

Hi, I have a stored procedure which accept a datetime input parameter. spMyProcedure '2010-07-14 13:25:48' Above statement works fine in my...

sahinceylan

07-15-2010 12:46 PM
sahinceylan

Glen Rabie is CEO of Yellowfin Business Intelligence, recognised among 25 rising companies that CIO’s must know about, Yellowfin is an innovative and...

JTP PR

07-15-2010 08:54 AM
JTP PR

hi all I have problems with EdgeCam 12.5, which uses SQL server. So far, 2 signs are being changed to ASCII codes in brackets. Examples are...

jodleren

07-15-2010 04:19 AM
Erland Sommarskog

Hello - I am having trouble trying to schedule cmd step using xcopy command to copy a file from one server to another server. I am getting...

xo

07-14-2010 07:15 PM
xo

Hi, URGENT! I got the following errors from the DBCC checkdb result on the production system which indicates there are corruptions on some indexes...

xo

07-10-2010 05:41 AM
Erland Sommarskog

I have a database in read-only rollforward mode. What command or where in SQL server studio can I find the last log applied/restored? Thank you.

Ultrak The DBA

07-09-2010 05:58 PM
Erland Sommarskog

Whitepaper - PDF (No signup Required - Just click or Paste the link) http://www.yellowfin.com.au/Document.i4?DocumentId=109023 Extract Despite all...

JTP PR

07-08-2010 09:31 AM
JTP PR

Hello, We are pleased to announce the release of our new MS SQL Server 2008 Administration test. This certification test is available for free...

BB_test

07-07-2010 11:46 AM
BB_test

Hello, I have a short procedure which compiles fine. When the code is called from a webpage(.net) it runs the first time it is executed. However...

crocboy25

07-07-2010 10:11 AM
Bob Barrows

I have an expression in a view that calculates a date by adding a number of months using the dateadd function. I want to get both the datepart (m...

NZDeveloper

07-06-2010 09:22 PM
NZDeveloper

One of my clients is getting locking on a very small, but regularly updated table. Funny enough this uses stored procs all the way to read from or...

SmartbizAustralia

07-05-2010 04:26 AM
Erland Sommarskog

Dear everyone, We have a linked server connection between two servers (MS SQL Server 2005), but we have problems transferring large text fields...

BitBuster

07-04-2010 04:25 AM
Erland Sommarskog

Hi NG! Three physical locations (A, B and C) share the same database. When a person at location A puts something in the database, it should...

ThomasH

07-02-2010 02:57 AM
Erland Sommarskog

Dear Candidate, Title: SSIS Developer Location: CA Duration: 3 months Skills Required:

Maple MRS

06-30-2010 02:15 PM
Maple MRS

For those of your who take interest in excellent infographics and leading edge database reporting techniques.. check out this...

JTP PR

06-30-2010 08:23 AM
JTP PR

Title: Business Analyst Defined Contribution Plans Right to Hire: No Professional Day Length: 0.0 Contract Duration: Environment: Business...

Maple MRS

06-28-2010 04:27 PM
Maple MRS

Title : Sr Technical Project Manager Location : Reston, Virginia Description : Minimum Requirements: Typically possesses 10 to 15 years of...

Maple MRS

06-28-2010 04:15 PM
Maple MRS

Hi all I'm using SQL Server 2005 express and the adventureworks sample database to try and refresh my memory with SQL Server (It's been about 5...

lk

06-27-2010 10:56 AM
Erland Sommarskog

I have several databases on a SQL2005 server. All were created the same way, using the SQL Server Management Studio create new database wizard. On...

Joe Cool

06-26-2010 05:12 AM
Erland Sommarskog

Hi guys, im playing with sql server managemnent studio. I cannot find rowversion type, but if I'm not wrong, yesterday it was in the list :S Is it...

redbull

06-25-2010 10:54 AM
Erland Sommarskog

Hi guys, I'm using sql server 2008 express. my problem is this: I use vb.net, when i try to loggin to sql server using windows authentication, it...

redbull

06-25-2010 10:51 AM
Erland Sommarskog

Dear Candidate, Title: Sun IDM resources Duration: 3+ Months Multiple Location

Maple MRS

06-24-2010 03:01 PM
Maple MRS

Hi All, I have this unusual behavior in my SQL server 2008 Ent 64bit (Clustered) environment. I migrated my SQL Instance from a SQL 2000 Ent...

Query Builder

06-24-2010 02:38 AM
Erland Sommarskog

SQL2000 SP4. I have a SQL Store Procedure that performs a database backup, to a disk file, for each 'user' database in the SQL instance. The script...

Jimbo

06-22-2010 02:12 PM
Erland Sommarskog

Dear Candidate, Job Title : BI ETL Developer Location : San Francisco, CA Job Type : 6 Months Contract Position Description:

Maple MRS

06-16-2010 05:28 PM
Maple MRS

If you have been tracking the BI industry for a while you will have noticed that that in-memory analysis is all the rage. The reason for this is...

JTP PR

06-16-2010 07:54 AM
JTP PR

The application language that I use prepends # (0x25) on the front of image data before storing it in SQL server. It handles this natively, and can...

Iain Sharp

06-15-2010 06:36 AM
Iain Sharp

Hi friends, Do u need Windows and Linux Tips? Please visit the following site: http://windowsandlinuxtips.blogspot.com/

Pavel Haque

06-14-2010 08:05 AM
Pavel Haque

Hello, We are pleased to announce the release of our new MS SQL Server 2008 Administration test. This certification test is available for free...

BB_test

06-11-2010 02:45 PM
BB_test

Anyone can recommend a SQL Server (2008) book a long-time Oracle developer ?

klara

06-10-2010 05:29 PM
Plamen Ratchev

Hello. A client is moving a critical database from a German system to a US English system this weekend. Are there any known issues or anything we...

theintrepidfox

06-10-2010 04:18 PM
Erland Sommarskog

Hi, I have the following table: TableName: WC Columns: UserID PeriodOfEntry LastName 1 06/02/2010 Apple 1 ...

soni kundani

06-03-2010 09:07 AM
soni kundani

Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the “Village of Orrible” who want to break...

Anil Mahadev

06-02-2010 11:58 AM
Anil Mahadev

I have an database with many datetime columns in many different entities. My application language has theoretically the facility to adjust the times...

Iain Sharp

06-02-2010 04:03 AM
Iain Sharp

With Gartner's Business Intelligence group listing In-Memory analytics at the top of their recommended Business Intelligence requirements...

JTP PR

05-27-2010 08:12 AM
JTP PR

Hi all, I'm tracking a bunch of different items through a production process. I want to be able to report out various conglomerated data...

HumanJHawkins

05-25-2010 05:21 PM
HumanJHawkins

Dear Candidate, Title: Business/ Data Analyst Location: Richmond VA Duration: 12 Months Description:

Maple MRS

05-21-2010 06:03 PM
Maple MRS