| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I will be creating a web application where upload and modification of
documents will be an important part of the application. Specifically,
users...
Bill E. Hollywood, FL
|
09-27-2011 06:01 PM
Bill E. Hollywood, FL  | 4 | 5 |
| | | I would like to upgrade a desktop from Windows 7 to Server 2008 and
host SQL instances on it in my home Workgroup network. But before I do
that, I am...
Joe Cool
|
09-25-2011 07:14 PM
Joe Cool | 3 | 4 |
| | | Before I even get started, let me apologize for the length of this post. In
two sentences - I'm asking if someone wants to give some (free) counsel...
Kurt Dicus
|
09-20-2011 04:11 AM
Kurt Dicus | 0 | 1 |
| | | SQL Server 2008 (10.0.4316).
Hi,
We have merge replication implemented on three servers - one publisher
and two subscribers.
I'd like to backup...
Jimbo
|
09-19-2011 04:52 PM
Erland Sommarskog | 2 | 3 |
| | | This is a script that the sql front end client wrote for me,- it
inserts a field toward the top of the layout for an autonumber/
Autoincrement...
BrianDP
|
09-13-2011 10:50 AM
Fred. | 2 | 3 |
| | | PITech is managing a state-of-the-art development project with the DoD
in Durham/RTP, NC. We are looking for a bright minded SQL/Server DBA
type who...
rasmith@pitechsol.com
|
09-12-2011 09:49 AM
rasmith@pitechsol.com | 0 | 1 |
| | | Good Morning All
I'm trying to create a simple connection string to a SQL 2000 server using
the old "SQL Server" driver - not the
Native Client, but...
Matthew Wells
|
09-12-2011 06:04 AM
Bob Barrows | 2 | 3 |
| | | Hi,
processing unicode data in MSSQL seems to require prefixing of all
constants in queries by a "N". That is not fun when it comes to...
Keith Sauvant
|
09-08-2011 05:00 PM
Erland Sommarskog | 1 | 2 |
| | | HI everyone!
How can I measure the hardware capacity of my server to handle
transactions?
This is the situation.
A customer ask us if we can handle...
Wishmaster
|
09-07-2011 09:59 AM
Wishmaster | 5 | 6 |
| | | Global Business Intelligence (BI) vendor, Yellowfin, as been invited
to present at the inaugural UK Open Source BI User Group Event in
London,...
Jan
|
09-06-2011 09:48 PM
Jan | 0 | 1 |
| | | Hello,
for my mssql shared hosing I have create a database and login using
security settings write by microsoft for sql shared...
Antony
|
09-03-2011 06:07 PM
Erland Sommarskog | 1 | 2 |
| | | I have an interesting issue connecting to ms sql server.
I'm connecting to the server with in a legacy asp application just
fine. The same...
Fabiof
|
09-01-2011 11:55 AM
Henk van den Berg | 4 | 5 |
| | | CEO of Yellowfin's talks at 'The New World of Data' conference on the
tactical use of big data
Video Link
http://www.youtube.com/watch?v=5VK11WBco2Q
Jan
|
09-01-2011 09:49 AM
Jan | 0 | 1 |
| | | Hi,
does SQL Server see two single quotes as a null?
Thanks
Lee
Lee
|
08-25-2011 01:29 PM
Bob Barrows | 1 | 2 |
| | | I have a table with three columns:
Name Date Action
Fred Today this
Fred Today this
Fred ...
Harry
|
08-25-2011 12:21 AM
Yonghang Wang | 9 | 10 |
| | | WATCH WORLD`S MOST BEAUTIFUL CITY SCAPE...
rabia
|
08-24-2011 01:53 AM
rabia | 0 | 1 |
| | | WATCH WORLD`S MOST BEAUTIFUL...
rabia
|
08-22-2011 05:30 AM
rabia | 0 | 1 |
| | | Have written basic queries with SQL for a while now but have been
given a project that requires me to step it up a notch. Any help would
be...
FCB
|
08-20-2011 12:19 PM
FCB | 2 | 3 |
| | | PITech is supporting a state-of-the-art development project with the
DOD here in RTP, NC. We are looking for a bright minded SQL/Server DBA
who knows...
rasmith@pitechsol.com
|
08-18-2011 12:13 PM
rasmith@pitechsol.com | 0 | 1 |
| | | See Worlds Most Beautiful Places...
rabia
|
08-15-2011 01:44 AM
rabia | 0 | 1 |
| | | 9 tips for Mobile BI success
Full...
Jan
|
08-14-2011 09:29 AM
Jan | 0 | 1 |
| | | Hello -
I have a strange problem when casting value under 64-bit sql server
2005 vs under 32-bit sql server 2005.
I got two servers. One has...
xo
|
08-13-2011 06:59 AM
Erland Sommarskog | 8 | 9 |
| | | I've made an install of SQL Server 2008 (evidently its Developer
Edition) and also installed SP1. SP1 failed to install the first time
and I learned...
jack08520
|
08-11-2011 05:07 PM
jack08520 | 2 | 3 |
| | | I have a database with lots of tables accessed using Windows Authentication.. I need to audit all actions on all tables by all users in this db. I...
Allen Jones
|
08-05-2011 09:25 AM
Allen Jones | 0 | 1 |
| | | This is SQL 2005
I have a stored procedure that deadlocked om PR_CUST table
CREATE TABLE .(
NULL,
NULL,
NULL,
NULL,
NULL,
... <snip for...
migurus
|
08-03-2011 05:21 PM
Erland Sommarskog | 1 | 2 |
| | | Hi,
-> Description (short): <------------------
stored procedure calling sub-procedure with updlock select. How could I
release the updatelog if...
Mark Schneider
|
08-02-2011 01:23 AM
Mark Schneider | 2 | 3 |
| | | Hi All,
I implemented TDE on one of my SQL Server instance. When I query the
database state with the following query it returns 2 to one of...
Query Builder
|
07-29-2011 06:09 PM
Erland Sommarskog | 5 | 6 |
| | | suppose I have 100M records and we don't like INSERT.
one option is to export to external file and bulk load the file.
is there any better idea?...
Hardy
|
07-27-2011 05:53 PM
Erland Sommarskog | 3 | 4 |
| | | At my organization, users have started to use the virtual address
created when SQL Server is installed on a failover cluster for non-SQL
uses.
I...
Mark
|
07-25-2011 09:09 AM
Mark | 2 | 3 |
| | | Let's say that I have a table with two fields: InfPctField and
DecimalField, where the first is of type INT and the latter is
DECIMAL(16,2).
When I...
BobRoyAce
|
07-22-2011 03:08 AM
BobRoyAce | 2 | 3 |
| | | Hi,
do you know a free tool for viewing/editing SQL procedures?
With "SQuirreL SQL Client" it is not possible.
There is a long list of...
Christof Kluß
|
07-21-2011 06:26 AM
Christof Kluß | 2 | 3 |
| | | It's been years and years since I used a newsgroup. Wow. This brings back
some memories!
Okay, my issue.
I have an output from a system that...
Kurt Dicus
|
07-21-2011 05:14 AM
Kurt Dicus | 2 | 3 |
| | | Dear SQL'ers:
Enough playing in the guts. Now, I need to figure out which
language or language to use for front-end code. The system being
planned...
Gene Wirchenko
|
07-21-2011 03:56 AM
Kurt Dicus | 4 | 5 |
| | | Hello All!!
Windows Update keeps telling me SP4 for 2005 needs to be installed. I've
done it several times. I've even download the sp from...
Matthew Wells
|
07-20-2011 05:32 PM
Erland Sommarskog | 3 | 4 |
| | | you can try selecting from a result set, do all your manipulation via
CASE in the inner result set,, and save the SUM till you have the data
as you...
BobRoyAce
|
07-19-2011 09:15 AM
Herb | 1 | 2 |
| | | The use of Social and Collaborative Business Intelligence (BI) will
allow information to be directly linked to decisions made within...
Jan
|
07-19-2011 08:32 AM
Jan | 0 | 1 |
| | | FreeExamKing Providing latest Q&A, brain dumps
Hi,
FreeExamKing is providing latest & accurate preparation practice
questions and answers brain...
miss salwa
|
07-16-2011 04:40 PM
miss salwa | 0 | 1 |
| | | Dear SQL'ers:
Is there any way around the SQL glitch that a check condition
will always succeed when the table is empty?
I do not want to have the...
Gene Wirchenko
|
07-16-2011 09:46 AM
--CELKO-- | 10 | 11 |
| | | Hello All,
Is it possible to do these tasks from a database on a clustered server to a
database on a non clustered...
Matthew Wells
|
07-16-2011 04:54 AM
Erland Sommarskog | 3 | 4 |
| | | Hi!
Do you know any free MS SQL Server database hosting service?
Elton Lika
|
07-14-2011 02:29 PM
Elton Lika | 6 | 7 |
| | | Bob Barrows schreef op 14-07-2011 14:35:
Henk van den Berg
|
07-14-2011 11:39 AM
Henk van den Berg | 0 | 1 |
| | | Dear SQL'ers:
How do I force a condition based on multiple rows? I want the
necessary rows to be entered in a batch. As a simple example,...
Gene Wirchenko
|
07-13-2011 03:14 PM
Gene Wirchenko | 5 | 6 |
| | | Business Intelligence breakdown of the Tour
The 2011 tour is an already tantalizing prospect, with three-time
winner Alberto Contador (Spain)...
Jan
|
07-13-2011 08:01 AM
Jan | 0 | 1 |
| | | SUMMARY:
SSMS Query Designer chokes on analytic functions. Is there any
workaround for this?
EXAMPLE:
This query runs fine:
SELECT
*
,ROW_NUMBER()...
bill
|
07-07-2011 03:05 PM
bill | 5 | 6 |
| | | Is it possible to pass Certification Exams without proper training?
Yes now its possible, this site will help you to download all guides
and latest...
miss lulu
|
07-06-2011 03:53 PM
miss lulu | 0 | 1 |
| | | Hi
I need help to rewrite Access SQL to MS-SQL query
TRANSFORM Count(tbl_ORDH_STAT.RECID) AS AntalOfRECID
SELECT tbl_ORDH_STAT.O_UGE
FROM...
olesen
|
06-30-2011 07:09 PM
Fred. | 3 | 4 |
| | | I deal with high modification frequency data, which must be always
consistent when read and when updated. System is run under SQL Server
2005.
The...
migurus
|
06-29-2011 06:00 PM
Erland Sommarskog | 1 | 2 |
| | | Hi,
I've been banging my head against a brick wall trying to sort this and
hoping somebody can help!!!
i have a table that has 4 main...
Steve
|
06-29-2011 07:47 AM
rembrandt | 3 | 4 |
| | | We have developed a SQL Server backup utility that can backup /
compress and encrypt databases. They can then be sent to FTP/TFTP/NAs
or lical...
George Kirkwood
|
06-27-2011 08:59 AM
George Kirkwood | 0 | 1 |
| | | Data analysis. What’s the point of it? Your first reaction might be
to scoff at, or dismiss this question as rhetorical, perhaps
pointless. But...
Jan
|
06-27-2011 07:44 AM
Jan | 0 | 1 |
