sqlnotes.info

John Huang's Blog

John Huang's Blog. About SQL Server and Dot Net. Changed SoundEx Disables Index While Upgrading to SQL 2012. Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of it from SQL Server 2008 is C256. The solution is to rebuild indexes after restore. Posted by John H. Create Semaphore in Sybase. Continue reading ». Posted by John H. No More SQL Masters. Posted by John H. I blogged DB...

http://www.sqlnotes.info/

OVERVIEW OF sqlnotes.info

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

21

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLNOTES.INFO

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

January

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.1 out of 5 with 15 reviews

5 star

7

4 star

5

3 star

2

2 star

0

1 star

1

Hey there! Start your review of sqlnotes.info

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.7 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT SQLNOTES.INFO

1&1 Internet Inc. - www.1and1.com

Oneandone Private Registration

701 Lee●●●●●●●ite 300

Ches●●●●rook , PA, 19087

US

1.87●●●●4254

pr●●●●●●●●●●@1and1-private-registration.com

View this contact

1&1 Internet Inc. - www.1and1.com

Oneandone Private Registration

701 Lee●●●●●●●ite 300

Ches●●●●rook , PA, 19087

US

1.87●●●●4254

pr●●●●●●●●●●@1and1-private-registration.com

View this contact

1&1 Internet Inc. - www.1and1.com

Oneandone Private Registration

701 Lee●●●●●●●ite 300

Ches●●●●rook , PA, 19087

US

1.87●●●●4254

pr●●●●●●●●●●@1and1-private-registration.com

View this contact

1&1 Internet Inc. - www.1and1.com

Oneandone Private Registration

701 Lee●●●●●●●ite 300

Ches●●●●rook , PA, 19087

US

1.87●●●●4254

pr●●●●●●●●●●@1and1-private-registration.com

View this contact

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

DOMAIN REGISTRATION INFORMATION

REGISTERED: n/a
UPDATED: 2014 July 02
EXPIRATION: EXPIRED REGISTER THIS DOMAIN

BUY YOUR DOMAIN

NAME SERVERS

1: ns51.1and1.com
2: ns52.1and1.com

REGISTRAR

1&1 Internet AG (R113-LRMS)

WHOIS : whois.afilias.info

REFERRED :

CONTENT

PAGES IN
THIS WEBSITE

21

SSL

EXTERNAL LINKS

41

SITE IP

74.208.18.35

LOAD TIME

0.703 sec

SCORE

6.2

PAGE TITLE

John Huang's Blog | sqlnotes.info Reviews

<META> DESCRIPTION

John Huang's Blog. About SQL Server and Dot Net. Changed SoundEx Disables Index While Upgrading to SQL 2012. Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of it from SQL Server 2008 is C256. The solution is to rebuild indexes after restore. Posted by John H. Create Semaphore in Sybase. Continue reading ». Posted by John H. No More SQL Masters. Posted by John H. I blogged DB...

<META> KEYWORDS

1 downloads

2 about…

3 about me

4 about my posts

5 contact me

6 backup and restore

7 database administration

8 sql server central

9 share/bookmark

10 no responses

CONTENT

Page content here

KEYWORDS ON PAGE

downloads,about…,about me,about my posts,contact me,backup and restore,database administration,sql server central,share/bookmark,no responses,locking and blocking,miscellaneous,1 response,events*,tagged with event,len and datalength,programming,storage

SERVER

Apache

POWERED BY

PHP/5.4.42

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

John Huang's Blog | sqlnotes.info Reviews

https://sqlnotes.info

John Huang's Blog. About SQL Server and Dot Net. Changed SoundEx Disables Index While Upgrading to SQL 2012. Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of it from SQL Server 2008 is C256. The solution is to rebuild indexes after restore. Posted by John H. Create Semaphore in Sybase. Continue reading ». Posted by John H. No More SQL Masters. Posted by John H. I blogged DB...

INTERNAL PAGES

sqlnotes.info

1

Miscellaneous – John Huang's Blog

http://www.sqlnotes.info/category/miscellaneous

John Huang's Blog. About SQL Server and Dot Net. No More SQL Masters. It’s so sad to say that there will be no more Microsoft Certified SQL Server Master, Architect, and Solution Master any more after October 1, 2013. We all received this email. Posted by John H. Great Article Regarding Hash Joins. I came cross this article regarding Hash Joins. It explains the Hash Join/Match in great detail. Download it from here. Posted by John H. Great Place to Learn SQL Server 2012. Posted by John H. Open SSMS, go t...

2

SUM224CH – PASS Summit 2013 Discount Code – John Huang's Blog

http://www.sqlnotes.info/2013/05/20/pass-summit-2013-discount-code

John Huang's Blog. About SQL Server and Dot Net. 8211; PASS Summit 2013 Discount Code. Are you attending SQL PASS Summit 2013. In Charloote, NC, Octorber 15-18? To get $150 off. Posted by John H. One Response to “ SUM224CH. 8211; PASS Summit 2013 Discount Code”. September 14, 2013 at 3:17 pm. I used your code for my registry and it saved $150 for my company. Thanks John! Leave a Reply Cancel reply. You may use these. SQL Saturday #198 – Vancouver, BC – February 16th, 2013. Masters do it better!

3

Create Semaphore in Sybase – John Huang's Blog

http://www.sqlnotes.info/2013/11/07/create-semaphore-in-sybase

John Huang's Blog. About SQL Server and Dot Net. Create Semaphore in Sybase. Using sp getapplock is a perfect solution but I failed to find any procedures in Sybase functionally equivalent to sp getapplock in SQL Server.I have to create a binary Semaphore in Sybase so that both Sybase DBA and I can use the same mechanism to determine whether or not our processes can be started. I create a table called Semaphore in a user database in Sybase. Posted by John H. Leave a Reply Cancel reply. You may use these.

4

SQL Server Central – John Huang's Blog

http://www.sqlnotes.info/category/sql-server-central

John Huang's Blog. About SQL Server and Dot Net. Run T-SQL in Parallel. Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times by myself as well. After those coding exercises, I found few important things were not (or just partially) addressed. Termination of launcher session. Either the launcher session get cancelled or killed, running asynchronous workers should be cancelled. Posted by John H.

5

Generating Random Password by a T-SQL Procedure – John Huang's Blog

http://www.sqlnotes.info/2011/12/19/generating-random-password-by-a-t-sql-procedure

John Huang's Blog. About SQL Server and Dot Net. Generating Random Password by a T-SQL Procedure. To generate a complex password, we should not only get random value from the set of the characters but also guarantee the combination of upper case, lower case, numbers and special characters. In the procedure below, the password generated will include all 4 parts. Posted by John H. One Response to “Generating Random Password by a T-SQL Procedure”. December 20, 2011 at 2:20 am. Leave a Reply Cancel reply.

UPGRADE TO PREMIUM TO VIEW 16 MORE

TOTAL PAGES IN THIS WEBSITE

21

LINKS TO THIS WEBSITE

msbicoe.com

MS BICOE | May 2012

http://www.msbicoe.com/2012/05/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | December 2012

http://www.msbicoe.com/2012/12/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | April 2012

http://www.msbicoe.com/2012/04/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | August 2011

http://www.msbicoe.com/2011/08/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | November 2012

http://www.msbicoe.com/2012/11/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | September 2012

http://www.msbicoe.com/2012/09/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | December 2011

http://www.msbicoe.com/2011/12/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | April 2013

http://www.msbicoe.com/2013/04/default.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

msbicoe.com

MS BICOE | Archive

http://www.msbicoe.com/archive.aspx

All about SQL Server, Power BI and Data Analytics. Anna Bay and Camel Riding at Port Stevens. Sunset at Berowra Waters Lookout. Sydney Harbor View and Dishes at Altitude Restaurant. Steven Wang - 汪上洲. Steven is a data scientist and a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA. Steven is currently a Senior Manager, Data Analytics at IMS Health AUNZ. 160; . 160; . Master Data Service (1). SQL Server 2012 (8).

UPGRADE TO PREMIUM TO VIEW 32 MORE

TOTAL LINKS TO THIS WEBSITE

41

SOCIAL ENGAGEMENT

SqlNotes

OTHER SITES

sqlnoracle.blogspot.com

Sql and Oracle Database

Sql and Oracle Database. Monday, January 12, 2015. Oracle Error Inconsistent Control Files. Follow the following steps if you are facing inconsistent control files error in oracle database. Open the sqlplus and connect as sysdba user by the following command. Conn / as sysdba. Execute the following commands. Execute the following commands and you may change the path of control file if any. Alter system set control files='C: oracle product 10.20.0 db10g1 CONTROL01.CTL' scope=spfile;. Alter database open;.

sqlnote.com

sqlnote.com - Registered at Namecheap.com

This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.

sqlnotebook.info

SQL Notebook

SQL Server Msg 5070 Level 16 State 2 Line 4. May 13, 2015. Bull; No Comments. SQL Server Msg 5070 Level 16 State 2 Line 4 Database state cannot be changed while other users are using the database Cause Active processes accessing database Solution …. SQL Server Error 18456. May 7, 2015. Bull; No Comments. SQL Server Error 18456 Details Cannot connect to . Login failed for user . (.Net SqlClient Data Provider) Server Name: . Error Number: 18456 Severity: 14 State: 1 Line Number: …. SSIS Data Profiling Task.

sqlnotepad.com

Ассоциация прогрессивных психологов | Верь в себя – и все получится

Верь в себя – и все получится. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. You may use these. A href= title= abbr title= acronym title= b blockquote cite= cite code del datetime= em i q cite= strike strong. Скоро состоится перформанс Плейбэк театра. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. You may use these. Leave a Reply Cancel reply. You may use these. Proudly powered by WordPress.

sqlnotes.com

www.sqlnotes.com

This Web page parked FREE courtesy of StaffKit. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. Find Your Own Domain Name. See our full line of products. Easily Build Your Professional Website. As low as $4.99/mo. Call us any time day or night .

sqlnotes.info

John Huang's Blog

John Huang's Blog. About SQL Server and Dot Net. Changed SoundEx Disables Index While Upgrading to SQL 2012. Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of it from SQL Server 2008 is C256. The solution is to rebuild indexes after restore. Posted by John H. Create Semaphore in Sybase. Continue reading ». Posted by John H. No More SQL Masters. Posted by John H. I blogged DB...

sqlnotes.net

sqlnotes.net is under construction

Hosted by IX Web Hosting. Website is Under Construction. Is currently UNDER CONSTRUCTION. You can access your website from: 98.130.36.25. Permanent address access to this website will be available once all DNS servers update themselves in the next few days. Control Panel Login - User-friendly, fast and reliable. Site Studio - Easy to use Online Website Creator. Hosted by IX Web Hosting. MakeMeRich™ Affiliate Program. Become part of the record-breaking IX Web Hosting Affiliate Program. Click Here ».

sqlnotesfromtheunderground.wordpress.com

SQL Notes From The Underground

SQL Notes From The Underground. Enterprise Policy Management Framework. PowerShell Desired State Configuration (DSC). Sp attach single file db. Sqlserverbuilds.blogspot.co.uk. Undocumented SQL Stored Procedures. Using Excel VBA to Export SQL Data Series. Continue reading →. Continue reading →. PowerShell Script to Analyse SQL Server Trans Logs for Page Splits. Continue reading →. PowerShell Script to Analyse SQL Server Trans Logs for Page Splits. Continue reading →. Continue reading →. Continue reading &...

sqlnotificationservices.com

Boomerang Notification Services for SQL Server

Skip to main content. What Our Customers Say. Every aspects of our day to day operations are benefited from timely, tailored and accurate information being delivered to the right people. Boomerang notifications has helped us with everything from staying compliant with FDA regulations to managing supplier relationships" -Darin Lowery, Vice President of Operations, Permobil Inc. What Do We Believe In? Boomerang version 1.10.1 is out. March 10, 2015. Whats New This version adds eFax connector to the Boomera...

sqlnova.com

Welcome sqlnova.com - BlueHost.com

Web Hosting - courtesy of www.bluehost.com.

sqlnovice.blogspot.com

SQLNovice

From novice to professional on SQL Server technology. Tuesday, September 14, 2010. Where to find how many CPU's there are in your server? For version 2000 : exec xp msver 'ProcessorCount'. For version 2005 : sys.dm os sys info. Posted by Ning Xu. Friday, September 10, 2010. Flaw in sp helpdb system stored procedure. Well, it is the first time ever for me to encounter this problem, so I documented it here with 3external links which explain the cause and solution pertty well already: link1. The good thing ...