SQL2K8 training videos

March 23, 2009 | Leave a Comment

In the latest issue of the SQL Server Magazine, there was an attachment for some of the training videos which pointed to this site:

http://getonthecase.com

and when you go there, it is a re-direction to the ISV Innovation site:

http://www.isvinnovation.com/SQL/Default.aspx

Over there, you will get 8 different video tutorials. In case you have not gone over those yet, take a look - they are very well done and gives you a lot of very good information about the new feature sets of SQL Server 2008. These are the 8 tutorials:

1) Uncovering T-SQL on SQL Server 2008.
2) Working with unstructured data in SQL Server 2008.
3) Working with asynchronous data in SQL Server 2008.
4) Deploying managed code to SQL Server 2008.
5) Developing for SQL Server 2008 using Visual Studio.
6) SQL Server 2008 and ADO.Net Entity Framework Integration.
7) Communicating with SQL Server 2008 using HTTP.
8 ) Working with SQL Server 2008 and Disconnected Clients.

Posted by | Filed Under SQL 

Orphaned DTC Transaction

May 24, 2008 | Leave a Comment

A few days ago, one of our applications was crashing the IIS application pool because of an unhandled exception. After some research we figured out the case of it was an orphaned MS DTC transaction.

When multiple connections are operating over one MS DTC transaction, this problem sometime shows up. As many connections are working none of them try to roll back the MS DTC transaction, this creates an orphaned connection, which crashes IIS application pools.

You can figure out if there is orphaned connection or not in your application using the following script. If there is an orphaned connection it will show up in the result (s), otherwise the script will return no results.

SELECT DISTINCT(req_transactionUOW) FROM sys.syslockinfo WHERE req_spid = -2

We fixed this issue using Hotfix provided by Microsoft.

Posted by | Filed Under SQL, Troubleshooting 

Handy Query Analyzer and SSMS shortcuts - Part II

April 28, 2008 | Leave a Comment

Shortcut Function   Shortcut Function
ALT+BREAK Cancel a query   CTRL+SHIFT+F2 Clear all bookmarks
ALT+F1 Database object information   CTRL+SHIFT+INSERT Insert a template
ALT+F4 Exit   CTRL+SHIFT+L Make selection lowercase
CTRL+A Select all   CTRL+SHIFT+M Replace template parameters
CTRL+B Move the splitter   CTRL+SHIFT+P Open
CTRL+C Copy   CTRL+SHIFT+R Remove comment
CTRL+D Display results in grid format   CTRL+SHIFT+S Show client statistics
CTRL+Delete Delete through the end of the line   CTRL+SHIFT+T Show server trace
CTRL+E Execute query   CTRL+SHIFT+U Make selection uppercase
CTRL+F Find   CTRL+T Display results in text format
CTRL+F2 Insert/remove bookmark   CTRL+U Change database
CTRL+F4 Disconnect   CTRL+V Paste
CTRL+F5 Parse query and check syntax   CTRL+W Window selector
CTRL+G Go to line   CTRL+X Delete
CTRL+H Replace   CTRL+Z Undo
CTRL+I Index Tuning Wizard   F1 Help for Query Analyzer
CTRL+K Display/hide execution plan   F2 Move to next bookmark
CTRL+L Display execution plan   F3 Repeat last search
CTRL+N New query window   F4 Object Search
CTRL+O Connect   F5 Execute a query
CTRL+P Print   F6 Switch between query and result panes
CTRL+R Show/Hide results pane   F8 Show/hide Object Browser
CTRL+S Save   SHIFT+F1 Transact-SQL help
CTRL+SHIFT+0 Show options   SHIFT+F2 Move to previous bookmark
CTRL+SHIFT+C Comment out code   SHIFT+TAB Decrease indent
CTRL+SHIFT+DEL Clear the active Editor pane   SHIFT+F6 Switch panes
CTRL+SHIFT+F Save results to file   TAB Increase indent

Posted by | Filed Under SQL 

Handy Query Analyzer and SSMS shortcuts

April 28, 2008 | Leave a Comment

Use them every day :

Shortcuts:

2000 – isqlw –To open a query analyzer in 2000

2005 – sqlwb—To open SSMS in 2005 (Not Query analyzer For New Query use Alt+N)

2005 –ssmsee—TO open SSMS in 2005 (Express Edition)

The most commonly used keyboard shortcuts in the SQL Server Management Studio (SSMS).

Run and then SqlWb.exe to launch SQL Server Management Studio

Results in Grid
Ctrl + D

Change database
Ctrl + U

Results in Text
Ctrl + T

Execute Query
Ctrl + E or F5

Show/Hide Object browser
F8 (Auto Hide has to be enabled)

New Query Window
Ctrl + Q

New Query with New Connection
Ctrl + N (Then selecting SQL Server Query template)

Open a .SQL Script file
Ctrl + O

Full Screen
Shift + Alt + Enter

Parse the query
Ctrl + F5

Show/Hide Results Pane
Ctrl + R

Switch between query and results panes
F6

Information about all the objects in the current database
Alt + F1

Posted by | Filed Under SQL 

Next Page »