Saturday, August 10, 2013

[SQL Server 2008 issues] SSRS: way to add 100 columns in tablix,

[SQL Server 2008 issues] SSRS: way to add 100 columns in tablix,


SSRS: way to add 100 columns in tablix,

Posted: 09 Aug 2013 08:09 AM PDT

Hi,I have report that have 100 buckets (for each day for 3+ month), so I need to compose it somehow, is there any way to automate this in SSRS 2008 ?This is hard coded stable number of columns, not tied to results.Probably there are some dynamics tools ?I also would like to add some background color formatting to all of this 100 columns, probably there is good way to automate this too.Appreciate your helpMario

simple select - error

Posted: 09 Aug 2013 02:25 AM PDT

Hi Team,am using below select statement, but getting error SELECT id, name, Count(id) AS T FROM testtestError:Column 'testtest.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Please help

time out error

Posted: 08 Aug 2013 10:32 PM PDT

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.where can we check to resolve this issue ?

There is insufficient system memory in resource pool 'internal' to run this query. Error: 701, Severity: 17, State: 123.

Posted: 09 Aug 2013 04:15 AM PDT

I have a SQL instance that starting getting the "insufficient system memory" issue. Here is the server information:Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86) Jun 17 2011 00:57:23 Copyright (c) Microsoft Corporation Standard Edition on Windows NT 6.0 <X86> (Build 6001: Service Pack 1) (Hypervisor)System Manufacturer: 'VMware, Inc.', System Model: 'VMware Virtual Platform'.Physical Memory: 16GBMin Memory: 0GBMax Memory: 12GBError: 701, Severity: 17, State: 123.There is insufficient system memory in resource pool 'internal' to run this query.Here is the really strange issue: task manager os only showing 5GB being used. Don't know if that has anything to do with anything.When I look at sys.dm_os_process_memory I see the process_virtual_memory_low flag is 1. total_virtual_address_space_kb = 2,047MBvirtual_address_space_committed_kb = 1,810MBmemory_utilization_percentage = 100virtual_address_space_available_kb = 28MBprocess_virtual_memory_low = 1According to this there is VAS pressure. However, I have no idea how to correct it. Changing the SQL queries isn't an option for two reasons: 1) it is a vendor app and 2) nothing changed prior to this issue occurring and the application has been running for a year without problems. Below is the MEMORYSTATUS results. Does anyone have any idea what to do to fix this?Memory Manager KB---------------------------------------- -----------VM Reserved 1790320VM Committed 1751256AWE Allocated 0Reserved Memory 1024Reserved Memory In Use 0(5 row(s) affected)Memory node Id = 0 KB---------------------------------------- -----------VM Reserved 1787504VM Committed 1748552AWE Allocated 0MultiPage Allocator 55640SinglePage Allocator 104448(5 row(s) affected)Memory node Id = 32 KB---------------------------------------- -----------VM Reserved 1728VM Committed 1672AWE Allocated 0MultiPage Allocator 1600SinglePage Allocator 104448(5 row(s) affected)MEMORYCLERK_SQLGENERAL (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 24040MultiPage Allocator 10120(7 row(s) affected)MEMORYCLERK_SQLBUFFERPOOL (node 0) KB---------------------------------------- -----------VM Reserved 1658304VM Committed 1658304AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 504(7 row(s) affected)MEMORYCLERK_SQLQUERYEXEC (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 32MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SQLOPTIMIZER (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 1384MultiPage Allocator 72(7 row(s) affected)MEMORYCLERK_SQLUTILITIES (node 0) KB---------------------------------------- -----------VM Reserved 240VM Committed 240AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 304MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SQLSTORENG (node 0) KB---------------------------------------- -----------VM Reserved 14912VM Committed 14912AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 34376MultiPage Allocator 32280(7 row(s) affected)MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 1576MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SQLCLR (node 0) KB---------------------------------------- -----------VM Reserved 38592VM Committed 8472AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 1336MultiPage Allocator 568(7 row(s) affected)MEMORYCLERK_SQLSERVICEBROKER (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 176MultiPage Allocator 344(7 row(s) affected)MEMORYCLERK_SQLHTTP (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SNI (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 240MultiPage Allocator 16(7 row(s) affected)MEMORYCLERK_SNI (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 16(7 row(s) affected)MEMORYCLERK_SNI (Total) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 240MultiPage Allocator 32(7 row(s) affected)MEMORYCLERK_FULLTEXT (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 24MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SQLXP (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_BHF (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 240MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_SQLQERESERVATIONS (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 3072MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_XE_BUFFER (node 0) KB---------------------------------------- -----------VM Reserved 4224VM Committed 4224AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_HOST (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 328MultiPage Allocator 32(7 row(s) affected)MEMORYCLERK_SOSNODE (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 11288MultiPage Allocator 10184(7 row(s) affected)MEMORYCLERK_SOSNODE (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 1520(7 row(s) affected)MEMORYCLERK_SOSNODE (Total) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 11304MultiPage Allocator 11704(7 row(s) affected)MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB---------------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 32MultiPage Allocator 0(7 row(s) affected)MEMORYCLERK_XE (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 4664MultiPage Allocator 128(7 row(s) affected)CACHESTORE_OBJCP (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 216MultiPage Allocator 16(7 row(s) affected)CACHESTORE_SQLCP (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 616MultiPage Allocator 232(7 row(s) affected)CACHESTORE_PHDR (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 440MultiPage Allocator 0(7 row(s) affected)CACHESTORE_XPROC (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 0(7 row(s) affected)CACHESTORE_TEMPTABLES (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 64MultiPage Allocator 0(7 row(s) affected)CACHESTORE_NOTIF (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 0(7 row(s) affected)CACHESTORE_VIEWDEFINITIONS (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 0(7 row(s) affected)CACHESTORE_XMLDBTYPE (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_XMLDBELEMENT (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_XMLDBATTRIBUTE (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_STACKFRAMES (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 8(7 row(s) affected)CACHESTORE_STACKFRAMES (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 8(7 row(s) affected)CACHESTORE_STACKFRAMES (Total) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 16(7 row(s) affected)CACHESTORE_BROKERTBLACS (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 96MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERKEK (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERDSH (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERRSB (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERREADONLY (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 32MultiPage Allocator 0(7 row(s) affected)CACHESTORE_BROKERTO (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)CACHESTORE_EVENTS (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 16MultiPage Allocator 0(7 row(s) affected)CACHESTORE_CLRPROC (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 40MultiPage Allocator 0(7 row(s) affected)CACHESTORE_SYSTEMROWSET (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 280MultiPage Allocator 0(7 row(s) affected)CACHESTORE_CONVPRI (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 144MultiPage Allocator 0(7 row(s) affected)CACHESTORE_FULLTEXTSTOPLIST (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 32MultiPage Allocator 0(7 row(s) affected)USERSTORE_SCHEMAMGR (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 12192MultiPage Allocator 936(7 row(s) affected)USERSTORE_DBMETADATA (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 912MultiPage Allocator 0(7 row(s) affected)USERSTORE_TOKENPERM (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 2624MultiPage Allocator 0(7 row(s) affected)USERSTORE_OBJPERM (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 1360MultiPage Allocator 0(7 row(s) affected)USERSTORE_SXC (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 208MultiPage Allocator 0(7 row(s) affected)USERSTORE_SXC (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 8MultiPage Allocator 0(7 row(s) affected)USERSTORE_SXC (Total) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 216MultiPage Allocator 0(7 row(s) affected)OBJECTSTORE_LBSS (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 104MultiPage Allocator 0(7 row(s) affected)OBJECTSTORE_SNI_PACKET (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 2040MultiPage Allocator 56(7 row(s) affected)OBJECTSTORE_SNI_PACKET (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 0MultiPage Allocator 56(7 row(s) affected)OBJECTSTORE_SNI_PACKET (Total) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 2040MultiPage Allocator 112(7 row(s) affected)OBJECTSTORE_SERVICE_BROKER (node 0) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 400MultiPage Allocator 0(7 row(s) affected)OBJECTSTORE_LOCK_MANAGER (node 0) KB---------------------------------------- -----------VM Reserved 4096VM Committed 4096AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 2416MultiPage Allocator 0(7 row(s) affected)OBJECTSTORE_LOCK_MANAGER (node 32) KB---------------------------------------- -----------VM Reserved 0VM Committed 0AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 24MultiPage Allocator 0(7 row(s) affected)OBJECTSTORE_LOCK_MANAGER (Total) KB---------------------------------------- -----------VM Reserved 4096VM Committed 4096AWE Allocated 0SM Reserved 0SM Committed 0SinglePage Allocator 2440MultiPage Allocator 0(7 row(s) affected)Buffer Pool Value---------------------------------------- -----------Committed 204760Target 204760Database 189898Dirty 18887In IO 0Latched 2Free 1734Stolen 13128Reserved 378Visible 204760Stolen Potential 181015Limiting Factor 11Last OOM Factor 0Last OS Error 0Page Life Expectancy 8427(15 row(s) affected)Process/System Counts Value---------------------------------------- --------------------Available Physical Memory 11782029312Available Virtual Memory 30199808Available Paging File 29535764480Working Set 1950310400Percent of Committed Memory in WS 100Page Faults 318585640System physical memory high 1System physical memory low 0Process physical memory low 0Process virtual memory low 1(10 row(s) affected)Procedure Cache Value---------------------------------------- -----------TotalProcs 8TotalPages 454InUsePages 26(3 row(s) affected)Global Memory Objects Pages---------------------------------------- -----------Resource 3321Locks 305XDES 127SETLS 4SE Dataset Allocators 8SubpDesc Allocators 4SE SchemaManager 631SE Column Metadata Cache 945SQLCache 55Replication 2ServerGlobal 29XP Global 2SortTables 3674(13 row(s) affected)Query Memory Objects (internal) Value---------------------------------------- -----------Grants 0Waiting 0Available 146163Current Max 146163Future Max 146163Physical Max 146163Next Request 0Waiting For 0Cost 0Timeout 0Wait Time 0(11 row(s) affected)Small Query Memory Objects (internal) Value---------------------------------------- -----------Grants 3Waiting 0Available 7308Current Max 7692Future Max 7692(5 row(s) affected)Optimization Queue (internal) Value---------------------------------------- -----------Overall Memory 1344528384Target Memory 1269694464Last Notification 1Timeout 6Early Termination Factor 5(5 row(s) affected)Small Gateway (internal) Value---------------------------------------- -----------Configured Units 16Available Units 12Acquires 4Waiters 0Threshold Factor 250000Threshold 250000(6 row(s) affected)Medium Gateway (internal) Value---------------------------------------- -----------Configured Units 4Available Units 4Acquires 0Waiters 0Threshold Factor 12Threshold 26451968(6 row(s) affected)Big Gateway (internal) Value---------------------------------------- -----------Configured Units 1Available Units 1Acquires 0Waiters 0Threshold Factor 8Threshold -1(6 row(s) affected)Memory Pool Manager Pages---------------------------------------- -----------Reserved Current 384Reserved Limit 181468(2 row(s) affected)Memory Pool (internal) Pages---------------------------------------- -----------Allocations 13438Predicted 49594Private Target 0Private Limit 0Total Target 194522Total Limit 194522OOM Count 0(7 row(s) affected)MEMORYBROKER_FOR_CACHE (internal) Pages---------------------------------------- -----------Allocations 2990Rate -919Target Allocations 147918Future Allocations 0Overall 164127Last Notification 1(6 row(s) affected)MEMORYBROKER_FOR_STEAL (internal) Pages---------------------------------------- -----------Allocations 10064Rate -1321Target Allocations 154992Future Allocations 0Overall 164127Last Notification 1(6 row(s) affected)MEMORYBROKER_FOR_RESERVE (internal) Pages---------------------------------------- -----------Allocations 384Rate 0Target Allocations 164127Future Allocations 36540Overall 164127Last Notification 1(6 row(s) affected)DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Permission to create Linked Server

Posted: 09 Aug 2013 05:20 AM PDT

I have a user who has DB_Owner permission on a particular database.Now, that user needs to create a linked server for himself.what level of permission do I need to grant to that user at the server level for him to create Linked Server?

Reset identity seed on a large table

Posted: 09 Aug 2013 07:51 AM PDT

I need to reset the identity seed on 7.5 million records (someone added a need identity seed to an archive table instead of using the one that's assigned in the production table - now the archive table is out of sync with the production table). I want the last ID in the archive table to bump up against the first ID in the production table, that way moving and deleting records from production to archive will be easier. However I'm wondering how to reseed 7.5 m records without blowing up my transaction log. Any suggestions? TIA!!

Transaction Log

Posted: 09 Aug 2013 07:47 AM PDT

One of our databases transaction log file growing larger month by month.Before I increase the disk space I would like to understand is there way we can keep the transaction log file minimal other than shrinking.However, data is increasing I belive cause log file to grow.Could you please elobrate what other things can impact the trnasaction log file gowth other than maintenance plans etc.How should I do analysis for the disk space recommendations?Thanks and appreciated!

Restore the mdf from a BAK to multiple drives possible?

Posted: 09 Aug 2013 04:57 AM PDT

Hello - I have 2 BAK files to restore to 2 drives (1 for the mdf, 1 for the logs)I'm running out of room for the mdfs and can't restore both databases.Is it possible to restore the mdf of one of the databases to 2 different drives?For example, both databases together need 105 GB and I have a 100 GB drive. Is there any way to restore and have 5GB sit on another drive?I could not find an example of this or see the option in the GUI.I don't have the option of changing the backup process. I receive the BAK files from another agency that won't modify their procedures.ThanksDave

Replication DB - Dead lock issue

Posted: 29 Jun 2013 03:32 PM PDT

Hi,We have One Database which is a Replication Db, sometimes during beginning of the month, lot of user activities going and we having Dead lock issue.Any one has idea how to prevent the dead lock in Replication DB?We have to manually kill the user session one by one but if someone having same kind of issue and have any idea?Thanks,

Run querys on different database with Progress

Posted: 05 Aug 2013 09:43 AM PDT

Hi guys,I am using ODBC to connect Progress from Sql server 2008, But I need to connect with two differents databases on the same query, It is possible?I am using Progress OpenEdge 11.2Any help would be greatly appreciated.Thanks,Sandra

Can SQL Server Instances be hiddent....

Posted: 09 Aug 2013 04:00 AM PDT

I would like to know here that .. Is there any possiblity to hide SQL Server Instances... Please clarify me.Thanks in advance !!!

MAXDOP

Posted: 08 Aug 2013 11:50 PM PDT

I know this is a very subjective topic and the actual figured is best gained through testing etc but I just wanted to ask if there is any truth to the following:ideal maxdop = total cores / number of NUMA nodes * 0.75I have found this formula in a few places but havent found with it any explanation or reasons how it works, could anyone explain?

Locking in “Read Committed Snapshot”

Posted: 08 Aug 2013 08:36 PM PDT

IF update command is run on a table with "Read Committed_Snapshot" isolation level and Commit is pendingeg: 1) update table1 set col1 = col1 + 1 where PKcol < 32) update table1 set col1 = col1 + 1 where PKcol = 33) update table1 set col1 = col1 + 1 where NonPKcol < 34) update table1 set col1 = col1 + 1 where NonPKcol = 35) update table1 set col1 = col1 + 1 where PKcol < 3 and NonPKcol = 5(In above case PKcol is primary key in table and NonPKcol is a non-primary key)then whether Update is locked for only rows satisfying 'where' condition ? (is it based on value or index or Primary column ?)

Patched but seemingly not Patched?

Posted: 08 Aug 2013 09:29 PM PDT

A colleague recently applied SQL Server 2008 R2 SP2 to one of our servers.Through Management Studio it shows correctly as 10.50.4000 but if we run the installer again, it hasn't greyed out the tick and shows the patch as "Not Upgraded".Has anyone seen this before and know what's wrong?

No comments:

Post a Comment

Search This Blog