Earlier, I wrote about my experience at an organization here: SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script. This blog post briefly narrates another experience I had at the same organization. When I was there, I also looked at the statistics and found something that I would like to bring [...]
: : THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Davide Mauri Entire Site Search Home Blogs Forums Downloads Opml Davide Mauri A place for my thoughts and experiences on SQL Server , Business Intelligence and NET BI Virtual Chapter : Adaptive BI : Engineering a BI Solution” On the next 20th Semptember I’ll deliver a session on a topic that is IMHO really important but is not yet covered : enough Adaptive BI : Engineering a BI Solution Are you starting to create a BI solution . but where do you begin with How to setup everything correctly so that you'll be able to handle new features required by the customers easily and without too much effort Which standard do you put in place so that everyone who will join the project
SQL Azure isn’t SQL Server hosted on the internet. It’s a little bit different. After reading lots of printed words about Azure, I decided I wanted a simple visual overview of what it is and what it is not and I’m sharing it with you. I started by connecting to my SQL Azure database using SQL Server 2008 R2 (the free Express edition will work just fine for this). I used the Options button to assign azure as the color of my query window. The RGB values for azure are 240, 255, 255 in case you’re wondering....(read more)Few days ago, I wrote about SQLAuthority News – Spicejet Complain – Do Not Fly with Spicejet. I had written detail report to them with the name of the airport ground staff. I got response from them that they investigated everything and it was just normal delay. Everything was good. There were not issue at [...]
Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pumelling recalcitrant correlated subqueries.
If you are not keen on repetitive typing, you can still rapidly produce production-quality documented code by planning ahead and using Extended properties, and system views. Phil Factor explains, with some Scary SQL
Last Year I wrote article on the subject SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. It is very good to see excellent participation there. In my script I had not taken care of table schema. SQL Server Expert Ameena has modified the same script to include [...]
, , , , , , THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in Join Help in Kevin Kline Entire Site Search Home Blogs Forums Downloads Opml Kevin Kline See You in St Louis , and then London , Amsterdam , Copenhagen , Stockholm , and York , UK Good grief , there's a lot of travel in my future . Meet Me In St . Louis I'll be speaking in St . Louis , MO on Tuesday , September 14th for their mid-day meeting . The details , as I have them , are : Tuesday , September 14, 2010 1-4pm Location : Microsoft St . Louis Office , Three City Place Drive , Suite 1100, St . Louis , MO 63141 http : www.microsoft.com about companyinformation usaoffices northcentral stlouis.mspx Parking is in the garage behind next to the building . There is an entrance toI wrote an article before on SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats. In that article, I promised that I would give a follow up post with a few more interesting details. I suggest that you go over the earlier article first to understand the details on B-Tree and [...]
I have heard many people saying that if they create view and index on it, this will reduce the load on original table as all the subsequent queries on view will not access the basic table. This is not true always and the view may not give you the performance optimizations which you are looking [...]
I recently delivered fast track data warehouse training. This training was very challenging as this training requires very specific hardware and extremely different way of looking at data warehousing. While training I have made few notes and I will now share the same notes with you. Please note that this are just notes and not [...]
No story today – I am sure all of you know what I want to talk today. I am indeed not happy with how social media is evolving. There was a time when every social media has its own style and concept. Today wherever I go, I see the same thing. Same news, same update [...]
Just a day ago, I was reading the blog post of Michale J Swart. If you are a regular reader of this blog, I am sure you will be familiar with him. He is a very interesting blogger for sure. He recently wrote an article about Ten Things I hate to See in T-SQL; it [...]
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically man of the performance tuning. [...]
Today I am very happy as my daughter is one year old. I have no words to explain how lucky I am to be father of daughter. She is everything to me and my wife have (sweet) complain that I stopped paying attention to her since our daughter has arrived. Check out here one year [...]Monthly round ups are very refreshing as it gives me chance to go back and see what did I do in last month. The highlight of the last month is the my computed column series and its final installment. If you have not followed up on it I suggest you read SQL SERVER – Computed [...]I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more than a year now. I [...]The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, [...]
I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could [...]Years ago I had written about the subject SQLAuthority News – Airline Review – Paramount, Kingfisher, Go Air, Indigo, Jet Airways, Indian Airlines, Spicejet; today this blog post confirms that there is no change in my ranking. There is one change I would like to propose: Remove Spicejet from ranking completely! My recent experience with [...]
Note: I have updated the title based on feedback of Davide Mauri (Solid Quality Mentors). Thank you for your help. Let’s see another reason why I do not like Views. Regular queries or Stored Procedures give us flexibility when we need another column; we can add a column to regular queries right away. If we [...]Today is quick puzzle time. Does the order column used in WHERE clause matter for performance? I recently heard from someone it does matter and a senior SQL person was able to reproduce it, but again I have no proof for it and I have not seen it before. Here are the rules for you [...]SSMA for Oracle v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. SSMA for Access v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, [...]I recently got opportunity to speak at Virtual Tech Days on August 18, 2010 on the subject Spatial Database. The event was heavily attended by enthusiasts world wide. I delivered session the on the subject of Spatial Database and it was great fun to deliver the session. I have delivered similar session many times before [...]
Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let us start with the first well-known limitation. Order By clause does not work in View. I agree with all of you who say that there is no need of using [...]
This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER – Computed Column – PERSISTED and [...]
I am really enjoying writing about computed column and its effect in terms of storage. Before I go on with this topic, I suggest you read the earlier articles about computed column to get the complete context. This is the list of the all the articles in the series of computed column. SQL SERVER – [...]I have sent of function library where I store all the UDF I have ever written. Recently I received email from my friend requesting if I have UDF which manipulate string and returns only very first word of the statement. Well, I realize that I do not have such a script at all. I found [...]
I just had interesting conversation with one of my friend who said identity value can not start from Zero. I told him that it can even start from negative value. He did not believe it. I quickly come with example and he was surprised to see it. USE [AdventureWorks] GO IF EXISTS (SELECT * FROM [...]I was getting many request to update SQL Server Interview Questions and Answers I had written couple of years ago. I have modified the original document a bit and corrected few of the typos and errors. I have really enjoyed going over all the Interview Questions and Answers. It has been the most popular subject [...]