Browsing Category

SQL Blogs

SQL and SQL Server database topics. Includes design, issue resolution and tips.

SQL Blogsby Rudy1 min4,392

Remote Desktop won’t go back to Full Screen Part 2


Earlier this year, I wrote about Remote Desktop not returning to fullscreen after minimization in Windows 7. The solution is to use Control-Alt-Break to bring the remote desktop window to full screen. And life was grand. I noticed some comments that people had Laptops where their keyboard did not have a Break key.
Continue reading “Remote Desktop won’t go back to Full Screen Part 2”

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter

SQL Blogsby Rudy1 min3,054

Display results Horizontally in SQL Server

We are all familiar with seeing our data in a vertical format from SSMS. Here is a sample:

SELECT  *
FROM    #EmployeeJobs
 
Employee_ID	Job_id
100	500
100	501
100	502
100	503
100	504
191	501
191	502
191	503
191	505
188	503
188	504

But what if you, or your customer want’s the data horizontally? That is easy enough with a CTE. Continue reading “Display results Horizontally in SQL Server”

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter