Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

re-initialize replication not working

for someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for do you what to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Read more

0 comments, 173 reads

Posted in Vinay Thakur on 22 February 2014

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services its getting started on windows cluster but on cluser its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Read more

0 comments, 168 reads

Posted in Vinay Thakur on 22 February 2014

TempDB Contention 2.1.%

Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of  2.1.103 check perfomance counter: Temp Tables Creation Rate Temp Tables For Destruction When you are performing many DML operations and makes … Continue reading

Read more

0 comments, 279 reads

Posted in Vinay Thakur on 16 October 2013

Cluster failover fails

you may get an error while trying to failover to another node cluster.   to resolve this issue create an alias on the node with the cluster name and it should work. will blog more on this later.  

Read more

0 comments, 267 reads

Posted in Vinay Thakur on 16 October 2013

LogReader agent failed

You may get an error on log reader agent failed with following error:   Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. … Continue reading

Read more

0 comments, 221 reads

Posted in Vinay Thakur on 16 October 2013

Sql Server 2014…….What!!!

Yes, its true. Microsoft vice president has announce  that new version of sql server 2014, will release on 2014… do you think it is possible, as  not most of us not familiar with 2012 only…. any way…as MS already clear … Continue reading

Read more

0 comments, 492 reads

Posted in Vinay Thakur on 17 June 2013

Sql server 2012 links

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/

Read more

0 comments, 334 reads

Posted in Vinay Thakur on 21 May 2013

Good Bye 2012 and welcome 2013

Hey Everyone….. from quite some time I have not written Blogs due to some personal and transiting from my old company … yeah If you read my last year good bye Blog I have indicated about my interest for changing the company took … Continue reading

Read more

0 comments, 320 reads

Posted in Vinay Thakur on 19 January 2013

Denali –Memory : Memory Error Recovery in SQL Server 2012

  Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a new feature of Sql server 2012 in association with windows server 2012 called Memory Error Recovery in SQL Server … Continue reading

Read more

0 comments, 387 reads

Posted in Vinay Thakur on 25 October 2012

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Read more

1 comments, 424 reads

Posted in Vinay Thakur on 6 September 2012

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services. >> After installation when try to access instance. You would get “ACCESS DENIED” error. To resolve this issue, … Continue reading

Read more

0 comments, 423 reads

Posted in Vinay Thakur on 5 September 2012

Normalization & Denormalization

Normalization & Denormalization Someone asked me about this basic thing which we generally do not think much, so realize that should write a short blog on it. Normalization: For any database the way data is stored using different data models … Continue reading

Read more

1 comments, 508 reads

Posted in Vinay Thakur on 4 September 2012

RAID (Redundant Array Independent Disk)

RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk sql server is no exception. Generally all activity happens on memory as memory is very fast compared to Disk. Earlier … Continue reading

Read more

3 comments, 511 reads

Posted in Vinay Thakur on 17 August 2012

Denali – Memory: “any size” page allocations

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided into two parts: BPool – Single page allocation Mem_to_Leave – Multipage allocation. Single page allocation is a 8k page allocated … Continue reading

Read more

0 comments, 576 reads

Posted in Vinay Thakur on 12 July 2012

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading

Read more

0 comments, 616 reads

Posted in Vinay Thakur on 11 July 2012

Download: Consolidated Denali a Day – May 2012

Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for the month of May 2012, then I can provide you a consolidated (for all 31 days) blog into a … Continue reading

Read more

5 comments, 504 reads

Posted in Vinay Thakur on 5 June 2012

Denali – Day 31: Discontinue and Breaking/Behavior change features

Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that in Denali there are some features which has already discontinued. Means if you try to use those features they … Continue reading

Read more

0 comments, 779 reads

Posted in Vinay Thakur on 31 May 2012

Denali – Day 30: Deprecated Features

Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but it’s highly possible that would not be available in future version of sql server, so you should plan your … Continue reading

Read more

0 comments, 1,274 reads

Posted in Vinay Thakur on 30 May 2012

Denali – Day 29: Resource Governor Enhancements (Database Engine)

Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql server 2008. It requires Enterprise and developer edition.   As name implies It controls the resources allocation for users, … Continue reading

Read more

0 comments, 908 reads

Posted in Vinay Thakur on 29 May 2012

Denali – Day 28: CDC for ORACLE

Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture Change Tracking http://www.mssqltips.com/tipprint.asp?tip=1819 Change data capture is introduced in 2008 now on Denali it supports for ORACLE database as … Continue reading

Read more

0 comments, 813 reads

Posted in Vinay Thakur on 28 May 2012

Older posts