|
|
|
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 ...
|
SQL Server to SQL Server over the Internet
Fri, 26 Feb 2010 09:49:01 -0800
I have a requirement, actually more of a â??really-like-toâ?, to set up a Sql
Server 2005 to Sql Server 2005 data posting option over the internet.
Obviously things like security, logins and port numbers come into play but
what I am looking for in terms of advice is best methodology. Iâ??ve looked at
Link ...
|
stored procedure or view?
Fri, 26 Feb 2010 15:14:11 GMT
I would like to replace a value in a column provided it meets my conditions.
For instance, if formtype = w123' then set formtype = 'PRO' if formtype =
'w344' then set formtype = 'INT'.
I am fairly new to creating a stored procedure on SQLServer. Do you think
this would require a stored procedure or a view? ...
|
|
|
