tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

SQL help

Dear All
Sql 2000
following is DDL and sample data
CREATE TABLE #tmp
(
Fname VARCHAR(20),
lname varchar (10),
Status char(1)
)
go
INSERT INTO #tmp VALUES ('John','Terry',null)
INSERT INTO #tmp VALUES ('Richard','John',null)
INSERT INTO #tmp VALUES ('Kubali','Tony',null)
INSERT INTO #tmp VALUES ('Tony','Greig',null)

9/9/2010 3:38:44 AM

NNTP Clustering

How to move MSDTC to another Cluster Group?

Hello,
We have 2-node, 1-instance clsuter (64-bit Windows 2003 and 64-bit SQL
2005). We now want to add another sql instance. Currently, MSDTC resource is
under the existing sql cluster group.
We want to move it to a new its own cluster group, or move it to the cluster
group along with Quorum, Cluster name, cluster ip resources.

9/9/2010 1:44:03 AM

Clustering

How to move MSDTC to another Cluster Group?

Hello,
We have 2-node, 1-instance clsuter (64-bit Windows 2003 and 64-bit SQL
2005). We now want to add another sql instance. Currently, MSDTC resource is
under the existing sql cluster group.
We want to move it to a new its own cluster group, or move it to the cluster
group along with Quorum, Cluster name, cluster ip resources.

9/9/2010 1:44:03 AM

NNTP Programming

DateTime Null Or Minimum Value

Hello,
I am working on a authentication system and I have the following:
create table dbo.Users
(
Id int identity not null,
LastLock datetime not null,
LastLogin datetime not null,
LastPasswordChange datetime not null,
LastReset datetime not null,
Username nvarchar(40) not null constraint Users_Username_U unique,

9/8/2010 11:48:54 PM

NNTP Programming

Doing the same over and over in different tables

Hi
i have to do the same operation several time on different tables.
I want to get the value of a column (baseline) from @tableName, store it
into a variable and use this to update @tableName later on.
The baseline column is a comma separated list of ids (didnt find a better
way other than to copy a line for each baseline...)

9/8/2010 9:51:03 PM

NNTP Server

Log Shipping and backups

Hello, I've read where once you setup log shipping in SQL2008 you
can't take any additional backups from your primary server. What's
with this? We have a dev environment and need to restore production
db once in awhile. If I setup log shipping how can I get a full
backup if we need it from our primary server?

9/8/2010 8:59:19 PM

NNTP Programming

why is this proc so slow?

Hi,
I have the below proc, it seems to be running very slow ever since i
setup encryption on one of the columns. running it takes almost 2
mins, but if i run the same script outside of the proc, just in query
analyzer it completes in 13 sec, i just don't get why the proc takes
longer as i thought proc would be faster since it's compiled. i'm

9/8/2010 6:34:17 PM

NNTP Replication

Log shipping and running backups

Hello, on SQL2K8 when setting up log shipping there is a Note on one
of the screens that says you can't take backups of the primary
database once log shipping is running. What's with this? We wish to
setup log shipping, we haven't yet, and we also have a development
environment where we will need the production db restored once in

9/8/2010 6:27:00 PM

NNTP Server

Possible problem with differential backups

Hi all,
I have a 170GB OLTP database that only processes INSERTs and SELECTs,
no UPDATEs or DELETEs. I add about 1.8GB of data every day, as
verified with my transaction log backups taken every 15 minutes. A
full database backup is created every Friday at 10PM and then
differential backups are created Sa, Su, Mo, Tu, We & Th at 10PM. The

9/8/2010 5:30:35 PM

NNTP Programming

Need Help for Parent Child Table Join Output

9/8/2010 3:05:38 PM

NNTP Programming

Help for MS Access homework

For our homework in our Computer science class, we were tasked to research by
asking expert advice on database forums. We were first asked to download
Census data to be analyzed using Microsoft Access. The data contained facts
about 1% all people living in large US Cities at the time on the last US
Census in the year 2000. The file gave the name of the city and the

9/8/2010 2:44:39 PM

NNTP Clients

mirror database

i have windows 7 starter. i installesd to instances of SQL Server. I created
in instance1 database DbA, filled by some data, made full backup and log
backup, then restored it on instance2. then in instance1 opened property of
DbA and started security wizard. it offered port 2022 for instance1, then I

9/8/2010 3:33:46 AM

NNTP Connect

mirror database

i have windows 7 starter. i installesd to instances of SQL Server. I created
in instance1 database DbA, filled by some data, made full backup and log
backup, then restored it on instance2. then in instance1 opened property of
DbA and started security wizard. it offered port 2022 for instance1, then I

9/8/2010 3:33:46 AM

NNTP Programming

EXEC syntax in sp

I have a stored procedure that I want to run another stored procedure inside
of it. I have the following line in the sp but it seems to be failing. What
am I missing? Thanks.
EXEC dbo.mc_insPayCheckDeductions @Branch=@Branch,
@CheckIDFrom=@CheckIDFrom, @CheckIDTo=@CheckIDTo, @PayPeriod=@PeriodEnding

9/7/2010 10:50:07 PM

NNTP Programming

Recursive Query

I've been working with a recursive query recently and I've been unable
to get the expected results. I'm looking to pull a customer purchase
record for each time they purchased a particular product and to give
them a discount if it's been over a year since they purchased a
product and then additional discounts if it's been a year since they

9/7/2010 9:54:25 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