Welcome to MSDN Blogs Sign in | Join | Help

September 2006 - Posts

SYSK 208: Slow Running SQL Queries? Here are possible reasons…

There are several reasons that could cause a query or updates to take longer then expected. This could be due to network issues or it could even be due to the database design itself, but most of the time slow running queries are caused due to: Network
Posted by irenak | 0 Comments

SYSK 207: Delete Recycle Bin Icon from Your Desktop

If you’re like me and use Shift + Del to permanently delete files, then Recycle Bin icon is of not much use… If you’d like to remove it from the desktop, open registry (Start -> Run -> regedit ), navigate to HKEY_LOCAL_MACHINE -> Software ->
Posted by irenak | 0 Comments

SYSK 206: Aliases in SQL Server

Almost everybody knows that you can give aliases to columns in a result set and to tables/views in a query. But did you know that you can also assign aliases to tables (including temporary tables), views, stored procedures (both, CLR and T-SQL), extended
Posted by irenak | 0 Comments
Filed under:

SYSK 205: Profiling Tool for .NET Developers

Performance profiling? -- Yes. You get the traditional profile info like number of calls, time spent in a method, average execution time. But you can also compare any two performance snapshots of the same application, viewing the difference in the number
Posted by irenak | 0 Comments

SYSK 204: Windows Vista Resources

Want to learn more on what’s new in Windows Vista, how to best leverage the new functionality and the new ways to do things? Below are some sites that I found to be quite useful: Windows Online Help (WOH): http://windowshelp.microsoft.com/Windows/en-US/default.mspx
Posted by irenak | 1 Comments

SYSK 203: Mind That Label Length in SQL Reporting Services

Another possible (but unconfirmed) bug in SQL 2005 Reporting Services: If you have a SSRS report parameter that is multi-value and of one of the label s in the “available values” list exceeds 25 characters , the dropdown list with values for this parameter
Posted by irenak | 1 Comments

SYSK 202: Shining a Light into the Mystery of the Boot Process

Want to know what’s going on during your computer boot time, i.e. which device drivers are being loaded, the results of the disk check, etc.? Just add /SOS switch to proper line in boot.ini . The boot.ini file is hidden, so you want see it in Windows
Posted by irenak | 2 Comments

SYSK 201: Using Linked Server? Possible bug discovered…

I was not able to find out, yet, directly from the SQL Server product group whether this is a known bug or that it’s even confirmed to be a bug, but here is what I came across last week… On SQL 2005 SP1 (other versions not tested), if you set the product
Posted by irenak | 4 Comments
Filed under:

SYSK 200: How To Detect and Remove No Longer Valid Windows Logins From SQL Server

It is a good idea to occasionally audit your SQL servers for users/groups that no longer exist in the Windows domain, but still exist on the SQL Server. This can happen, for example, when employees or contractors leave the company, or change their login
Posted by irenak | 2 Comments
Filed under:

SYSK 1 – 199

For of those of you who like to revisit certain topics at times, and for those of you who started reading this blog recently, below are the links for posts 1 through 199: Welcome to the "AppDev: Something You Should Know" blog SYSK (Something You Should
Posted by irenak | 0 Comments

SYSK 199: A Quick Way To Lock Your Computer

Did you know that pressing Windows key + L will do the same as Ctrl + Alt + Del followed by K; namely lock your computer? Much faster!
Posted by irenak | 1 Comments

SYSK 198: What is CodePlex?

Did you know that CodePlex is a new developer oriented web site containing source code for projects like “Ascend.NET” Windows forms controls ( http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASCENDNET ), “Atlas” control toolkit ( http://www.codeplex.com/Wiki/View.aspx?ProjectName=AtlasControlToolkit
Posted by irenak | 0 Comments

SYSK 197: Smart Start and Stop Service in VS.NET Build

If you have a windows service project as part of your solution, you’re quite familiar with the issues it presents -- if the service is running and you’re recompiling either the service project itself, or any assemblies loaded by the service, you’ll get
Posted by irenak | 0 Comments

SYSK 196: Is there a performance hit and CPU spike when concatenating literal strings?

For example, is doing something like the code snippet below (done for readability) falls into the "bad practices" category? string x = "<root>" + " <items>" + " <item>" + " <name>xyz</name>" " </item>" + " </items>"
Posted by irenak | 5 Comments

SYSK 195: Speeding Up Index Creation

In SQL Server 2000 and 2005 when you create or rebuild an index you can set SORT_IN_TEMPDB option to ON to use TempDB to store the intermediate sort results, which may reduce the time needed to create an index when TempDB is on a set of disks different
Posted by irenak | 0 Comments
Filed under:

SYSK 194: “X-Ray Vision” of HTTP Traffic

Your browser knows that http://www.microsoft.com is running IIS 6.0/.NET 2.0 as the web server http://www.google.com ‘s web server is GWS 2.1 http://www.eweek.com is running on IIS 5.0 http://www.shopping.com uses Apache 1.3.33 http://en.wikipedia.org
Posted by irenak | 5 Comments

SYSK 193: Uncommon HTTP Verbs

Did you know that HTTP defines eight methods (a.k.a. "verbs") indicating the desired action to be performed on the identified resource? They are: HEAD Asks for the response identical to the one that would correspond to a GET request, but without the response
Posted by irenak | 1 Comments

SYSK 192: Compact Policies

The P3P specification (see yesterday’s blog post) requires websites to put their privacy policies in an XML format that can be read by modern browsers such as IE6 and NS7. Users can then easily view the web site’s privacy policy – check out for yourself
Posted by irenak | 0 Comments

SYSK 191: Is Your Public Web Site P3P Compliant?

The W3C's Platform for Privacy Preferences (P3P) provides a standard way for web sites to communicate about their privacy practices (see http://www.w3.org/P3P/ for more details). More and more companies like Microsoft, IBM, Dell, Yahoo, CNet, DoubleClick
Posted by irenak | 0 Comments

SYSK 190: Desktop View at Your Fingertips

What’s the fastest way to hide from the passing-by co-worker (or your boss) what you’re doing on the computer? Let’s not get into discussion of why you might need that J You could simply minimize the application… But mouse-based navigation is too slow
Posted by irenak | 1 Comments
 
Page view tracker