THAKURVINAY.WORDPRESS.COM
Vinay Thakur – Sql Server DBA | http://twitter.com/ThakurVinayhttp://twitter.com/ThakurVinay (by Vinay)
http://thakurvinay.wordpress.com/
http://twitter.com/ThakurVinay (by Vinay)
http://thakurvinay.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
6
SSL
EXTERNAL LINKS
17
SITE IP
192.0.78.13
LOAD TIME
0.563 sec
SCORE
6.2
Vinay Thakur – Sql Server DBA | http://twitter.com/ThakurVinay | thakurvinay.wordpress.com Reviews
https://thakurvinay.wordpress.com
http://twitter.com/ThakurVinay (by Vinay)
thakurvinay.wordpress.com
Whats New 2014 | Vinay Thakur
https://thakurvinay.wordpress.com/2014/12/19/whats-new-2014
Re-initialize replication not working. Hey its time for 2016! December 19, 2014. Continue to my whats New series, I am going through its new features and the more I am reading it impresses me a lot. and I am feeling that this is it. I really like it. Other what’s new series are SQL Server 7. SQL Server 2008 R2. And SQL Server 2012. Now its time for SQL Server 2014(I know 2016 is coming on its way). You can get all my Whats New blog @ What’s New. Tag(hope this will goes well). Sql server 2014:”. Buffer Po...
hey its time for 2016!!! | Vinay Thakur
https://thakurvinay.wordpress.com/2015/05/29/hey-its-time-for-2016
Whats new in SQL Server 2016 →. Hey its time for 2016! May 29, 2015. Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can read books online for it. Http:/ www.microsoft.com/en-us/server-cloud/products/sql-server-2016/default.aspx. First blog from mobile ….happy leaning…. This entry was posted in sql 2016. What I learned today. And tagged sql 2016. Whats new in SQL Server 2016 →. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
Vinay Thakur | http://twitter.com/ThakurVinay | Page 2
https://thakurvinay.wordpress.com/page/2
Newer posts →. TempDB Contention 2.1.%. October 16, 2013. When you are performing many DML operations and makes tempdb contesnion on it, You may get wait resource of 2.1.103. Temp Tables Creation Rate. Temp Tables For Destruction. When you are performing many DML operations and makes tempdb contesnion on it, You may get wait resource of 2.1.1 and 2.1.3. For 21.1 and 2.1.3:. Check tempdb is on seperate LUN (drives). Enable the trace flag -T1118. Enable trace flag -T1118. Try not us create temp objects.
Vinay | Vinay Thakur
https://thakurvinay.wordpress.com/author/hivinay
May 7, 2016. As you know this has been introduced in sql server 2016, I am not going in details on it but would like to highlights some points which I learned today: YOU WILL NEVER GET/READ THE REAL DATA FROM “SQL SERVER … Continue reading →. What I learned today. SQL Server 2016 …whats new…WOW! April 1, 2016. Index Rebuild VS Reorganize. January 11, 2016. SQL Server 2016 – whats new…lets see. January 11, 2016. What I learned today. Installation SQL Server 2016. December 15, 2015. July 31, 2015. While le...
Re-initialize replication not working | Vinay Thakur
https://thakurvinay.wordpress.com/2014/02/22/re-initialize-replication-not-working
Sql Cluster Resource not comming online. Whats New 2014 →. Re-initialize replication not working. February 22, 2014. But what if you run it several time but nothing happens and you don’t know whats going on, as it don’t provide you the error any where and also it will not show where is it going and what it is doing. for you it’s just like nothing happening. Cannot drop the table ‘xxx’ as its it is being referenced by object ‘yyy’. This may save some time for some one…. This entry was posted in Add/remove.
TOTAL PAGES IN THIS WEBSITE
6
sql solace: Dev 101
http://sqlsolace.blogspot.com/p/most-referenced-tsql.html
SET STATISTICS TIME ON;. SET STATISTICS IO ON;. While loop and table variable. Error Handling - TRY / CATCH. Instant Messages in Management Studio. RAISERROR ('my message', 10, 1) WITH. While loop for Incremental (nibble) DELETE / UPDATE. Conditional WHERE, LIKE, ORDER BY using CASE. SSIS 2008 / SQL 2008 / .NET. Date from datetime -. V1 - DATEADD(dd, DATEDIFF(dd,0,GETDATE() , 0). V2 - SELECT CAST(DATEDIFF(D, 0, GETDATE() AS DATETIME). Date formatting - SELECT CONVERT(VARCHAR(30),GETDATE(),21).
sql solace: Calculators
http://sqlsolace.blogspot.com/p/byte-calculator.html
1 Byte = 8 Bit. 1 Kilobyte (KB) = 1024 Bytes. 1 Megabyte (MB) = 1048576 Bytes. 1 Gigabyte (GB) = 1073741824 Bytes. 1 Terabyte (TB) = 1099511627776 Bytes. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.
sql solace: SSRS
http://sqlsolace.blogspot.com/p/ssrs.html
Dynamically Changing Cell Colour. Solace : Reporting Services 2005 : Installing IIS on Windows 2008. Solace : Reporting Services 2005 : Installing 32bit version on a 64bit server. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.
sql solace: Investigating a (suddenly) slow running query...
http://sqlsolace.blogspot.com/2015/05/investigating-suddenly-slow-running.html
Thursday, May 28, 2015. Investigating a (suddenly) slow running query. Some Questions / lines of enquiry . What else was going on on the server at that time? Is another process monopolising resources (memory, cpu, i/o). Any change in data volume (influx of new data). Is all maintenance happening? It won't take long to check). Are statistics up to date. How is index fragmentation. Are backups occurring (remember full backups control log fie growth). Can the query be run manually? Look at Execution plan.
sql solace: Plan Cache Pollution
http://sqlsolace.blogspot.com/2015/05/plan-cache-pollution.html
Thursday, May 28, 2015. They say if you can't explain something easily, you don't understand it well enough. For that reason, I'm revisiting some things I take for granted. The Plan Cache is where SQL Server stores exection plans. If queries are not parameterized, the plan cache fills with lots of similar queries of hard coded values. SELECT mycolumns FROM mytable WHERE myid = 1. SELECT mycolumns FROM mytable WHERE myid = 2. SELECT mycolumns FROM mytable WHERE myid = 3. Subscribe to: Post Comments (Atom).
sql solace: Community Contributions
http://sqlsolace.blogspot.com/p/rated-posts.html
SQL People Interview (2011/10/03). SQL Server Club : Understanding Collations. 2011/10/03 : SQL Server in the Evening (Farnham) - CSI SQL : Auditing SQL Servers. SQL Server Central : Script of the Day Submissions. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.
sql solace: September 2014
http://sqlsolace.blogspot.com/2014_09_01_archive.html
Monday, September 22, 2014. Ctrl E (Execute) Not working? In SQL 2012 Management Studio, my favourite shortcut for running scripts stopped working mysteriously, A message in the bar at the bottom read . Ctrl E) was pressed. Waiting for second key of chord. The reset instructions are shown below the screenshot. The 'fix' for this, is. Go to Tools Options. Open the 'Environment' section of the tree and select 'Keyboard'. On the right you will see a 'Reset' button. Links to this post. And added myself to th...
sql solace: SSIS
http://sqlsolace.blogspot.com/p/ssis.html
My SSIS Bookmark Pages-. SSIS : Best Practices. SSIS : Error Handling and Checkpoints. SSIS : Lookup Component. Search for All posts categorised with SSIS. Subscribe to: Posts (Atom). CTE to create a sequence of numbers. Simple template. Powered by Blogger.
sql solace: February 2015
http://sqlsolace.blogspot.com/2015_02_01_archive.html
Monday, February 9, 2015. Optimizing SQL Server I/O. In I/O terms SQL Server should be running on a platform that allows it to achieve a single figure latency (ms - millisecond) from the underlying storage. Out of scope for this post are hardware considerations, but I shall list those items as things to check or questions to pose for your IT team. What are the speeds and throughput (IOPs) of the drives in question? If physical drives, how are they configured? The access pattern for reading and writing Da...
TOTAL LINKS TO THIS WEBSITE
17
Index of /
Thakur Travel
If you wish to know something about India, you must empty your mind of all preconceived notions, don't try to compare. India is different, and as exasperating as it may seem, would like to remain so - this is the secret of India, the acceptance of life in all it's fullness, the good and the evil. Do you want to discover a part of India? On request I can arrange for larger groups, additional guides in all other languages, and tours and tracking in all parts of India.
haasaru
Sunday, 8 May 2011. Uses maumoon to gether support to them as a political tool? Are they afraid to prove the corruption of the former regime cause they themselves have corruption going in the government. hmm. Links to this post. Friday, 6 May 2011. Was the dolloar change good or bad? Links to this post. Thursday, 5 May 2011. Protest or Public Disorder? Links to this post. Monday, 2 May 2011. Calls to arrest former government officials poltical drama? Links to this post. Protest to bring down the price?
Varun Cuteness Singh
Learn more about Varun Cuteness Singh. He lives in hearts! BS in Patience, MS in Happiness, PhD in Smiling. Varun Cuteness Singh. His name says it all! So kind, so positive, and so full of care, he is indeed one of a kind. He has tiny eyes that disappear when he is happy and he has an aligned nose that he is oh, so proud of! Not to mention his tiny ears that are barely visible on the sides and his beautiful smile that says it all that speaks more than words could ever! He has a knack of flashing his ange...
Vinay Thakur – Sql Server DBA | http://twitter.com/ThakurVinay
Vinay Thakur – Sql Server DBA. Whats new in SQL Server 2016. July 31, 2015. While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with great new advance features and stable SQL Server(just like after 2005 to SQL Server 2008). To learn more about SQL Server 2016 whats new Microsoft has launch a new site call docs.com which will have quite a great videos and information. Which will contains all the videos about whats new in SQL Server 2016. What I learned today.
VJ | Highly Converting Landing Page Designer | Unbounce
Create an Awesome Landing Page From Highly Converting Landing Page Designer. Highly Converting Landing Page. Create an Awesome Landing Page From. Highly Converting Landing Page. Highly Converting Landing Page Designer. I am VJ , I am top rated upwork freelancer with 98% job success rate. I am 26 years young , energetic, focused and dedicated geek. Availability : 40 hours for 5 days/Week. Design is my lifestyle. see how my life is look like. If you are reading this then you are looking for a right person ...
Thakur Wadi Online !
Search, Register and Transfer Web Domain Names and More
24/7 Sales and Support (480) 624-2500. Thakur International, Nepal. DOMAIN NAMES ▼. WEB HOSTING ▼. SSL and SECURITY ▼. EMAIL ACCOUNTS ▼. MARKETING TOOLS ▼. BUILD A WEBSITE ▼. Check My Web Mail. WITH A NEW, NON-DOMAIN PURCHASE. ALREADY OWN A DOMAIN? ADD HOSTING, EMAIL AND MORE. PRICED .US DOMAINS! GET A FREE DOMAIN. WITH A WEB HOSTING, QUICK SHOPPING CART, OR WEBSITE BUILDER PURCHASE. From only $18.99/yr. From only $8.99/yr! Get your domain name today! All of our domains are loaded with free extras. From ...
Thakur Enterprise
We develop and implement cutting-edge strategies, enabling companies to increase their online market share and maximize their profits. We feature ground-breaking research and a proven business system, positioning us to take advantage of current trends in the economic market place, in North America and around the world. Your life. Your way. Isn't it time to find a better balance between your life and your work? Think outside the cubicle. Ready to Explore Your Options? Why settle for ordinary?
thakurz
SOCIAL ENGAGEMENT