Some of the Recently Published MSIT Case Studies

I would like share with you some of the recently published MSIT case studies below. It gives you a good insight that how Microsoft IT use Microsoft products and technologies. How Microsoft IT India’s Test Organization Enabled Efficient Business Intelligence The Microsoft IT India Test Organization business intelligence (BI) solution is a highly interactive, flexible,…

0

Announcement : MEA Services Webcast Series

I’m really happy to announce that as MEA services team we have started an initiative to share our experience more with the public community. As a starting point we have organized a list of upcoming webcasts that you can attend to gain more in-depth information from the field about Microsoft products and technologies. Learn how…

1

How to Find Which SPs Use Forced Index

One of the periodical DBA task is to examine index usage statistics with sys.dm_db_index_usage_stats DMV and to find unused indexes. After that these unused or rarely used indexes can be dropped if they are really not used. But before that you should examine if these indexes forced in any of SQL Server objects such as…

1

If you lost some intermediate backup files?

It’s sometimes really challengeable to restore a database if you lost some intermediate backup files such as Full or Differential backups. Let’s assume backups have been taken in below order. Timeline Backup Type Backup Name t1 Full Backup F1 t2 Diff Backup D1 t3 TLog Backup T1 t4 TLog Backup T2 t5 Full Backup F2…

0

Recap – SQL Saturday 258, Istanbul

After SQLSaturday 258, Istanbul, finally I get some rest and find a free time to write about great success of this event. If you would ask me “Can you describe SQLSaturday 258, Istanbul with only one word?”, I would probably say “It was just FANTASTIC!”. Continue reading If you want to understand why I described…

0

EXEC vs. sp_executeSQL

When we want to execute a TSQL string we can use both EXEC and sp_executesql statements. But there are some very important differences between them sp_executesql allows for statements to be parameterized Therefore It’s more secure than EXEC in terms of SQL injection sp_executesql can leverage cached query plans. The TSQL string is built only…

8

The 3rd SQL Saturday in Turkey is Coming to You on 5th October, 2013

I am really proud to announce that SQLPass Turkey Chapter is organizing the 3rd SQL Saturday in Turkey, which will be held on 5th October 2013 at Microsoft Istanbul Office. This time international speaker submissions are accepted and the final schedule has 9 international speakers from UK, Portugal, Ukraine, Russia, Germany and so on. Yeah,…

0

Data Mismatch on WHERE Clause might Cause Serious Performance Problems

Like Applying Function on WHERE clause problem, any datatype mismatch on WHERE clause might cause serious performance problems. Predicates on both sides of comparisons (for example on WHERE clause) always must match datatypes. It means that if the left side of predicate is integer than the right side needs to be integer. If the datatypes…

1

My Upcoming Presentations at SQLSaturdays and SQLRally Nordic Events

The last quarter of 2013 calendar year is going to be really hectic. Next three months I will be speaking at 4 SQLSaturdays and SQLRally Nordic. Details are below Dec 7,2013 – SQLSaturday #259 – Kharkov, Ukraine Nov 4-6,2013 – SQLRally Nordic – Stochkholm, Sweden Oct 26,2013 – SQLSaturday #199 – Bulgaria Oct 5,2013 –…

0

Applying Functions on WHERE Clause Columns might Cause Serious Performance Problems

Any function such as collate, convert, substring etc. applied on a column might make impossible for SQL Server to use any index on this column. This because SQL Server query optimizer considers the column after the function as a new column, because the column values are not stored in the index pages as returned by…

2