SQL Server Education (by the geeks, for the geeks)
Hi Friends, SQL Server Management Studio offers a wide variety of Keyboard Shortcuts. By default, it uses the Standard scheme, with keyboard shortcuts based on Microsoft Visual Studio. A second scheme, called …
SQL Server Management Studio Keyboard Shortcuts Read MoreIn the Part I of this series we have seen how to create a calculated member using MDX expression. In this part, I am going to show the second option in …
Implementing Calculations in SSAS using MDX – Part 2 Read MoreHi Friends, We all know that there are 4 protocols that can be used to connect a SQL Server instance from a client; namely Share Memory, TCP/IP, Named Pipes & VIA. …
SQL Server: Which protocol is being used for client-server connectivity in SQL Server? Read MoreThe following timeline summarizes the development history of SQL Server: 1987 Sybase releases SQL Server for UNIX. 1988 Microsoft, Sybase, and Aston-Tate port SQL Server to OS/2. 1989 …
SQL Server Development History Read MoreAccording to BOL Repeatable transaction isolation level will give a repeated (consistent) view of the data for that particular resultset in a transaction.Here is the exact definition “Specifies that statements cannot …
SQL Server Phantom Reads In Repeatable read ??? I dont think so…. Read MoreDear All, Sometimes as DBA’s we need to perform certain action on all the tables in a database. Say, running DBCC Checktable, or disabling all constraints before a bulk load or …
Undocumented stored procedure sp_msforeachtable in SQL Server Read MoreHey Folks, You might be wondering about what this title deals with? This title makes you aware of the features which are removed or will be removed in the future while …
SQL Server: Going In Next, Going In Future, Gone With the Wind? Read MoreWhat are the differences between Delete and Truncate in SQL Server? This is one of the most frequently asked questions in SQL server interviews and the answer varies depending upon your …
Delete VS Truncate in SQL Server Read MoreYou may have noticed that Integration Service in SSMS 2005 does not list SSIS packages and Folders in any specific order. It’s random, most likely in the order we have added …
SQL Server: Ordering SSIS Packages and Folders in SSMS 2005 Read MoreHi Folks, You might have knowledge about this but do you know it deeply enough? Well I will try to give some heads up. As you know SQL was invented by …
SQL Server – ANSI SQL and T-SQL, What? Why? How? Read More