Welcome to weblogs.com.pk Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)
Thursday, February 28, 2013 1:54 PM

Knowing the counts of table entries in SQL Server

Here's the query to know the counts of the table entries in SQL Server select object_name ( object_id ), row_count from sys . dm_db_partition_stats where index_id < 2 order by row_count desc
Posted by khurram | 0 Comments
Filed under:
Saturday, January 02, 2010 1:02 AM

Sharepoint and SQL Server Reporting Services

SQL Server 2005 Reporting Services SP2 or later can be integrated with Sharepoint. Setting it up is bit tricky. http://msdn.microsoft.com/en-us/library/ee384252.aspx URL is must read to troubleshoot the issues. For me following worked Ensure only Windows
Posted by khurram | 1 Comments
Tuesday, October 20, 2009 3:58 PM

Disallowing Running the Stored Procedure in Parallel

I wrote a stored procedure a while back; it manipulates the database of a legacy and proprietary application. Few assumptions were taken like the stored procedure will always get invoked by the job and job doesn't run in parallel. Few weeks back there
Posted by khurram | 0 Comments
Filed under:
Thursday, October 08, 2009 9:57 AM

Tsql : Update From / Self Join

The other day I received a query on how to update rows in a table having from clause and self join needs to be used…I thought its interesting scenario and should document it for future references… Let me explain the problem with a scenario…Lets consider
Posted by khurram | 0 Comments
Filed under:
Wednesday, September 30, 2009 10:08 AM

Date Calculations in TSQL

Sometime while implementing some date/time specific business logic; we need to do some processing on datetime data; e-g trimming away the time, knowing the start of month datetime value. Instead of converting the datetime data to string and then doing
Posted by khurram | 0 Comments
Filed under:
Monday, September 28, 2009 6:57 PM

If-Else Like Behavior in Where Clause

.csharpcode, .csharpcode pre { font-size: small; color: black; font-family: consolas, "Courier New", courier, monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode
Posted by khurram | 0 Comments
Filed under:
Friday, September 25, 2009 4:18 PM

Microsoft Dynamics GP

Is anyone around has worked with Microsoft Dynamics GP product? (v10) I have an integration project and some basic training work to accountants / data entry operators and management folk for adoption (migrating from another such accounting/financial/mini-ERP
Posted by khurram | 1 Comments
Friday, September 25, 2009 4:12 PM

(Almost) Free Microsoft Products through WebsiteSpark

Program Site: http://www.microsoft.com/web/websitespark What you get The right to use the following products for three years For Development Use Visual Studio Professional Expression Studio 2 or Expression Studio 3 (1 User) Expression Web 2 or Expression
Posted by khurram | 0 Comments
Thursday, November 02, 2006 7:39 PM

Knowing current SPROC name

Instrumentation though usually a "non-functional requirement"; but its considered to be critical especially in "enterprise class application". For this we usually need to know what is the current part of code being executing; against which we can log
Posted by khurram | 0 Comments
Filed under:
Sunday, June 18, 2006 12:54 AM

TSQL :: Comparing multiple fields

Sometimes you want to select from one list the items that exist (or don’t exist) in the second row; and for the comparison you want to use multiple rows. This is common in scenarios where you want to remove duplicate values. You might wish to write something
Posted by khurram | 2 Comments
Filed under:
Tuesday, May 16, 2006 6:12 PM

Tsql :: Checksum

Comparing Checksum is one of the straight forward techniques to know if two things are different or not, especially when you are comparing some vector quantities. SQL Server 2005’s TSQL has two new relevant functions in this regard, checksum() and checksum_agg()
Posted by khurram | 1 Comments
Filed under:
Tuesday, March 21, 2006 4:27 PM

Can we use stored procedures in View?

Well I have not gone through all the options yet; but I was able to did something that solved the problem at hand. The database at hand was exposed only through stored procedures; but one developer wanted to have a view; being new to Perl on Unix; he
Posted by khurram | 0 Comments
Filed under:
Friday, March 17, 2006 7:53 PM

Sharepoint / ASP.NET v2 / Smart Part :: Required permissions cannot be acquired

Today I updated few internal Sharepoint based applications to ASP.NET v2 . Before using ASP.NET v2 with Sharepoint; you need to install Service Pack 2 of Windows Sharepoint Services (WSS). I was using SmartPart to use ASCX based user controls in Sharepoint.
Posted by khurram | 0 Comments
Wednesday, March 08, 2006 1:17 AM

Passing Array To Stored Procedures

There are some scenarios; where you want to pass array to stored procedure. In SQL 2000; it was not possible. Different work-around was presented; like passing values as string and then parsing them out; passing data as XML and then using MSXML OLE automation
Posted by khurram | 1 Comments
Filed under:
Friday, March 03, 2006 9:30 PM

{BA126AD1-2166-11D1-B1D0-00805FC1270E}

I have a Windows 2003 Sp1 box running SQL Server 2005; the box also has Windows Firewall turned on. I was going through Windows Event Logs; and found out that NETMAN service has some issues. NETMAN (Network Connections Manager) service is used by Windows
Posted by khurram | 3 Comments
More Posts Next page »