sqlmca.wordpress.com
SQL HELPER | Helps your Daily Database Activity – Kuldip BhattHelps your Daily Database Activity - Kuldip Bhatt (by Kuldip Bhatt)
http://sqlmca.wordpress.com/
Helps your Daily Database Activity - Kuldip Bhatt (by Kuldip Bhatt)
http://sqlmca.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Monday
LOAD TIME
0.7 seconds
16x16
32x32
64x64
PAGES IN
THIS WEBSITE
6
SSL
EXTERNAL LINKS
13
SITE IP
192.0.78.12
LOAD TIME
0.732 sec
SCORE
6.2
SQL HELPER | Helps your Daily Database Activity – Kuldip Bhatt | sqlmca.wordpress.com Reviews
https://sqlmca.wordpress.com
Helps your Daily Database Activity - Kuldip Bhatt (by Kuldip Bhatt)
sqlmca.wordpress.com
Microsoft BI stack – Tools and BI classification | SQL HELPER
https://sqlmca.wordpress.com/2015/06/05/microsoft-bi-stack-tools-and-bi-classification
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Microsoft BI stack – Tools and BI classification. Posted in business Ingellegence. Corporate BI – Use for Corporate traditional approach. Self Service Bi – means Cloud base office 365 BI. Learn querying, MongoDB with comparing SQL query. Azure Machine Learning ». Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Join 8 other followers.
Ranking Functions in Microsoft SQLSERVER | SQL HELPER
https://sqlmca.wordpress.com/2014/04/15/ranking-functions-in-microsoft-sqlserver
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Ranking Functions in Microsoft SQLSERVER. Today, We will see example of different ranking functions supported in Sqlserver. Use below script to create table. CREATE TABLE dbo.CustomerData. OrderId INT IDENTITY(1,1) NOT NULL,CustomerId INT,TotalAmt decimal (10,2). Populate data in table. INSERT dbo.CustomerData (CustomerId, TotalAmt). SELECT 1, 100. SELECT 1, 2000. SELECT 1, 560. SELECT 1, 1000. SELECT 1, 1000. SELECT 2, 1000.
Learn querying, MongoDB with comparing SQL query | SQL HELPER
https://sqlmca.wordpress.com/2015/05/22/learn-querying-mongodb-with-comparing-sql-query
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Learn querying, MongoDB with comparing SQL query. Select * from Data. DbData.Find() (Show all records with all columns.). Select year,importer,exporter,quantity from Data. DbData.find({},{year:true,importer:true,exporter:true,quantity:true, id:false}). In Mongodb field name must be case sensitive you can no write Year in place of year.). Select year,importer,exporter,quantity from Data where quantity 50. DbData.find({qua...
Kuldip Bhatt | SQL HELPER
https://sqlmca.wordpress.com/author/sqlmca
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Author Archives: Kuldip Bhatt. We may need to downgrade the tableau work book sometime, like if we mismatch server and desktop version difference then we have to match our Desktop version proper same as Tableau server so we can publish our workbook on server. Do this on your own risk …………………Please make copy of everything before do this. Follow below steps to down grade Work book. Open your twb file Notepad Editor. Today we w...
About Blogger – Kuldip Bhatt | SQL HELPER
https://sqlmca.wordpress.com/kuldip-bhatt
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Software Porfessional , Having experience on Dotnet – Micorsoft BI(SSIS, SSRS , SSAS), Sqlserver ,MongoDB , R – Predictive Analytics , Spotfire , Tableau. SKYPE – `kuldipbhattmca`. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out.
TOTAL PAGES IN THIS WEBSITE
6
How to find and replace text in large file | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08/03/how-to-find-and-replace-text-in-large-file
How to find and replace text in large file. August 3, 2011 at 4:36 pm. Back after a looooong break. This time I would like to replace text in a file. Hmm…. You might wonder that it’s so simple, Open file press ctrl F and replace from there. But here the file is very big in size. It’s 300 MB File. I’ve tried different editor to replace it but I’m failed and hopeless. I thought I need to replace it one by one. After creating file you need to fire below command from command prompt. Remember, you need to fir...
How to connect sqlserver from command prompt using sqlcmd / bulk insert | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08/03/how-to-connect-sqlserver-from-command-prompt-using-sqlcmd
How to connect sqlserver from command prompt using sqlcmd / bulk insert. August 3, 2011 at 5:28 pm. I need to insert large amount of records into sql server. The script is ready in file. The insert query is ready but the record is around 15 Lacs. SQL server gets time out every time I run the file from “SQL Server Management Studio”. Then I thought to do it from command prompt (whether anything can be done using cmd) as in my previous article I have used to replace text file from command prompt. Sqlcmd -S...
June | 2010 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06
Archive for June, 2010. User defined function to strip html in sql server 2005/2008. I need to strip html at many places in my project, I can do that by JavaScript function but I want some more common mechanism to strip html codes while getting the data from database. So I thought of using striping html @ database level and I searched on the net and here is the function for striping html. CREATE FUNCTION [dbo].[udf StripHTML]. SET @Start = CHARINDEX(' ',@HTMLText). SET @Length = (@End - @Start) 1. Respon...
Pranav's Blog | Just another WordPress.com weblog | Page 2
https://pranavrajyaguru.wordpress.com/page/2
Convert String Array to Long Array. As I told you I am back within no time. Yesterday, I have faced a problem where I want to convert string array into long array. I need to search a lot in internet for solving this and after a lot finding I came to this simple solution. String[] strArray = { “xyz”, “abc”, “def” };. Long[] lArray = Array.ConvertAll string, long (strArray, Convert.ToInt64);. It’s so simple, cheers🙂. June 3, 2010 at 11:08 am. I am back after a looooooooong time. Any guesses for the error?
COALESCE with DISTINCT in SQLServer | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/03/coalesce-in-sqlserver
COALESCE with DISTINCT in SQLServer. June 3, 2010 at 11:58 am. If you want comma separated values from columns it is so simple. Use COALESCE function provided by SQL Server. Select @csv = COALESCE(@csv ',','') cast(id AS VARCHAR) from tablename. COALESCE with DISTINCT Values. If you want, DISTINCT values in COALESCE function use inner table like below. Select @csv = COALESCE(@csv ',','') cast(id AS VARCHAR) from. SELECT DISTINCT id FROM TableName). Entry filed under: SQL Server. COALESCE in SQL Server.
User defined function to strip html in sql server 2005/2008 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/09/user-defined-function-to-strip-html-in-sql-server-20052008
User defined function to strip html in sql server 2005/2008. June 9, 2010 at 10:44 am. I need to strip html at many places in my project, I can do that by JavaScript function but I want some more common mechanism to strip html codes while getting the data from database. So I thought of using striping html @ database level and I searched on the net and here is the function for striping html. CREATE FUNCTION [dbo].[udf StripHTML]. SET @Start = CHARINDEX(' ',@HTMLText). SET @Length = (@End - @Start) 1.
The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2010/06/01/the-selected-class-cannot-be-deleted-because-it-is-used-as-the-return-type-for-one-or-more-datacontext-methods
The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. June 1, 2010 at 7:22 pm. I am back after a looooooooong time. Today I have faced one problem in dbml file. As soon as I tried to delete the table from dbml file it gave me below message:. The selected class cannot be deleted because it is used as the return type for one or more DataContext methods. Any guesses for the error? No problem, here is the solution. Cheers………🙂. 1 Comment Add your own.
June | 2008 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2008/06
Archive for June, 2008. New feature of Visual Studio 2008. Hi Friends, This is my first post in my blog. I am using Visual Studio 2008 for a month and I was just searching for any new features in it. I have just checked a great feature in Visual Studio. Debug in source files. Yes, my friend, what you have heard is true. Debug in source code. You just need to set few settings and you can debug how your grid is bind or how DataAdapter. Fill() method works or anything you want to debug. Click Here.
August | 2011 | Pranav's Blog
https://pranavrajyaguru.wordpress.com/2011/08
Archive for August, 2011. Getting Request.ServerVariables from asp.net. Here is the method of getting all server variables in asp.net from Request.ServerVariables. Response.Write(“ table border=’1′ ”);. For (int i = 0; i Request.ServerVariables.Count; i ). String key = Request.ServerVariables.Keys[i];. String.Format(“ tr td style=’border:1px solid;’ {0} /td td {1} /td. This will list all the server variables in the page in table format…. August 12, 2011 at 4:28 pm. Eg once you have typed above command co...
TOTAL LINKS TO THIS WEBSITE
13
SQL Matters Home
SQL Server blogs, articles, scripts and tips. You can alert someone to the contents of this page by emailing them a link. All fields are required. Only one email address can be specified. To email address :. Your email address :. To prevent abuse please type the security code below into the box underneath. Please enter the security code above :. You can view our privacy policy using the link at the bottom of each page. Recent Blogs and Articles. Posted by SQL Enthusiast. Welcome to SQL Matters. Sp who2 i...
Coming Soon
Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor.
SQLMax | SQL Server Database Solutions
Bull; Info@SQLMax.com. We Provide Long Lasting. Discover 20 factors we consider to design a solution. Stored Procedures, Functions, SQL Jobs, SSIS Packages. OLAP Cubes Tuned by Us. Developers Have Relied On. Systems Designed by Us. From A to Z. 1 Business Logics and Standards. 4 Business Growth Trends. 5 Big Data and BI Requirements. 9 Acceptable Number of Concurrent Users. 11 Acceptable Response Time. 13 Technologies Capabilities and Restrictions. 14 End Users and Tec supports Expertise.
SQLMaze
For over a decade we've been making businesses competitive with innovative system solutions. Our mission is to help our clients become more competitive in their business. What makes us different? Is your managed services company partnership helping you compete in today’s rapidly transforming global economy? SQLMaze provides expertise at this connection of business and technology using the following guiding set of principles:. Understanding our clients’ competitive advantage. Reducing time to market.
青岛门窗|青岛推拉门|青岛折叠门--青岛圣其莱门窗有限公司
电话 13006510808 传真 82512051 E-mail shengqilaiqd@163.com. 公司地址 青岛即墨市通济办事处城马路南站西侧 主营项目 青岛门窗,青岛推拉门,青岛折叠门 技术支持 知道网络.
SQL HELPER | Helps your Daily Database Activity – Kuldip Bhatt
Helps your Daily Database Activity – Kuldip Bhatt. About Blogger – Kuldip Bhatt. Microsoft BI stack – Tools and BI classification. Posted in business Ingellegence. Corporate BI – Use for Corporate traditional approach. Self Service Bi – means Cloud base office 365 BI. Learn querying, MongoDB with comparing SQL query. Select * from Data. DbData.Find() (Show all records with all columns.). Select year,importer,exporter,quantity from Data. Select year,importer,exporter,quantity from Data where quantity 50.
SQL Server 2008 MCM Exam - Microsoft Certified Master
SQL Server 2008 Microsoft Certified Master. SQL Server 2008 Microsoft Certified Master (MCM). Accelerated Exam Preparation Program. Accelerate your path to MCSM. The new SQL Server MCSM (Microsoft Certified Solutions Master) program is coming soon from Microsoft! Next Program Start Date is pending (approximately Sept 2012). It will be scheduled when new SQL MCM 2012 exam dates are released. Is this for me? A 2 month subscription for practicing with 20 SQL MCM-level labs in a hosted SQL Server VM environm...
A Database Blog | Thoughts and findings about SQL Server and databases in general
Thoughts and findings about SQL Server and databases in general. Installing the GUI on Windows Server 2012 Core. June 26, 2013. By SQL MCM FTW. In preparing to set up a new SQL Server 2012 AlwaysOn cluster, I ran into an issue when I unintentionally installed Windows Server 2012 Datacenter in Core mode (no GUI). This is an easy problem to fix if your systems have unfettered Internet access. Switch from Windows 2012 Core to GUI modehands on! Many thanks to the p0w3rsh3ll blog! January 16, 2013. Local lang...
Mike Donnelly, SQLMD | The Database Doctor Is In . . .Training
Mike Donnelly, SQLMD. The Database Doctor Is In . . .Training. Basic Powershell SQL Backup – 2008. Basic Powershell SQL Backup – 2012. Heading off into the Sunrise. I have some news I have been wanting to blog about for some time – I’m moving to Tokyo. T-SQL Tuesday #065 – Teach Something New (Roundup). With Ed’s #sqlnewblogger. Going on and lots of regular #tsql2sday folks there was a big turn out this month for the topic of teaching something new. In no particular order:. Russ Thomas (aka @SQLJudo.
#1 Rated SQL Database (MDF) Repair Tool - Repair Corrupt SQL Database (MDF) File
Outlook PST File Repair. MS SQL Database (MDF) Repair. MS SQL Database (MDF) Repair. Facing one or the other below mentioned issues while accessing SQL database:. Frequent error messages when trying to open SQL Server. Unable to access any of the tables stored in the SQL database. SQL Server responding late or hangs up at times. None of your queries were executing properly or is giving inconsistence results. DML operations do not execute properly and prompts error messages every time. Abrupt shut down of...
SOCIAL ENGAGEMENT