nishantdave.wordpress.com
Nishantdave's Blog | Just another WordPress.com weblogJust another WordPress.com weblog
http://nishantdave.wordpress.com/
Just another WordPress.com weblog
http://nishantdave.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
4
SSL
EXTERNAL LINKS
13
SITE IP
192.0.78.12
LOAD TIME
0.391 sec
SCORE
6.2
Nishantdave's Blog | Just another WordPress.com weblog | nishantdave.wordpress.com Reviews
https://nishantdave.wordpress.com
Just another WordPress.com weblog
nishantdave.wordpress.com
Nishant Dave | Nishantdave's Blog
https://nishantdave.wordpress.com/author/nishantdave
Just another WordPress.com weblog. Author Archives: Nishant Dave. I am working as a Tech.Lead at Silver Touch technology Pvt.Ltd Ahmedabad Gujarat India. Determine Which Queries Are Holding Locks – SQL Server. Following is a query to determine which queries are holding locks? SELECT DTL.resource type,. WHEN DTL.resource type IN (‘DATABASE’, ‘FILE’, ‘METADATA’) THEN DTL.resource type. WHEN DTL.resource type = ‘OBJECT’ THEN OBJECT NAME(DTL.resource associated entity id). SELECT OBJECT NAME([object id]).
Determine Which Queries Are Holding Locks – SQL Server | Nishantdave's Blog
https://nishantdave.wordpress.com/2012/07/02/determine-which-queries-are-holding-locks-sql-server
Just another WordPress.com weblog. SQL Server – Find missing and unused indexes. Determine Which Queries Are Holding Locks – SQL Server. Following is a query to determine which queries are holding locks? SELECT DTL.resource type,. WHEN DTL.resource type IN (‘DATABASE’, ‘FILE’, ‘METADATA’) THEN DTL.resource type. WHEN DTL.resource type = ‘OBJECT’ THEN OBJECT NAME(DTL.resource associated entity id). WHEN DTL.resource type IN (‘KEY’, ‘PAGE’, ‘RID’) THEN. SELECT OBJECT NAME([object id]). By running above giv...
sql server – How to find slowest queries | Nishantdave's Blog
https://nishantdave.wordpress.com/2012/06/30/sql-server-how-to-find-slowest-queries
Just another WordPress.com weblog. Reducing SQL Server Deadlocks. SQL Server – Find missing and unused indexes →. Sql server – How to find slowest queries. Following query is very useful to find the most slowest queries running on your sql server:. SUBSTRING(qt.TEXT, (qs.statement start offset/2) 1,. CASE qs.statement end offset. WHEN -1 THEN DATALENGTH(qt.TEXT). ELSE qs.statement end offset. END – qs.statement start offset)/2) 1),. Qstotal logical reads, qs.last logical reads,. Qstotal worker time,.
SQL Server – Find missing and unused indexes | Nishantdave's Blog
https://nishantdave.wordpress.com/2012/06/30/sql-server-find-missing-and-unused-indexes
Just another WordPress.com weblog. Sql server – How to find slowest queries. Determine Which Queries Are Holding Locks – SQL Server →. SQL Server – Find missing and unused indexes. Following one line query will give you all the details about missing and unused indexes:. SELECT * FROM sys.dm db missing index details. Posted by Nishant Dave. On June 30, 2012 in SQL SERVER. Tags: Find Missing Indexes. Improve SQL performance find your missing indexes. Missing Indexes in SQL Server. One response to “. Notify...
TOTAL PAGES IN THIS WEBSITE
4
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...
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...
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...
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.
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?
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
Coming Soon - Future home of something quite cool
Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.
nishantcopbcktrnswp7.codeplex.com
"Background Transfer Service Sample" From WP7 Sample - Home
Project Hosting for Open Source Software. 34;Background Transfer Service Sample" From WP7 Sample. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). This project is an extension to existing WP7 sample available from MS (Background Transfer Service Sample). This project extends functionality to display the background downloaded item to verify download. Last edited Jun 3, 2011 at 3:46 AM. Mon Jun 6, 2011 at 7:00 AM.
NISHANT CREATION
Grand opening in :. NISHANT CREATION YOGESH DARGE. Say Hello, Namaste, Namskar. We are here to help you Money through Friday. From 10:00 AM to 06:00 PM. You can also give us a call at ( 91) 9819777338. And pick option 1 to speak with our Support team. Want to meet us in real? If you have any further suggestions, questions or comments, here are the best ways to connect with us! 906, Ijmima Complex, Raheja's Matroplex, Link Road, Malad (W), Mumbai - 400 064., MH, India. You like taking the lead of line?
Leading Training & Development Institute in Dubai
Our Training and Development Methodology. Email & Business Writing Skills. Strategy & Decision Making. Business Process & Work Flows. Conflict & Team Management. Big Data Training Module. Data Analytics & Data Mining. Big Data Analytics (R Programming). Conducting Mystery Shopping Surveys. Establishing Business in U.A.E. Entrepreneurship Camps for Students. Intro to Renewable Energy. We offer unique and certified technical training programs in engineering efficiency and environmental sustainability that ...
Nishantdave's Blog | Just another WordPress.com weblog
Just another WordPress.com weblog. Determine Which Queries Are Holding Locks – SQL Server. Following is a query to determine which queries are holding locks? SELECT DTL.resource type,. WHEN DTL.resource type IN (‘DATABASE’, ‘FILE’, ‘METADATA’) THEN DTL.resource type. WHEN DTL.resource type = ‘OBJECT’ THEN OBJECT NAME(DTL.resource associated entity id). WHEN DTL.resource type IN (‘KEY’, ‘PAGE’, ‘RID’) THEN. SELECT OBJECT NAME([object id]). WHERE sys.partitions.hobt id =. DTLresource associated entity id.
New tab
Nishan Technologies
Alwar: 91- 9414211001 Gurgaon: 91- 8882727274, 93503 87274. Welcome to Nishan Technologies. Nishan Technologies New Delhi being professionally managed and technically sound organization with the aim to provide high-tech IT solutions at economical price, by a 10 years experienced technical professional Mr.Shiv Kumar Mishra, who has worked with the leading computer maintenance companies in India. Logos are us a tredemark to the respective Companies. Design By : GESIS Web.
Nishan Technologies
Excellent services, Affordable price. Services you can trust. Making it all make sense. We Make IT Happen. Empowering People. Solutions for a small planet. Our passion. Think outside the box. Simplifying technology. The Power to be your best. Your one stop solution. Creating value through true convergence. Welcome to Nishan Technologies. Sale Assembled Desktop Computers! Orignal Softwares Hardware Installations and Upgrades! Wired and Wireless Network Installations! Virus / Spyware Detection and Removal!
|| cyber hunter(TCA) ||
Hacked By Cyber hunter. F*ck India and other countries Who Are Against Muslims and Islam - -. I Will back soon :D. Maheer Haxor Sharjeel Haxor Sami Khan Mani Haxor Sp3x Girl And All Muslim Hackers.
nishant2 - Welcome to Nishant Engineers
LCD Display Hour meters. Digital Sound Level Meter. AC Axial Cooling Fan. Http:/ webgyortech.com/nishant2/images/Products/SLIDER/product slide1.jpg. Http:/ webgyortech.com/nishant2/images/Products/SLIDER/product slide3.jpg. Http:/ webgyortech.com/nishant2/images/Products/SLIDER/product slide4.jpg. Http:/ webgyortech.com/nishant2/images/Products/SLIDER/slider-2018.jpg. Http:/ webgyortech.com/nishant2/images/Products/SLIDER/slider-2018.jpg. Meet us at IESS VII an. An Iso 9001:2015 Certified Company. Develo...
