Tags » SQL Server 2008 R2

A batch is held in the Posting, Printing, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

A batch is held in the Posting, Printing, Receiving, Busy, Marked, Locked, or Edited status in Microsoft Dynamics GP

 When you try to post a batch in Microsoft Dynamics GP, the batch is assigned any of the following statuses: 499 more words

Dynamics GP

Sql Server: Common Table Expression (CTE) with ORDER BY clause

Quick one today:

Common Table Expression, since it was introduced in Sql Server 2005 is another great feature. The value is immense and cannot be understated. 246 more words

DBA

Finding Tables Sizes with File Group information

Sometimes managing multiple file groups and the amount of data that is in them can cause a few logistic issues. Recently I found myself needing to know what tables are in what file groups and what the sizes of those tables are. 459 more words

SQL Server 2008

SQL Server Cached Objects page count

http://msdn.microsoft.com/en-gb/library/ms173442.aspx

SELECT COUNT(*)AS cached_pages_count ,(COUNT(1) * 8 ) / 1024.00 MB ,(COUNT(1) * 8 ) / (1024.00 *1024) as GBs
,name ,index_id
FROM sys.dm_os_buffer_descriptors AS bd… 102 more words

SQL Server 2008 R2

Sql Server: How to create PRIMARY KEY without CLUSTERED Index

Quick one today:

On a table, we could create Clustered and NonClustered indexes. Each table can only have 1 clustered index, but multiple nonclustered index. 199 more words

DBA

Error Fix: Microsoft SQL Server, Error: 14516

Problem: Proxy (1) is not allowed for subsystem “SSIS” and user “Domain\UserName”. Grant permission by calling sp_grant_proxy_to_subsystem or sp_grant_login_to_proxy. (Microsoft SQL Server, Error: 14516)

Solution: 69 more words

SQL Server 2008

Sql Server INSERT data into an IDENTITY column with SET IDENTITY_INSERT ON

Quick one today:

Rare, but sometimes, there is a need to INSERT specific values into a table that has an IDENTITY specified on one of the columns. 106 more words

DBA