Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)
Wednesday, September 16, 2009 1:41 PM

SQL Server Connection Leak Simulation Tool

Sometimes it’s necessary to test application performance in low available resource situations… I’ve seen tools that simulate low available memory, do network throttling, etc., but I have not come across one that simulates a lot of SQL Server connections
Posted by irenak | 0 Comments
Attachment(s): SQLConnectionLeak.zip
Tuesday, August 07, 2007 5:37 PM

SYSK 360: What’s taking up the space in my database? Also, a word about SQL reports…

So, you’ve updated usage stats on your database by running EXEC sp_spaceused @updateusage = N 'TRUE' But, you still can’t figure out why it’s reporting much more used space then the data that appears in your tables… Try running the following query to
Posted by irenak | 3 Comments
Filed under:
Sunday, August 05, 2007 5:06 PM

SYSK 359: How to Purge Workflow Tracking Data Inserted By SqlTrackingService

To my great surprise, after doing a search for a script that would delete the events logged by the almighty SqlTrackingService service, I didn’t find one… So, I quickly created it (see below), and it seems to do the job just fine given the current table
Posted by irenak | 1 Comments
Sunday, August 05, 2007 9:41 AM

SYSK 357: SQL Server Login Problem on Fresh Installation in Vista

I just installed SQL Server 2008 CTP (Katmai) and all the patches on my Vista laptop… However, trying to login using SQL Management Studio or osql using integrated security (and, yes, I’m an admin on my box) results in the “login failed” error. To resolve
Posted by irenak | 2 Comments
Filed under:
Monday, June 18, 2007 5:52 AM

SYSK 349: What’s New in SQL 2008 (code named Katmai)?

Here are some of the new and improved features (extracted from David Campbell’s presentation) that will be available in SQL 2008: - Transparent data encryption - External key management - Data auditing - Pluggable CPU - Transparent failover for data mirroring
Posted by irenak | 0 Comments
Filed under:
Thursday, May 10, 2007 6:01 AM

SYSK 347: How-To Keep Historical/Audit Data Accurate

I’m sure you’ve heard this saying many times before – “the hard disk space is cheap now – save everything”… With that, many companies create paired (or buddy) tables for all transactional data, i.e. for every transactional table (i.e. not lookups, a.k.a.
Posted by irenak | 2 Comments
Filed under:
Tuesday, May 08, 2007 5:04 AM

SYSK 345: How To Assure Correct LastUpdatedDateTime Value in Your SQL Tables

Often, developers add LastUpdatedDataTime (or LastUpdatedTimestamp) and LastUpdatedByUser columns to tables in relational databases. And, as one might guess, these fields are often created to be not nullable with default values set by using SQL functions
Posted by irenak | 4 Comments
Filed under:
Friday, April 27, 2007 6:34 AM

SYSK 338: What SQL Queries Are Currently Running?

That’s easy -- just run the SQL statement below… select session_id , request_id , start_time , status , cpu_time , er . total_elapsed_time , substring ( st . text , ( er . statement_start_offset / 2 ) + 1 , (( case er . statement_end_offset when - 1 then
Posted by irenak | 0 Comments
Filed under:
Friday, April 20, 2007 5:04 AM

SYSK 333: What Query Plans Are Cached in SQL Server?

It’s well known that, to improve performance, SQL Server caches query execution plans in memory. But would you like to know what query execution plans are currently in the cache? The following query will yield that information: select substring ( st .
Posted by irenak | 0 Comments
Filed under:
Friday, April 13, 2007 5:07 AM

SYSK 328: The “Hidden” System Database in SQL 2005

If you just open SQL Server Management Studio and expand the System Databases node, you’ll see four databases – master, model, msdb and tempdb (just like in SQL 2000). However, SQL Server 2005 has a new system database called the ‘Resource’ database,
Posted by irenak | 0 Comments
Filed under:
Thursday, March 22, 2007 6:03 AM

SYSK 312: Why You Should Not Change SQL Server Service Account Using Services Management Console

The SQL Server documentation states that it’s strongly recommended to use SQL Server Configuration Manager and not Control Panel\Administrative Tools\Services (services.msc) when changing SQL Server or SQL Server Agent service account. The question is
Posted by irenak | 0 Comments
Filed under:
Monday, March 05, 2007 5:04 AM

SYSK 300: Why TABLESAMPLE Is Not Returning Specified Number of Rows

One of the new features in SQL 2005 is the clause that allows you to get a random set of rows. The syntax supports specifying either a percentage or a number of rows to return: TABLESAMPLE [SYSTEM] (sample_number [ PERCENT | ROWS ] ) [ REPEATABLE (repeat_seed)
Posted by irenak | 2 Comments
Filed under:
Monday, February 26, 2007 5:10 AM

SYSK 295: Difference between password handling in SQL 2000 and SQL 2005

Did you know that in SQL Server 2000, the engine used to maintain two copies/versions of each SQL Server login password. One contained the actual password supplied by the user, and the second one was the password converted by SQL Server to all uppercase
Posted by irenak | 0 Comments
Filed under:
Tuesday, February 20, 2007 5:18 AM

SYSK 291: SQL 2005 SP 2 is Available and Comes with Good News About Licensing Costs

With SQL Server 2005 SP2 released to the web on Feb. 19, 2007, SQL Server Enterprise Edition customers, and I quote, “only need to purchase one license per physical processor regardless of the number of virtually deployed instances. “ In other words,
Posted by irenak | 1 Comments
Filed under:
Wednesday, February 14, 2007 6:21 AM

SYSK 287: Custom C#/VB (CLR) Types Used in SQL Server

Did you know that you can use custom CLR types in Microsoft SQL Server by adding [ Serializable , Microsoft.SqlServer.Server. SqlUserDefinedType ] attribute? And, yes, you can implement and use methods – see Microsoft.SqlServer.Server. SqlMethod attribute…
Posted by irenak | 0 Comments
Filed under:
More Posts Next page »
 
Page view tracker