| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | In the process of learning SQL I came across a normalized test table
(SQL Server 2005) containing height and weight values like so:
datevalue ...
gempak@SAE206-06C1DR.jacks.local
|
10-11-2009 02:45 PM
zf  | 4 | 121 |
| | | I have scoured the online TSQL manual at MSDN and haven't found the
answer to this question.
In SQL Server 2000, how can I do MAX(a,b),...
Tony Mountifield
|
10-10-2009 05:07 PM
Tony Mountifield | 6 | 109 |
 | | Dear friends,
I am writing to share with you about a unique social knowledge network
- Kenlighten http://www.kenlighten.com .
At Kenlighten you can...
uma
|
10-09-2009 11:21 PM
uma | 0 | 180 |
| | | hi,
recently we installed some software updates and noticed that on the
average the values of the performance counter
PerfCounter =
increased...
Tim
|
10-09-2009 12:31 AM
Tim | 2 | 120 |
| | | Hi,
I have just installed on my machine Visual Studio 2008 and and Sql
Server 2008 developer edition. Sql server is working fine when I
access it...
Photomonkey
|
10-08-2009 04:58 PM
Erland Sommarskog | 2 | 103 |
| | | Hi
we are converting a Filemaker application which handles this task
amazingly simple.
this is almost like the old days with the mail merge feature...
George Lewycky
|
10-08-2009 09:32 AM
George Lewycky | 0 | 87 |
| | | Hello,
I am trying to make ODBC connection to local SQL Server 2000. In the
'ODBC Data Source Administrator' there is a server drop down list....
fasisi
|
10-07-2009 09:20 PM
fasisi | 0 | 112 |
| | | I have the following data returned by this query:
SELECT TOP 20
t.ID,
t.Name
FROM
tblContacts t
ORDER BY
t.Name
ID NAME
Lauren Quantrell
|
10-07-2009 08:07 AM
Lauren Quantrell | 2 | 106 |
| | | Hello all. SQL 2000 SP 4. I am trying to copy one Database diagram
over from my test server to my prod server. This particular database
has...
Raziq Shekha
|
10-07-2009 05:40 AM
Malcolm Leach | 2 | 97 |
| | | Hi All,
Please bear with me as I'm inexperienced in DBA activities
What is the best way to defragment a very large table if both minimal
user...
seanD
|
10-02-2009 05:24 PM
seanD | 0 | 120 |
| | | Coalesce would return the first match of expression arguments. I'm
wondering if there's a similar function that would return any (all)
matches of...
Don84
|
10-02-2009 02:39 PM
Don84 | 3 | 113 |
| | | We have a table that contains billions of rows. When we try to UPDATE
that table, we overload the transaction log. What are some ways to
avoid...
imani_technology_spam@yahoo.com
|
10-02-2009 02:48 AM
Enorme Vigenti | 11 | 186 |
| | | Hi
I'm using SQL Server 2005 on a .NET project that deals with multiple
languages, During installation i made the SQL collation to default.
But as...
althafexcel@gmail.com
|
10-01-2009 06:00 AM
BrianR | 2 | 207 |
| | | TEMPLATES table has a field X_UPDATED whose type is datetime. I use the code
to update it in SQL Server 2008 but an exception occurs.
cmd = new...
yqever
|
09-28-2009 04:32 PM
Erland Sommarskog | 3 | 205 |
| | | Hello,
we have a big problem in our production optimizing a table. This table
is a small table (usually 100s of items, max of around 5000 rows)....
Absi (SQL Developer)
|
09-25-2009 02:23 PM
Erland Sommarskog | 4 | 142 |
| | | I have a table whose structure is similar to this.
ID bigint IDENTITY,
Unit_ID bigint,
Counter bigint
The ID column is the PK column and the...
Billy
|
09-24-2009 04:26 PM
Erland Sommarskog | 7 | 136 |
| | | Hello,
We have database in SIMPLE recovery model.
MDF file is about 3GB
but LDF file is about 15GB
We tried to shrink LDF, and after shrinking we...
m
|
09-24-2009 04:21 PM
Erland Sommarskog | 6 | 107 |
| | | Hi,
I have my SQL Server database spread across multiple disks. I used DMV
views to find out the queries with high I/O and the tables they use.
Now I...
soy
|
09-24-2009 04:14 PM
Erland Sommarskog | 3 | 106 |
| | | For a research project, I search for some statistics for the TPC-C
benchmark. Are the following already available somewhere in the...
jbdhl
|
09-24-2009 04:55 AM
jbdhl | 0 | 114 |
| | | I'm in the process of setting up a test box and I've got a question on
Mirroring.
I'm using SQL 2008 SP2 64 Bit. I've split the DB into various...
Ryan
|
09-22-2009 10:25 AM
Ryan | 0 | 203 |
| | | Hi all, First of all, I am a newb. I have inherited the task of
index maintenence in a production sql server 2005 database. I have
queried...
seanD
|
09-22-2009 09:28 AM
BrianR | 1 | 91 |
| | | Hi
We need Professional person who can solve our Problem regarding
memory consumption due to sql server ,On finishing a work handsome
amount of...
value World
|
09-18-2009 10:10 AM
Hugo Kornelis | 1 | 137 |
| | | I am a student learning sql. I used ms sql server 2008 but the license
ran out so i found the express version which doesnt require a license
and is...
newbie
|
09-16-2009 10:59 AM
newbie | 4 | 130 |
| | | http://msdn.microsoft.com/en-us/library/ms143393%28SQL.90%29.aspx
Ooogy
|
09-16-2009 10:01 AM
Ooogy | 0 | 211 |
| | | I've recently started at a new company and inherited some servers as
is often the case (1 main DB and 6 read only subscribers). Backups
were scarce...
Ryan
|
09-16-2009 02:59 AM
Ryan | 2 | 147 |
| | | SQL Server 2005 SP2 (Standard Edition 32 bit)
I need some help trying to figure out the right way to query the job
information.
The issue is we...
Mark D Powell
|
09-15-2009 10:24 AM
Mark D Powell | 5 | 260 |
| | | I am trying to check if any JDBC driver for MS SQL Server is installed
on my system from any vendor. How can I do this ? I would like to
check this...
Rohit
|
09-15-2009 08:34 AM
Rohit | 0 | 103 |
| | | Most people may think of geographic information systems (GIS) simply
as Google maps or the navigation system for their car, but GIS tools
do a lot...
JTP PR
|
09-14-2009 06:53 AM
JTP PR | 0 | 104 |
| | | Hi
We are using Sql 2008.
I havce a developer who needs to make changes to a table definition,
column types etc.
What kind of server role and...
David Greenberg
|
09-13-2009 07:18 AM
Erland Sommarskog | 1 | 120 |
| | | Hello all,
I have Several sql Servers on the back end of our web site
default tcp port is 1433
My question is since i have many servers
1 Main Sql...
DaveP
|
09-10-2009 04:20 PM
DaveP | 2 | 134 |
| | | My MSSQL Server was hacked. Many of my records contain injected script
tag strings.
Please recommend any solution to remove them: maybe Regex or...
vunet
|
09-09-2009 04:51 PM
Erland Sommarskog | 6 | 110 |
| | | Hello, i have table with columns plec, stopien, lokalizacja, oddzial
and i need sum count use this query :
SELECT COUNT(*) AS ilosc_osob,
(SELECT...
Martinez
|
09-09-2009 08:29 AM
Plamen Ratchev | 1 | 115 |
| | | Hello,
I have 2 services within SQL server, how can I remove one of this services?
Edwin Zoeller
|
09-08-2009 11:32 AM
Plamen Ratchev | 1 | 235 |
| | | First of all, I'm from separate data from logs -generation and I know
nothing about SAN disks. And that's why I made some tests when we got
some more...
Pasi Oja-Nisula
|
09-05-2009 02:25 PM
Pasi Oja-Nisula | 2 | 236 |
| | | Some how user database is now in the systems database folder. I need
to move it back to the user databases folder.Any ideas how?
hayko98
|
08-29-2009 04:08 PM
Hugo Kornelis | 6 | 160 |
| | | i have prd database (10Gb which has 3 monts of data.SQL 2005).Every day
(at 1am) i do full back up and at 12:30am diff back up.Diff backup
size is...
hayko98
|
08-28-2009 05:12 PM
Hugo Kornelis | 1 | 132 |
| | | I've been trying to use PATINDEX in SQL Server CE and it isn't
behaving the way I would like it to. I'm trying to strip leading
characters from a...
Dave Clarke
|
08-27-2009 09:00 AM
Tom van Stiphout | 3 | 148 |
| | | the download page does not say that, thanks.
Don84
|
08-24-2009 04:15 PM
Erland Sommarskog | 1 | 108 |
| | | Hi,
SQL platform = MS SQL Server 2005 Express
OS = XP | Vista
Question, when I use a script to create a db, say, myDB, and then
verify its...
Don84
|
08-20-2009 02:02 AM
Erland Sommarskog | 11 | 243 |
| | | When encrypting a sql server 2008 database, an essential step is to
backup the certificate(s) used to encrypt the Database Encryption key
What is...
trey
|
08-17-2009 12:15 AM
trey | 1 | 130 |
| | | I'm wondering if there's a version of lean sql server (just the
database engine, basic client tool and connectivity tool) for Vista
OS? 2000 does...
Don84
|
08-14-2009 04:33 PM
Don84 | 8 | 258 |
| | | I am a PhD student currently researching in algorithms for
partitioning of high-throughput OLTP row-store database systems. In
short, I search for...
jbdhl
|
08-14-2009 07:20 AM
jbdhl | 0 | 111 |
| | | Is failover clustering the only type of clustering available on SQL
Server 2008? More specifically, does SQL Server 2008 support Active/
Active...
imani_technology_spam@yahoo.com
|
08-12-2009 05:46 PM
imani_technology_spam@yahoo.com | 4 | 100 |
| | | At work I uncovered a join that (foreign key) references only part of
composite primary key on another table. the data in the composite PK
table...
Dave
|
08-12-2009 02:27 AM
Erland Sommarskog | 19 | 189 |
| | | I have a table in a SQL 2005 database which is brand new. As part of
our application deployment we load the table with about 2.6M rows.
Once that is...
Thomas R. Hummel
|
08-11-2009 04:47 PM
Erland Sommarskog | 3 | 208 |
| | | Is it possible to ping and return average round trip in ms in VBA?
T2B
|
08-10-2009 03:24 PM
T2B | 1 | 116 |
| | | Hello to all,
We have a very large table (>10 millions of rows) with all the
appropriate indexes. The problem arises when we need to get...
yioann
|
08-08-2009 03:43 PM
Erland Sommarskog | 1 | 139 |
| | | Hi
I work on a product that regularly has database issues. Use of
tempdb, locking problems, general performance problems. I often feel
its because of...
codefragment@googlemail.com
|
08-06-2009 02:58 PM
codefragment@googlemail.com | 0 | 108 |
| | | Dear Experts,
Is it possible to run something like BCP bulk copy tools at the UNIX
computer?
Regards,
Serguei.
Serguei
|
08-05-2009 04:00 PM
Erland Sommarskog | 1 | 144 |
| | | Hi,
is possible to change the first day of week on sql srv or AS?
actually, if i use the sql query "Select @@DATEFIRST" i see the day 7 of
the...
Carnefrisca
|
08-04-2009 04:37 PM
Erland Sommarskog | 3 | 253 |
