|
|
|
problem with select
Sun, 28 Feb 2010 13:59:01 +0100
Hi,
we have some tables with name begins with figures( like 98765_order).
This causes a syntax error when doing a select (select * from 98765_order).
Anyway to solve this easily?
Thanks
Luc
...
|
Auto update statistics versus manual statistics update
Sat, 27 Feb 2010 21:30:01 -0800
I have the following two questions:
1) If auto update statistics is on, would there ever be a reason why I might
want to run update statistics manually or via maintenance plan?
2) What condition triggers auto update statistics to run? If there are many
insert/update/delete to a table, would SQL know to up ...
|
Proc cache consumed with one-time queries
Sat, 27 Feb 2010 13:19:01 -0800
In investigating memory usage os our SQL Server 2005 SP3, I noticed that
about 4.3GB of our 32GB phsyical memory was consumed by the procedure cache.
In looking at what was in the cache, I found that the overwhelming majority
of the stored plans were from queries that will never be reused. In fact
4.1GB of t ...
|
Feasibility of using sql server express
Sat, 27 Feb 2010 17:05:34 -0000
Hi
Is sql server express ok for a 20 user contacts database which is used
mostly for queries and rarely has updates or inserts?
Many Thanks
Regards
...
|
Optimizer choice doesn't make sense, goes from index seek to table
scan when adding a SARG
Sat, 27 Feb 2010 11:27:56 -0500
Running on SQL Server 2008 SP1.
The following select (correctly) uses a non-clustered index on
ACCT_TYP_CD returning just over 15000 rows in 41ms. It does a single
scan and needs 37 logical reads to complete the query.
select acct_cd
from CS_FUND
where ACCT_TYP_CD = 'G';
Change the query to be this:
...
|
Supertypes/subtypes and primary keys
Fri, 26 Feb 2010 22:43:34 -0800
This is a design question. Here's hoping Joe Celko haunts this newsgroup ;)
The relevant DDL will be at the bottom of the post.
We have two entities -- sporting events and "product" which could be a cup,
shirt or a fee. Obviously, events have a number of attributes not needed
for "product". The natural ...
|
Sacramento, CA SQL Server group
Fri, 26 Feb 2010 19:04:00 -0800
I'm looking for people in the Sacramento, CA area that would like monthly,
or bi-monthly SQL Server User Group meetings.
Though there are several rough spots to get over (not the least of which is
a meeting place), I'm hoping that there are enough to make it worthwhile.
...
|
|
|
INserting Records into Table
Fri, 26 Feb 2010 12:56:06 -0800
I am in need of some help. I am very new at SQL so please disregard my
ignorance.
I have a table where I have a field named â??persNoâ? is set up as the primary
key. This is working well as I donâ??t want duplicate records. The problem is
what I am trying to do is update the table with new records. The ...
|
BUY FAKE PASSPORTS OF FRANCE,FAKE FRENCH PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORTS
Fri, 26 Feb 2010 11:11:27 -0800
Our team is a unique producer of quality fake documents.
We offer only original high-quality fake passports, driver's licenses,
ID cards, stamps and other products for a number of countries like:
USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
Germany, Israel, Mexico, Netherlands, South Africa, ...
|
Difference between ORDER BY column value and column alias between
different version of SQL server.
Fri, 26 Feb 2010 10:36:06 -0800 (PST)
Hi,
SQL Server 2005/2008. Is the following correct (apologies for trivial
example)?
SELECT -member_id AS member_id
FROM members m
ORDER BY member_id
--Orders by column alias
SELECT -member_id AS member_id
FROM members m
ORDER BY m.member_id
--Orders by column value
In SQL Server 2000, both the abo ...
|
|
|
