blog.sqltechie.com
SQL ServerHi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah
http://blog.sqltechie.com/
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah
http://blog.sqltechie.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
3.2 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
7
SITE IP
172.217.6.83
LOAD TIME
3.155 sec
SCORE
6.2
SQL Server | blog.sqltechie.com Reviews
https://blog.sqltechie.com
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah
blog.sqltechie.com
SQL Server: How to find index usage
http://blog.sqltechie.com/2006/05/for-every-developer-and-dba-index.html
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. How to find index usage. In SQL Server 2005 Dynamic Management View sys.dm db index usage stats. Contains counts of different types of index operations and the time each type of operation was last performed. Every operation like seek, scan, lookup, or update on the specified index is counted as a use of that index and increments the corresponding counter in this view.
SQL Server: June 2014
http://blog.sqltechie.com/2014_06_01_archive.html
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. 160;Its data type that stores values of various SQL Server-supported data types. 160;In certain conditions where we are not sure about datatype we can define it as sql variant for testing purpose. 160;Its supporting int,char and binary value but will not support char(max)/varchar(max)/nvarchar(max) . Links to this post. Labels: SQL Server Programming. Recently we ha...
SQL Server: Jobs
http://blog.sqltechie.com/p/jobs.html
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. As a part of SQL Server Development task we has also number of openings and we require number of good Developers/DBAs. So If you feel that you fit in this position please mail me your resume at shahamishm at gmail.com. Subscribe to: Posts (Atom). Amazon Contextual Product Ads. Sp addlinkedsrvlogin - To modify or add new login on linked server. Various way to calcula...
SQL Server: January 2014
http://blog.sqltechie.com/2014_01_01_archive.html
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. Insert Statement Comparison - Interesting Test. Performance of Inserts in Database. I just written an articel about how we can get benefit of Delayed Durability to handle large amount log activity and related locking issues. Which leads to I/O condention. You can take a look for article at here. Links to this post. Labels: SQL Server Tuning. To enable from SSMS.
SQL Server: How to do running sum using CTE - SQL Server
http://blog.sqltechie.com/2009/04/how-to-do-running-sum-using-cte-sql.html
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. How to do running sum using CTE - SQL Server. Many time we need to do runing sum of value. In SQL 2oo5 we can do it with use of CTE. We have table which have monthwise data for 2 years. We want running sum monthwise , which needs to reset on start of year. Here we can see it do running sum monthwise , and it resets as start of year. Labels: SQL Server Programming.
TOTAL PAGES IN THIS WEBSITE
19
test - SQL Server
http://www.sqltechie.com/test-1
You must be logged in to add gadgets that are only visible to you.
TOTAL LINKS TO THIS WEBSITE
7
SQLSaturday > Home
Welcome to PASS SQLSaturday. Free, high quality, 1-day, SQL Server Training events. You’ll find it’s a great way to spend a Saturday. Welcome to PASS SQLSaturday. Have SQLSaturday questions or suggestions? Feel free to contact the PASS SQLSaturday HQ Team. No tweets for this event yet. Join the conversation by tweeting sqlsat. Brought to you by your local PASS Community. SQLSaturday is a trademark of PASS. Have a question about the site?
sqlshare.com - This website is for sale! - sqlshare Resources and Information.
The domain sqlshare.com. May be for sale by its owner! Find Top Site For sqlshare Here. Find Search Results For sqlshare Here. Top Concerts in the US. Find out the best options for concerts, comedy, and more! Find sqlshare here now for all the best options. Http:/ www.zerodirect1.com. Patent Beauty Tips for Girls. Pantene Beauty Tips for Girls. This page provided to the domain owner free. By Sedo's Domain Parking.
SQLSnee.com
SQL Server Reference Links. January 20, 2014. One of my favorite subjects in SQL server is. And one of my favorite security topics is. This post will cover a script I wrote to recreate a user’s permissions within a database. I call it my User Clone Script. And use it quite heavily. Copying permissions between development/test/production environments. Refactoring permissions to use a SQL Server. Instead of explicit user permissions. Highlights of the Script. This script has support for the following:.
SQLsprawl.com
MSSQL Smart Sheets by SQLsprawl.com. Quick references to everyday SQL tasks and they are FREE. PASS is an independent, user-led, not-for-profit organization co-founded by Microsoft and CA in 1999. It was created to build a body of individuals that would provide expertise to help educate millions of SQL Server users around the world. PASS is run by volunteers and operates globally through its websites, sponsored events, yearly Summits, and localized Chapter activities. Tuesday, October 30, 2012. There are...
SQL Stunts
MySQL 8.0 - auto increment feature gets fixed. How InnoDB initializes AUTO INCREMENT counters is actually not a bug, but a documented mechanism. There were some complaints and even people who lost data. To initialize an auto-increment counter after a server restart, InnoDB executes the equivalent of the following statement on the first insert into a table containing an AUTO INCREMENT column. SELECT MAX(ai col) FROM. With MySQL 8.0. New tool: GitHub's online schema migration for MySQL. In spite of being a...
SQL Server
Hi I am working with SQL Server Database and BI (SSAS, SSRS,SSIS) since last 8 years with some of worlds large databases. Cheers Amish Shah. How to set shortcuts in query editor. If we set short cuts for commands like sp lock, sp helptext , sp who2 it can be handy as its. Frequently required for any developers. Lets see how to set short cut for this in query editor. Go to Tools- Option- Environemnt- Keyboard- Query Shortcuts. Set shortcuts here for your favorite and frequently used commands. Problem in o...
SQL Thoughts | SQL Server, T-SQL, Performance Tuning, Optimization
Monday, November 17, 2014. This is a general mistake that many developers do and sometimes goes unnoticed while reviews and testing, but then suddenly one day start appearing as bugs. Many developers understand and (misinterpret) varchar as variable-length data type and hence doesn’t specify the length in the variable definitions which is incorrect. Here are some examples of ‘weird’ Read More. Friday, July 25, 2014. Today my colleague asked me, what is the difference between GetDate() and GetUTCDate()?
Business Intelligence and Agile Development
Business Intelligence and Agile Development. Agile methods for the Database and BI Developer. Tuesday, January 17, 2012. Installing and Configuring Apache Hadoop for Windows. As has been mentioned in previous posts, I’ve been spending a lot of time recently working with “Big Data” technologies and have been working more recently with Apache Hadoop. And associated distributed computing and analytics mechanisms. What Exactly Is Hadoop? Preparing to Install Hadoop. The first thing you’ll need to do in...
SQLWorkshops.com Blog | Microsoft SQL Server Performance Monitoring & Tuning
Microsoft SQL Server Performance Monitoring and Tuning. Skip to primary content. Skip to secondary content. Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1). December 4, 2014. The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There is no possibility of data loss in the event of SSD failure as the cached data is clean (unmodified pages). The best way to...
Vedran Kesegic Blog | SQL Server Articles, Tips and Tricks
Darr; Skip to Main Content. RCSI and LOB data – how tempdb version store is used? 2 Comments ↓. Row Version Store We know RCSI (Read Committed Snapshot Isolation), as well as SI (Snapshot Isolation) use row versioning to store previous verions of rows in part of tempdb called “row version store”. If you are using default isolation level …. Read more ›. Page Life Expectancy and 300 sec limit. 2 Comments ↓. Read more ›. Speaking at SQL Saturday Budapest #sqlsatbudapest. No Comments ↓. Read more ›. Tagged w...
Sqm vendas
11 de dez de 2013. Nova Web Rádio v3 - Administrativa. É isso ai Galera a Sqm vendas acaba de Lança mais uma versão de web rádio. Administrativa para que já conheçe esse o modelo do site nh digital pois agora ele esta em uma nova versão. E tambem podendo fazer alterações dentro do painel lebrando que ele leva o sPanel DJ. Para mais informações fale com o nosso atendimento online ou via ticket em nosso site,. E para adiquiri esse site basta assinar um de nosso planos que oferece site grátis. Devido a isso...
