Login
Register
Friday, September 10, 2010
Home
Upcoming Events
Feeds
SQL Blog feeds
SQL Server @ DIGG
SQL News
SQL Server KB's
SQL Posts
Feeds
»
SQL Posts
Â
tblMashedUp
SQL Blogs on MSDN
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