tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clients

SQL Server 2008 : INNER JOIN explicitely required ?

We have thousands of SQL statements in our app, which we are migrating to
2008 from SQL 2000. I read that we have to change the Outer Join statements
using the ANSI style syntax (like LEFT or RIGHT OUTER). Fine.
But do we need to change the SQL statements which doesn't use explicitly
'INNER JOIN', by adding 'INNER JOIN' ?. I know both will work just fine.

6/3/2010 1:51:59 PM

NNTP Setup

SQL 2008 clustering on Windows 2008 R2

Hello,
I like to setup a SQL 2008 two node cluster on Windows 2008 R2. I prefer to
have SQL binaries installed on a shared drive (say a LUN on SAN) so that I
need just one SQL license for this project. Here are my queries:
1. Can SQL binaries be installed on a shared drive for failover? I am not

6/3/2010 1:22:11 PM

NNTP Clustering

crossed up disk ids on sql 2005 active/active/active cluster

Hello,
I have to deal with crossed disk ids after SQL 2005 SP2 was installed on one
of newely added shared disks.
on node A and B I have:
disk 13 - T drive
disk 14 - V drive
disk 15 - W drive
but on node C same 3 disks got different ids because of usb drive ( gone now )
disk 14 - T drive
disk 15 - V drive

6/2/2010 7:54:29 PM

Clustering

crossed up disk ids on sql 2005 active/active/active cluster

Hello,
I have to deal with crossed disk ids after SQL 2005 SP2 was installed on one
of newely added shared disks.
on node A and B I have:
disk 13 - T drive
disk 14 - V drive
disk 15 - W drive
but on node C same 3 disks got different ids because of usb drive ( gone now )
disk 14 - T drive
disk 15 - V drive

6/2/2010 7:54:29 PM

NNTP Setup

SQL server 2005 :: Windows service is hitting my database every 10 sec Is any Performance Issue.

I have Windows service that it is Hitting my database MS SQL SERVER
2005 in every 10 sec.
and running sp's (each of size max is 2kb).
that's why I have a doubt
Is this any Performance Issue.
Will It become any slow of my database performance.
please reply me ...................Its Urgent

6/2/2010 1:31:26 PM

NNTP Setup

price list and acronyms

Microsoft Sql server price list has about 900 items.
Is somewhere an explanation for the acronyms used in it?
I'm speeking of OLV, NL, MVL, OLP, AE, EMEA, CLT, OLVD, CRP, SNGL, C, B, D,
ALNG, ACDMC, OVS, AP.
tnx in advance
Agostino

6/1/2010 12:55:07 PM

NNTP Setup

sql server installation "external component has thrown an exceptio

I have tried to install sql server 2008 on a windows server 2008 and running
into this problem repeatedly. Any suggestions on what to do to make the sql
server installation a success?
thanks.
-Rman

6/1/2010 10:23:01 AM

NNTP Clustering

event id 57 and event id 50 on primary cluster node

Hello,
After installing a new 64 b MS SQL 2005 SP2 instance on our prod SQL cluster
( 64b. windows 2003 ee sp2 ) I have noticed that every morning at exactly
same time the following warnings appear in windows system log:
Event Type: Warning
Event Source: Ftdisk
Event Category: Disk
Event ID: 57
Date: 5/31/2010

6/1/2010 12:54:01 AM

Clustering

event id 57 and event id 50 on primary cluster node

Hello,
After installing a new 64 b MS SQL 2005 SP2 instance on our prod SQL cluster
( 64b. windows 2003 ee sp2 ) I have noticed that every morning at exactly
same time the following warnings appear in windows system log:
Event Type: Warning
Event Source: Ftdisk
Event Category: Disk
Event ID: 57
Date: 5/31/2010

6/1/2010 12:54:01 AM

NNTP Replication

SWEDISH FALSE PASSPORT ID BUY ONLINE/FINNISH FAKE ID CARD SALE/GET FAKE NORWAY IDENTIFICATION CARDS

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, Spain, United

5/31/2010 4:35:33 PM

NNTP Connect

GET FAKE CANADIAN ID CARD/PASSPORT,GET FRENCH FALSE ID CARD/PASSPORT ONLINE,MEXICAN ID/PASSPORT

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, Spain, United

5/31/2010 4:32:23 PM

NNTP Setup

sql configuration manager

Is it possible to install ONLY SQL 2008 configuration manager and not the
entire client tools?
Anybody?

5/28/2010 2:41:01 PM

NNTP Setup

sql server 2008 r2 msdn downloads.

Guys, I've noticed something odd about the msdn downloads which someone could
comment on. For example, under sql server 2008 r2 I can see downloads for the
developer, enterprise, standard, web, workgroup, and data centre versions.
What's puzzling me is that each of the listed downloads is 4.177MB. I

5/28/2010 8:04:01 AM

NNTP Clustering

How to 100% pass MCSA MCSE 2003 MCITP MCDBA MCP MCAD MCSD COMPTIA A+ Network+ Security+

How to 100% pass MCSA MCSE 2003 MCITP MCDBA MCP MCAD MCSD COMPTIA A+ Network+ Security+
Linux+ Server+
Dear friends:
Now, you can get any International IT Certificate at Home without Taking Exams Yourself:
Never worry about failing to pass your IT certificate any more, since we can help you
achieve that easily. As a professional testing center, we can pass MCSE MCSA MCDBA MCSD

5/28/2010 5:50:44 AM

Clustering

How to 100% pass MCSA MCSE 2003 MCITP MCDBA MCP MCAD MCSD COMPTIA A+ Network+ Security+

How to 100% pass MCSA MCSE 2003 MCITP MCDBA MCP MCAD MCSD COMPTIA A+ Network+ Security+
Linux+ Server+
Dear friends:
Now, you can get any International IT Certificate at Home without Taking Exams Yourself:
Never worry about failing to pass your IT certificate any more, since we can help you
achieve that easily. As a professional testing center, we can pass MCSE MCSA MCDBA MCSD

5/28/2010 5:50:44 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

pBlogCategories

sys.books