Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

space in log file cannot be reused

Im a GP tech and I recently ran a GP company DB upgrade on SQL05 - 5
companies made it - one did not. I tried 2 more times and ran into this
error each time:
transaction log for company ID full. To find out why the space in the log
cannot be re-used see the log_reuse_wait_desc column in the sys.databases?

3/9/2010 7:09:01 PM

NNTP Programming

Optimizing query

I have a query where the execution plan is showing a table scan with 32%
cost.
I have tried to put indexes on pretty much all the fields and still get the
same result.
The predicate from the Query Analysers execution plan for this table is:
[dbo].[REVIEWER].[EnvironmentI D]=[@EnvironmentID] AND
([@NameChoice] IS NULL OR CASE WHEN

3/9/2010 7:06:36 PM

NNTP Programming

Supporting Oracle as well as SQL Server

Hi all,
I have just been asked if we can support Oracle as well as SQL Server.
And what the implications are.
A bit about our setup. Basically we deal in data - there is an app,
but it is secondary to the data. Lots of data migrations etc. We have
a complicated database schema with loads of constraints and loads of

3/9/2010 6:36:49 PM

NNTP Server

Supporting Oracle as well as SQL Server

3/9/2010 6:36:49 PM

NNTP Programming

order by case value

If I have the following:
SELECT
UserID as RID
,EnvironmentID as EnvID
,@authorType as RType
,'A' as Type
,'Author' as FullType
,Case
When (isnull(FirstName, '') <> '' AND isnull(LastName, '') <> '') then
LastName + ', ' + FirstName
When (isnull(FirstName, '') <> '' AND isnull(LastName, '') = '') then

3/9/2010 6:04:31 PM

NNTP Server

Capture Bulk Insert Duplicate Rowcount

SQL Server 2008 Std, SP1, Windows 2008
I am using bulk insert to load a large amount of data into my database. The
tables have a primary key with the ignore duplicate values turned on.
Everything works just fine, but I would like to track the number of rows from
the input file that do NOT get loaded due to a duplicate value. Does anyone

3/9/2010 5:50:01 PM

NNTP Server

Default Degree of Parallelism on SQL Server 2005

Is there guidelines, suggestion or could somebody point me to articles which
discuss how to determine the optimum degree of parallelism?
I suppose the biggest factor is going to be cxpacket waits. My problem is
how do I determine when cxpacket waits exceed the treshold.
Thanks in advance

3/9/2010 5:40:01 PM

NNTP Server

SQL SERVER 2005 Database Engine Tuning Advisor Error "Statement does not reference any tables"

hi guys,
I had a trace file from production (almost all stored proc execution
events) and I'm using it to tune agaist the exact copy of production
database. After running an hour, the progress shows in the Reason
column almost all "Statement does not reference any tables" and
there's no recommendation at all. In the statement column for DTA, it

3/9/2010 5:23:04 PM

NNTP Server

Attunity with SQL Server

Hello everyone,
I just wonder if there's anyone who uses\used Attunity with their SQL Server
environment?
I would appreciate if you have any experience, suggestion or tips to share
with me.
Thanks,
Ekrem Önsoy - SQL Server MVP

3/9/2010 3:55:01 PM

NNTP Server

SQL Server 2008 - Performance Alert Recommendations

Hello,
I have just completed a migration from SQL Server 2000 to 2008 and am in the
process of applying the finishing touches on the SQL 2008 server. I am
currently creating Alerts and was looking for recommendations on what
performance alerts to add. I have added a few obvious ones like Deadlocks =

3/9/2010 3:47:01 PM

NNTP Replication

RMO Conflict Resolver - Could not load file or assembly

We are in need of help with a problem dealing with RMO conflict resolvers in
merge replication. This is our first shot at it so we may have missed
something simple. We created a RMO conflict resolver in SQL 2008 SP1:
Imports System.Reflection
<Assembly: AssemblyKeyFile("ConflictResol vers.snk")>
Namespace Progeny.NITSS.ConflictResolver s

3/9/2010 3:11:58 PM

NNTP Programming

Full outer join on 3 tables. How to?

Hi,
I have 3 tables:
1) table a:
id int
colA int
2) table b:
id int
colB int
3) table c:
id int
colC int
If I'm given an id (e.g. @id = 2), how do I query the three tables for rows
that match @id? I need a full outer join. For example, if table c is the
only table containing a row matching @id the return values (colA, colB,

3/9/2010 2:38:15 PM

NNTP Setup

SQL Server 2008 R2 Install Error - The account name is invalid

I am having this problem also. I have a 2005 instance and a 2008 instance and
am attempting to add a 2008 R2 instance on my Windows XP SP3 machine. I keep
getting the below error. Everything seems to install correctly except the
database engine.
Thanks,
Neal
2010-02-17 15:08:42 Slp: Sco: Attempting to get account sid for user account

3/9/2010 2:19:02 PM

NNTP Server

Index on a Timestamp Column

I have been asked to index the Timestamp column on our main source system
database (1.3TB). The proposed index's are to help decrease the load time of
our datawarehouse. My question is, are timestamp columns good candidates for
indexes. (The warehouse selects between two timestamp values) considering the

3/9/2010 1:34:07 PM

NNTP Programming

Option(RECOMPILE)

I have a UDF say Which is caluculating salary of an employee by using
Cusror.
Now i m using that UDF in a View in which i m passing it Id for a
value in view.
That's working fine if no of records are say around 1000 but if No are
Increasing then View is working very slow
Because foreach row in view that function is executing and Output is

3/9/2010 9:30:31 AM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56

pBlogCategories

sys.books