Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Programming

how to import emails

Hi All,
I'm being tasked with importing emails regarding service interruptions
from several different ISP's into SQL Server 2008 R2. I've never done
this before. Where should I start?
Thanks,
Eric

9/1/2010 8:08:11 PM

NNTP Programming

How to get 2 Max values?

I have following 2 tables (T1, T2) and rows:
T1 (Column: Id)
----
1
2
3
4
T2 (Columns: Id, Value)
----
1, 1
1, 2
1, 3
1, 4
2, 1
2, 2
2, 3
2, 4
3, 1
3, 2
3, 3
3, 4
4, 1
4, 2
4, 3
4, 4
The result-set I need is:
------------------------------ ---------
1, 3
1, 4
2, 3
2, 4
3, 3
3, 4
4, 3
4, 4
i.e for each Id from T1, I need 2 max values from T2.

9/1/2010 7:12:51 PM

NNTP Server

dealing with invalid dates

Hi,
Is there a way to deal with invalid dates during a select? Currently
I'm getting dates in a column in this format:
20100726 (yyyy/mm/dd)
I need to display it as 07/26/2010, so i was using this:
SELECT CONVERT(VARCHAR(10), CONVERT(datetime, startDate, 101), 101)
problem is startDate at times in not a valid date, sometimes there is

9/1/2010 6:16:26 PM

NNTP Server

SQLState=S1000, NativeError=0

I am trying to use the BCP command to execute the following statement, but I
keep getting the following error:
Starting copy...
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered
in
BCP data-file
0 rows copied.
Network packet size (bytes): 4096

9/1/2010 4:03:50 PM

NNTP Setup

*Canadian College Girls Hot Sex Videos

*Canadian College Girls Hot Sex Videos At [link]
Due to high sex content, i have hidden the videos in an image. in that
website on Right side below search box click on image and watch
videos in all angles.

9/1/2010 12:30:23 PM

NNTP Programming

Add Column / Drop Column Not Replicating in Subscription

Dear Sir,
I have created one publication & created one subscription for one database.
If I Add / Modify / Delete any records at Publisher or Subscriber level it
replicated in both database properly while synchronize it.
But if I Add or Drop any column of Table at publisher level it doesn't
replicated at subscriber level. Please note in Subscription option the value

9/1/2010 11:56:34 AM

NNTP Programming

subquery returned more than one value

When I run this query:
update a set a.[UPC] = b.[IDSCE], a.[AltDescription] = b.[IDESC], a.
[Weight] = b.[IMNNWU],
from [ProductVariant] a inner join [IIMWEB] b on a.
[SKUSuffix]=b.[IPROD]
I receive an error:
The statement has been terminated.
Msg 512, Level 16, State 1, Procedure trig_NotificationProduct, Line

9/1/2010 11:47:47 AM

NNTP Programming

SQL query Help

CREATE TABLE [dbo].[FileHeader](
[LedgerKey] [uniqueidentifier] NOT NULL,
[SubmittedDate] [smalldatetime]NOT NULL
CONSTRAINT [FileHeader] PRIMARY KEY NONCLUSTERED
([LedgerKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

9/1/2010 7:54:03 AM

NNTP Programming

Different databases join performance

Hi,
is it true that joining tables in different databases on the same SQL
server instance is slower than joining tables in the same database?
I read this article about join performance:
[link]
-- JOIN tables in same database
USE AdventureWorks;
DECLARE @StartTime datetime

8/31/2010 8:54:58 PM

NNTP Server

In SQL Server, Is the primary server status always 1089 ?

I want to filter on the primary server name using a query. Do you know if
the value '1089' is always the srvstatus for the primary server? Thanks in
advance! MC
select srvname
from dbo.sysservers

8/31/2010 8:01:37 PM

NNTP Programming

Need help to search for extra space in all tables.

I try to search for data which has some extra spaces in ALL TABLES.
Does any one know if there a tool that can do that or the scripts can return
all the data (see desire results below).
Thank you in advance. SQL2008.
IF OBJECT_ID('Tempdb.dbo.#T1', 'u') IS NOT NULL
DROP TABLE #T1
GO
CREATE TABLE #T1

8/31/2010 5:08:03 PM

NNTP Replication

merge and identity column screw up

Publisher w/ 2 subscribers running merge replication.
the data was on all three machines and the i changed tables on the
publisher so the identity column was in a different range. i wanted it
to be an increment of 2 and a seed of 100,000, but instead i set an
increment of 100,000 and a seed of 2.
well, now i need to get the identity columns correct, but they have

8/31/2010 1:47:18 PM

NNTP Setup

MSXML 6 is newer --> SQL2005 fails to install

The above problem is well known:
[link]
However the workaround [link] no longer
applies.
Any idea how to solve this? Is it possible (and recommended) to uninstall
MSXML6 via control panel?
tx Bernd

8/31/2010 8:07:40 AM

NNTP Server

Overwrite Master Db

Hi all,
I have a question about Master db in a DR environment. Our customer
has follow environment setup:
Live Site: SQL Server 2008 Standard
DR site: SQL Server 2008 Standard
Both share a SAN disk so that if the Live site is down, the DR site
will pick up all database request. But as the customer install both

8/31/2010 5:09:38 AM

NNTP Programming

Using tempdb as a users default database

Hi,
I would like to ask what people think of using Tembdb as a users
default database.
I ask this because, when the instance is re-started tempdb is
recreated and any user accounts in there are lost,
however, i beleive, that any user gets access to tempdb and master by
default.
The reason I make all my users have tempdb as their default database

8/30/2010 11:59:48 PM

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

pBlogCategories

sys.books