Viewing 15 posts - 1 through 15 (of 47 total)
Most used DMVs
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_os_performance_counters
sys.dm_os_sys_info
sys.dm_os_sys_memory
sys.dm_db_missing_index_columns
sys.dm_db_missing_index_details
Most used DMFs
sys.dm_db_index_physical_stats
sys.dm_db_stats_properties
sys._dm_exec_sql_text
May 6, 2018 at 10:18 pm
The level of normalization can provide some clue about whether it could be an OLAP or OLTP. If you see much denormalized tables and also most queries being read-only, it...
April 5, 2018 at 10:32 pm
Denali is going to be SQL Server 2012 🙂
January 8, 2012 at 3:49 am
I hope the SQLNCLI contains inside itself both the SQLOLEDB and SQLODBC providers, and it seems Microsoft is going to throw away SQLOLEDB soon, and SQLNCLI will be exclusively based...
September 13, 2011 at 12:45 pm
September 6, 2011 at 9:15 am
September 1, 2011 at 7:45 am
ok, so its the carelessness of the developer which causes a lot of different "same name" applications to appear when seen from a database perspective. I understand that it needs...
August 31, 2011 at 1:03 pm
I have not known about any such "conversion" option yet, but even SQL 2005 template doesnt work in SQL 2008 Profiler. possibly, they forget about backward compatibility whenever designing a...
August 31, 2011 at 12:58 pm
you can view that in the "End User License Agreement" which appears as soon as the product key is entered in setup.
August 8, 2011 at 4:10 am
I would always recommend the "Inside SQL" series books.. though it is not intended to be for the beginner, it still helps to understand many topics related to SQL server...
August 8, 2011 at 4:02 am
Thayal Muhunthan (8/5/2011)
August 5, 2011 at 4:21 am
I had been looking for a complete overview of the exam of this kind, for quite a long time. Good to see it now. Appreciate your efforts!!
August 5, 2011 at 12:25 am
By default, SQL Browser is installed with the Express editions, and since thats always a named instance this is always being required!! There are many non-DBAs who could accidentally disable...
July 21, 2011 at 1:44 pm
GSquared (7/18/2011)
Windows 7 isn't using Win32 as its core any more. That's the whole point.Have you tried on a 64-bit Windows XP system?
thats interesting.. I noticed Windows 7 runs...
July 18, 2011 at 2:09 pm
sdeepa (9/9/2010)
Hi All,Please contact me or give me references of MCTS certified perosnnel for our openings in SQL DBA L1 support.
thanks
Deepa.
Is MCTS certification really essential for an L1 support engineer?
May 5, 2011 at 3:27 am
Viewing 15 posts - 1 through 15 (of 47 total)