-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
OK, so that is quite a contradictory title, but unfortunately it is true that a common misconception is that the query with the highest percentage relative to batch is the worst performing. Simply put, it is a lie, or more accurately we dont understand what these figures mean. Consider the…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
Has anyone done, or is aware of any, calculations to compare the cost of power and cooling compared to the cost of hardware (servers) in a typical data center? This is to compute a true total cost of ownership of self-hosting servers. Of course real TCO includes:
hardware_cost + power + cooling +…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a program to use the IMDB database and am having very slow performance on my query. It appears that it doesn't use my where condition until after it materializes everything. I looked around for hints to use but nothing seems to work. Here is my query:
SELECT *
FROM name as n1
FULL JOIN…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
Just wonder how much cost to raise a java exception (or to call native fillInStackTrace() of Throwable) compared to what it cost to log it with log4j (in a file, with production hard drive)...
Asking myself, when exceptions are raised, does it worth to often log them even if they are not…
>>> More
-
as seen on YBBest
- Search for 'YBBest'
Recently, I am working on an issue with threshold. The problem is that when the user navigates to a view of the document library, it displays the error message “list view threshold is exceeded”. However, in the view, it has no data. The list view threshold limit is 5000 by default for…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single [...]
>>> More
-
as seen on Geeks with Blogs
- Search for 'Geeks with Blogs'
In my search of better understanding the scalability options of SQL Azure I stumbled on an interesting aspect: Query Hints in SQL Azure. More specifically, the MAXDOP hint. A few years ago I did a lot of analysis on this query hint (see article on SQL Server Central: http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/)…
>>> More
-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
More hardware normally delivers better performance, but there are exceptions where it can hinder performance. Understanding these exceptions and working around it is a major part of SQL Server performance tuning.
When a memory allocating query executes in parallel, SQL Server distributes…
>>> More
-
as seen on SQL Blogcasts
- Search for 'SQL Blogcasts'
It is widely know that data modifications on table variables do not support parallelism, Peter Larsson has a good example of that here . Whilst tracking down a performance issue, I saw that using the OUTPUT clause also causes parallelism to not be used. By way of example, first…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
Today’s SQL in Sixty Seconds video is inspired from my presentation at TechEd India 2012 on Speed up! – Parallel Processes and Unparalleled Performance.
There are always special cases when it is about SQL Server. There are always few queries which gives optimal performance when they are…
>>> More
