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

Browse by Tags

All Tags » SQL Server   (RSS)

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:

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

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:

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:

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:

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:

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

(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

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:

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:

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:

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:

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.

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:

{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
More Posts Next page »