Browse by Tags

Working with SSAS traces and the dreaded Textdata in SSMS

This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2012/02/04/working-with-ssas-traces-and-the-dreaded-textdata-in-ssms/

Posted to Andrew Calvett (Weblog) by ACALVETT on Sat, Feb 4 2012
Great feature…. or not!!

I noticed a feature in SQL Server 2008 which I couldn’t remember seeing before, it’s remarkable that you can use something every day and still not know everything about it. This feature was added for SQL Server 2008.. it’s not the ability to script drop and create objects which a very welcome and great...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Fri, Jul 16 2010
SQL 2008 standard edition maintenance plans and compression comment..

A minor niggle with SQL standard edition and SSMS :- I don't use SQL standard edition very often.. So this surprised me on SQL 2008 service pack 1 - When creating a backup maintenance task, SSMS gives you the following options :- See that you are allowed to select 'compress backup' - even...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Fri, Jul 16 2010
SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found

A typical problem occurs when SQL Server client tools do have any issues. There is no easy way to say that SSMS (client tools) are corrupted, unless you can reproduce the same issue on other machine it cannot be assured. If it is a bug from tools you can easily file them on Microsoft connect site and...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Wed, Jul 7 2010
Code formatter for SSMS

I was searching recently for a code formatter for T-Sql and I came accross this nice little utility that I wanted to share: http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl I've been dealing with a lot of legacy code latley and there is nothing I find more infuriating than unformatted...

Posted to The Tao Of Sql Server (Weblog) by blakmk on Fri, Apr 30 2010
Interesting SSMS issue with waittype of PREEMPTIVE_OS_LOOKUPACCOUNTSID

Saw a recent issue with SQL2008 sp 1 where SQL Server Management Studio (SSMS) appeared to hang when a DBA expanded the database users tab of a database… ie like this :- When we looked at the waittype of the SSMS session - via sys.dm_os_waiting_tasks – it was waiting on PREEMPTIVE_OS_LOOKUPACCOUNTSID...

Posted to Steve Hindmarsh's SQL Blog (Weblog) by steveh99999 on Wed, Apr 21 2010
SQL Server Manageability series - shortcut for SSMS keyboard shortcuts!

For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback that I have received for earlier posts on this...

Posted to SQL Server Knowledge Sharing Network (@sqlmaster) (Weblog) by ssqa.net on Sat, Nov 14 2009
How to display long text in SSMS

Displaying text in SQL Server Management Studio has never been great!! Writing large amounts of data to the screen that will often be unread does not help performance and the user experience could be degraded. When you display results to text the default maximum size of characters that you can display...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Sun, Oct 25 2009
Speeding up SQL Server Management Studio Startup

One of the tips from the SQL Nuggets competition I ran at the Leeds Area user group this week was to use the –NOSPLASH option to speed up the start up of Management Studio. Adding this to your shortcuts or menu options will reduce the time before you are able to use the application. This is not the only...

Posted to Martin Bell UK SQL Server MVP (Weblog) by MartinBell on Thu, Jul 23 2009
Copy query results WITH column headers!

If you work a lot with SQL Server, like I do, the missing column headers when you copy query results from a query in the Management Studio is a major frustration. A colleague pointed me to a nice option to keep those headers while copying your data ! [Tools] -> [Options] -> [Query Results] ->...

Posted to Dave's Blog (Weblog) by DaveRuijter on Fri, Jan 9 2009

Page 1 of 2 (18 items) 1 2 Next >