• Home
  • About
  • Services
  • Download
  • Book
  • Contact
  • Privacypolicy
  • TwitterFacebookGoogle PlusLinkedInRSS FeedEmail Pinterests
SQL Server Citation
  • Home
  • Performance Tuning
  • High Availability
    • AlwaysOn
    • Cluster
    • DB Mirroing
    • Replication
      • Merge
      • Transaction
      • Snapshot
      • Peer-to-Peer
  • Common Mistakes
    • Storage
      • Disk Subsystem
      • File Groups
    • Indexes
  • Administration
    • SQL Server 2012
    • SQL Server 2008
    • SQL Server 2005
    • SQL Server 2000
  • Best Practice
  • Scripts
  • Troubleshooting

My SQLHA Book

Contribution

Archive DB

  • ►  2013 (4)
    • ►  April (2)
    • ►  March (2)
  • ►  2012 (15)
    • ►  December (1)
    • ►  October (2)
    • ►  September (1)
    • ►  March (6)
    • ►  January (5)
  • ▼  2011 (28)
    • ►  December (4)
    • ►  November (3)
    • ►  October (2)
    • ►  September (9)
    • ►  August (1)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (1)
    • ▼  January (5)
      • Tip for Backing up User Databases
      • SQL Server 2008 High Availability – A Book
      • Download SQL Server Training Kit
      • Download Section for Script and free ebook
      • welcome 2011
  • ►  2010 (11)
    • ►  November (3)
    • ►  August (1)
    • ►  July (1)
    • ►  June (1)
    • ►  April (1)
    • ►  February (2)
    • ►  January (2)
  • ►  2009 (33)
    • ►  December (3)
    • ►  November (4)
    • ►  August (1)
    • ►  July (3)
    • ►  June (1)
    • ►  May (2)
    • ►  April (3)
    • ►  March (6)
    • ►  February (1)
    • ►  January (9)
  • ►  2008 (5)
    • ►  September (3)
    • ►  January (2)
  • ►  2007 (34)
    • ►  November (1)
    • ►  October (2)
    • ►  September (5)
    • ►  August (4)
    • ►  July (4)
    • ►  May (3)
    • ►  April (5)
    • ►  March (1)
    • ►  February (8)
    • ►  January (1)
  • ►  2006 (22)
    • ►  November (4)
    • ►  August (1)
    • ►  July (11)
    • ►  March (1)
    • ►  February (5)
  • ►  2004 (1)
    • ►  September (1)

syscomments

% . 2005 2007 2009 pass summit unit 2011 2012 925419 940232 968369 968382 access denied access denied for SSIS ace Administration adomd algorithm alter database aries asp assessment and planning(map) authentication mode auto growth automate profiler trace aviraj ajgekar avoid null awaiting status backup bcp utility best practice Best Practice Analyzer best practices better solution between beyondrelational blob bol book on clustering Book on SQL Server 2008 books online BPA bradmcgehee.com build list for sql server 2005 and sql server 2008 Business business Continuity business intellegence bypass c2 audit calculate table size ceo of microsoft change change collation for column change the collation configuration checkident choosing right data type cluster cluster resources Clustering clustering articles codename collate collation setting for database collation settings column based query accelerator columnstore index Common mistakes in sql server community community day Community launched community techdays compare schema and data free compliance management toolkit compression in sql server 2008 configure auto growth in mb Continuity contributors controll creating stored procedure CTP culminis cumulative pack for sql server data storage database administration database developement database encryption Database Guru database mirroring database refresh db db2 dba dbcc checkdb gives error dbcc freeproccache dbcc shrinkdb dbcc shrinkfile DBCC Shrinkfile and DBCC Shrinkdb is taking more time in sql server 2005 deadlock Defregment Denali deployment devcon Develope Conference developer developer training kit developers training kit difference disappearance disaster document does not don't shrink database DotNetChaps dowload download download denali download ebook download R2 CTP download script download sp1 for sql server 2008 download sql server 2005 sp3 download sql server 2008 r2 mangement pack download training kit downlod sp3 dtaengine90.exe dtexec.exe dts in cluster dtsexecui.exe e-learning on sql server 2008 efs elsasoft embed security encryption enterprise data plateform enterprise edition error 7391 error 8967 estimate table size estimate the size of table estimating table size Estimating the size of Table Estimating the size of Table in sql server Everywhere Edition exists extremeexpert.com failed faq on cluster farallon islands feature pack files filling up firewall fixing orphaned users framework frappr free database tool free ebook free sqlserver software general get 25% discount growth of t-log guest user account gujarat handling Happy New year Hemantgiri Hemantgiri S. Goswami High Availability hotfix how how it writes in log how shrinking works how t-sql kill command works how to backup sql server database how to configure ssis in cluster How to create partitioned table and index how to restore sql server database how to run dts in cluster how to secure sql server how to upgrade sql server how to write sp How to write Stored Procedure ident_current identity and pK identity crisis identity_insert on inconsistancies in database or metadata Index index in partitioned table india ineta apac install sp on sql cluster installing sp on cluster integrated login integration service Integration Services (SSIS) in SQL Server Cluster jecob sebastian Jim Gray juneau katmai kb kb 171224 kb 936488 kb 960791 KB960082 KB960089 keep_replication kill spid knowledge base latches learn katmai learn sql server 2008 R2 link server linked server list of bugs fixed in sql server 2005 sp3 list of bugs fixed in sql server 2008 sp1 Log Shipping login failed login screen logs lottery lowering power consumption managing identity value map max memory MBCA 2.0 mct memory management Merge Replciation merge replication microsoft microsoft event microsoft press microsoft sql server migrate mirroring status missing indexes money monitor sql server monitoring trace ms dtc MS MVP MS Sql server ms sql server 2005 MS SQL Server 2008 R2 Management Pack MVP NAP with Windows Server 2008 native clients new features of denali new kb released new version New year next version non system not associated not for replication november ctp ntfs null bitmap null values oledb operation manager optimize sql server stored procedure oracle order by clause in view returns result in random order orphaned users p2p packt publication packt publishing pageio latch paper partioned table partitioning table pass summit password patch for remote code execution patch sql cluster patching sql server cluster peer- peer replication performance dashboard performance problem performance tuning permission to run profiler port PowerShell 2.0 professional association for sql server profiler pss engineers PUG Pune User Group query tunning reading execution plan reaserch recommendation on shrinking database recompile recompile proc recompile view recovery reducing it costs register for sql server 2008 r2 register for sql server 2008 r2 ctp registry remote renaming Replication reporting server resizing database resolving upgrade issues resources restore with continue_after_error Restoring and Disaster Recovery strategy roles and responsibility rollback rollback is single threaded rollback takes more time rollback takes much longer time ross mistry row size estimation row/page compression scam scet schema changes script sdl search any object in database securing securing data securing sql server self taught dba server server consolidation serverproperty service service pack service pack release set options settings sharepoint shrinking database size of null sleeping status snapshot replication solution for t-log solution for t-log growth sp sp on sql cluster sp2 sp3 cu2 sp_addserver sp_adjustpublisheridentityrange sp_configure sp_detace_db sp_recompile space occupied by null sql sql 2000 sql 2005 sql 2008 sql 2008 r2 sql 2012 sql 2012 r2 sql active node sql audit sql cluster sql cluster best practices sql cluster review sql dba sql developers sql encryption SQL News sql patching cluster sql port sql presentations sql primary node sql pss sql server sql server 2000 sql server 2005 sql server 2005 sp3 Sql server 2008 sql server 2008 ctp sql server 2008 november ctp sql server 2008 r2 sql server 2008 R2 CTP sql server 2012 sql server administration sql server agent sql server alwayson sql server articles sql server book sql server citation sql server cluster SQL Server Cluster Best Practices sql server cluster checklists sql server community sql server dba quiz 2011 sql server ha sql server high availability SQL Server ISM SQL Server MVP sql server performance sql server performance tuning sql server script sql server security sql server training sql server upgrade methods sql server version sql service account sql setup sql sp setup on cluster sql sp3 sql turorial sql videos sqldbtools sqlpass sqlserverpedia sqlspec ssis ssis developer SSIS on Remote ssms stacia misner standard static value step-by-step installation steve balmer stored procedure stored procedure performance tuning stored procedures for beginners strategy for disaster recovery strength surat surat it pro community Surat SQL Server User Group Surat Technical community surat user group surface area configuration System system center system databases system view map t-log t-log filling up teched 2009 teched india teched india 2009 teched india events teched on the road TechEd Surat TechNet technology event the syntax for mdxfunction is incorroect Tips for Merge Replication Tool top 10 sql server clustering articles training kit transaction log transaction replication troubleshooting troubleshooting merge replication troublshoot trusted connection tuning stored procedure udf unable to produce query plan unexpected upcoming updatetext upgrade user user definded function v2v migration varchar and nvarchar varchar vs nvarchar version vhd vinod kumar violation of pk constraint virtual machine manager virtualization vtd wait types webcast welcome 2011 Welcome screen what is kill command doing in background what is log shipping what is new in sql server 2005 sp3 what is null what is stored procedure What's new in sql server Windows Server Windows XP workgroup
Powered by Blogger.

Services

sp_send_dbmail SSC

Enter your email address:

most executed queries

  • Difference between Stored Procedure and Function (UDF)
    Functions can be used with Select statement Not returning output parameter but returns Table variables You can join UDF Can not be used...
  • Cannot resolve the collation conflict
    Recently when I was referring to SQL Server Forums I saw a question that reads like: I get an error  Cannot resolve the collation conf...
  • Download MS SQL Server 2008 R2 Management Pack
    Recently Microsoft has released MS SQL Server 2008 R2 Management Pack, it can monitor the Microsoft SQL Server components such as database e...
  • How to Secure SQL Server - SQL Server Security Criteria
    Security ! This is the word comes in mind of every concerned person when it comes to store , access and share the data and database ...
  • Change the Collation setting in MS SQL Server
    How to Change the Collation Settings for specific database or how to change the Collation Settings for specific column ? This questio...

Site Sponsors

Facebook Fans

books online

  • Brent Ozar Unlimited
  • SQL Skills
  • CSS SQL Server Engineers
  • Extreme Expert's Blog
  • Troubleshooting SQL
  • SQL Authority
  • SQL Server Help
  • SQL Dude

Text Data

 

  • Disclaimer

    This blog is all about my personal experience while working on SQL Server technology, the way I learnt and troubleshoot issues, and learning new technical features of SQL Server.
    The information in this Site is provided "as is", with no guarantee of completeness, accuracy, timeliness. Please refer BOL/MSDN or Technet for technical reference.
    The whatsoever opinion mentioned here are my personal opinion, my employer/Microsoft do not endorse it.

    Visitors since May 2010

  • Copy Right

    creative commons license
    SQL Server Citation by Hemantgiri S. Goswami is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 2.5 India License.
    Based on a work at www.SQL-Server-Citation.com.

    Wibiya

    a

  • Listing


    Google PageRank Checker Software Computers blogs Blog Directory
    blogarama - the blog directory My BlogCatalog BlogRank IndiBlogger - The Largest Indian Blogger Community review www.sql-server-citation.com on alexa.com
Copyright © SQL Server Citation | Powered by Blogger
Design by NewWpThemes | Blogger Theme by Lasantha - Premium Blogger Themes
IMAP Email hosting