SqlServerKudos

Best Practices

1
kudos

Kudos

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

published 4 hours, 42 minutes ago posted by

sa 2 days, 6 hours, 12 minutes ago

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

This was the question asked by a developer, due to a particular process fills up the transaction log so quickly. I had to explain the reason and tricks that can reduce the transaction log bulge using best recovery methods on the database. Going back to basics there certain FAQ about Transaction log usage within SQL Server. Transaction Log - why it is required? A log is a seperate file that stores all kinds of information about the SQL Server instance and databases. Each database has its own log file...(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, DBA, disk space, free space, log writer, size, SQL Server, transactionon log, vlf

1
kudos

Kudos

SQL Bits 7 - Registrations now open

published 4 hours, 42 minutes ago posted by

sa 3 days, 1 hour, 28 minutes ago

While we talked about list of sessions and vote on interested ones: http://sqlserver-qa.net/blogs/etc/archive/2010/07/19/9329.aspx here is hte news for you to register for this SQLBits 7 - The 7 Wonders of SQL conference, even bigger and better. SQLBits 7 will take place over three days from Thursday September 30th to Saturday October 2nd. Day one will be a training day, featuring in-depth full day seminars by leading SQL Server professionals such as Brent Ozar and Buck Woody (see http://www.sqlbits.com/... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, community, Conference, SQL Server, SQL Server 2008 R2, SQLBits, Training

1
kudos

Kudos

Cumulative update package 9 for SQL Server 2008 Service Pack 1

published 4 hours, 42 minutes ago posted by

sa 9 days, 4 hours, 8 minutes ago

Cumulative update package 9 for SQL Server 2008 Service Pack 1

Download and test the latest instalment of cumulative Update 9 for SQL Server 2008 Service Pack 1 which consist the hotfix release related to SQL Server 2008 version and fix to the issues since the release of Service Pack 1. The build number for this CU9 package is 10.00.2789.00. and KBA970365 gets you the list of builds since SQL Server 2008 SP1 release: Build 10.00.2775 (cumulative update) - CU8 Build 10.00.2770 & Build 10.00.2769 - interim fixes Build 10.00.2766 (cumulative update) - CU7 Build...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, ctp, cumulative update, deadlock, package, Performance, release, SQL Server, Testing, trace flag

1
kudos

Kudos

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

published 1 day, 4 hours, 47 minutes ago posted by

sa 11 days, 4 hours, 33 minutes ago

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

The question is tricky as the answer too! Online index operation (Enterprise Edition specific) is the new addition in SQL Server 2005, the simple operation behind the scenes will be preparation, build and final, it is possible to perform the concurrent online index DDL operation on the same table or views when you are creating multiple nonclustered indexes (new) and in same case of reorganizing such nonclustered indexes. But you cannot simply create another index ONLINE when another index online...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, event class, Indexes, online, profiler, rebuild, SQL Server, trace

1
kudos

Kudos

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

published 3 days, 4 hours, 53 minutes ago posted by

sa 12 days, 5 hours, 23 minutes ago

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

BACKUPS are key to recover the data during the disaster recovery, but many times just taking backups is not sufficient as you need to ensure the backups are good enough with no corruption. The subject line message though classified as an information message, recently one of the databases were taking long time to finish the recovery whenever the SQL Server has been restarted and also during the RESTORE operations. Not an issue if this a Development environment but in the case of agreed downtime this...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: backups, Best Practices, CHECKDB, CHECKSUM, database consistency, dbcc, Restore, SQL Server, veirify only

1
kudos

Kudos

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

published 3 days, 4 hours, 53 minutes ago posted by

sa 12 days, 6 hours, 28 minutes ago

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

Here comes the 7 wonders of SQL conference - SQL Bits 7, this will take place from September 30 to October 02 2010 at York University . No doubt that SQLBits is the largest SQL Server conference in Europe and the previous six conferences have established it as a must-attend event for DBAs, developers and BI professionals who work with SQL Server and similar to last event SQLBits 6 in South Wales the event will be running the three day format that was so successful . Day one will be a training day,...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, community, Conference, DBA, devloper, pre-con, SQL Server, SQLBits, Training

1
kudos

Kudos

SQL Server Profiler: System is low on disk space on drive 'C'?

published 5 days, 5 hours, 3 minutes ago posted by

sa 14 days, 6 hours, 38 minutes ago

SQL Server Profiler: System is low on disk space on drive 'C'?

PROFILER is very handy tool to trace the events on SQL Server, like wise SQL Server 2008 gets the new feature Extended Events which is a light-weight & less intrusive tool. Still there are number of DBAs out there are really scared to invoke PROFILER on a production environment, the impact of running this tool for longer time is high and it is also very important tool for DBA to see what exactly is happening on server side. This is where a server side trace is very handy perform a server-side...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, collection, ebook, free space, gui, low space, profiler, pssdiag, server side, SQL Server, trace

1
kudos

Kudos

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

published 9 days, 5 hours, 23 minutes ago posted by

sa 18 days, 6 hours, 9 minutes ago

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

SQL Server 2008 R2 and Windows Server 2008 R2 has opened up new dimension of physical resource usage and limitations. As you may be aware Windows Server 2008 R2 is only available in 64-bit edition, having the features that are related to DB engine are changed in SQL Server 2008 R2. The high specificiation of physical resources you talk that refers to the highest edition of SQL Server which is Enterprise Edition and with R2 it is Data-Center edition. COming back to subject line I had to look at BOL...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: awe, Best Practices, cpu, edition, features, ia64, Memory, physical resource, SQL Server, Upgrade, x64

1
kudos

Kudos

Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services

published 12 days, 5 hours, 33 minutes ago posted by

sa 21 days, 7 hours, 29 minutes ago

Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services

Performance is the key aspect for Relational and Analytical databases, similarly processing bottlenecks are quite common within both systems if the configuration has not be set properly. Here are my thoughts & experience during a BI based project design & implementation using SQL Server 2008 version. Here comes next question, what is a proper configuration and how do you indicate that certain configuration is set for optimum performance? Analysis Services service in SQL Server 2008 provides...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Analysis Services, benchmarking, Best Practices, export, Performance, profiler, SQL Server, trace, xmla

1
kudos

Kudos

Must to have resource to design your SQL Server Architecture for High Availability and Disaster Recovery

published 15 days, 5 hours, 48 minutes ago posted by

sa 25 days, 1 hour, 59 minutes ago

Must to have resource to design your SQL Server Architecture for High Availability and Disaster Recovery

Synchronizing high availability databases and setting up synchronization systems without single points of failure are two challenges that organizations face as they bring synchronization systems to the 24/7 requirements of modern data systems. Do you have such a proven method to design High Availability (HA) & Disaster Recovery (DR) environment? Whenever a HA is talked about Failover Clustering is the one comes up, which is an expensive solution to adopt that can provide virtually no-down-time...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: architecture, Best Practices, deployment, Design, disaster recovery, high availability, recovery, rpo, rto, SQL Server, Technology

1
kudos

Kudos

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

published 15 days, 5 hours, 48 minutes ago posted by

sa 25 days, 3 hours, 4 minutes ago

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx) files that contain large, related datasets that you build in a separate PowerPivot window in Excel, and use with PivotTables and PivotCharts in a worksheet. This add-in can be downloaded from MS download...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, configuration, cpu, Installation, Memory, multiple, powerpivot, resources, server, SharePoint, SQL Server

1
kudos

Kudos

Microsoft patterns & practices is excited to announce the release of: Developing Applications for SharePoint 2010

published 18 days, 5 hours, 59 minutes ago posted by

sa 25 days, 7 hours, 24 minutes ago

Microsoft patterns & practices is excited to announce the release of: Developing Applications for SharePoint 2010

A good document release from Microsoft Patterns & Practices side about developing applications for SharePoint 2010 - a must see if you wanted to know best practices & good one for Architects. Microsoft patterns & practices is excited to announce the release of: Developing Applications for SharePoint 2010 In this email : | Customer Value | What’s in This Guide | Goals | About patterns & practices | Customer Value SharePoint 2010 introduces new ways of developing applications for the...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: applications, Best Practices, deployment, guide, patterns & practices, platform, sharepoint 2010, SQL Server

1
kudos

Kudos

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

published 19 days, 6 hours, 4 minutes ago posted by

sa 28 days, 7 hours, 59 minutes ago

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

Red-Gate tools needs no introduction to SQL Server users, they are encouraging best practices within the community by promoting awards such as Exceptional DBA of the year that has been started last year. So now the same contest we have six finalists instead of the normal five were named this year, reflecting the high quality of nominations. Now it's your turn to help us find the Exceptional DBA of 2010. Get to know the finalists and vote for the winner between June 23 and July 23, 11:00 hours (GMT)....(r... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, code-plex, community, DBA, exceptional dba, red-gate, SQL Server, toolkit, vote

1
kudos

Kudos

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

published 24 days, 6 hours, 29 minutes ago posted by

sa 32 days, 6 hours, 50 minutes ago

$SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?$

Here is an interesting 'sql security' discussion I had during the SASSUG usergroup interaction with regard to BUILTIN\Administrator role from SQL Server 2008 onwards. Since SQL Server 2005 the instance has been classified as 'secured by design/default' by cutting down the elevated access to the SQL Server. From the operating system side login privilege, by default SQL adds the group BUILTIN\Administrators to the sysadmin fixed server role, meaning that any local NT administrator is automatically...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, Best Practices, builtin\administrator, control, DAC, DBA, dedicated admin console, registry, Security, SQL Server, UAC, windows authentication

1
kudos

Kudos

Register for PASS Summit 2010 by June 30: Get $600 off full conference rate.

published 29 days, 6 hours, 49 minutes ago posted by

sa 37 days, 8 hours, 20 minutes ago

Register for PASS Summit 2010 by June 30: Get $600 off full conference rate. Save 30% on the biggest and best SQL Server and BI conference in the world. Hurry and take advantage of these huge savings! Plus, if you register at the discounted rate between June 2-30, we guarantee you'll love the PASS Summit 2010 lineup or you get your money back . Register today and join us in Seattle, WA, November 8-11, 2010....(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: benefits, Best Practices, Conference, discussions, SQL Server, sqlpass, usergroup

1
kudos

Kudos

Developer training kits to download for your learning upgrade

published 31 days, 6 hours, 59 minutes ago posted by

sa 39 days, 7 hours, 54 minutes ago

Developer training kits to download for your learning upgrade

Here is an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008, Visual Studio 2010, .NET framework 4, Windows Server 2008 R2 & Windows Azure platform. Microsoft's Developer & Platform Evangelism team has brought good resources for you to downlod the content and upgrade your knowledge at your own pace: Visual Studio 2010 and .NET Framework 4 Training Kit Windows Server 2008 R2 Developer Training Silverlight 4 Training Hands-On Labs...(read more) (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: .net framework 4, Best Practices, kit, learning, microsoft, SQL Server, SQL Server 2008 R2, training course, Upgrade, visual studio 2010

1
kudos

Kudos

SQL Server Hardware Checklist - a primer for DBA

published 31 days, 6 hours, 59 minutes ago posted by

sa 39 days, 8 hours, 59 minutes ago

SQL Server Hardware Checklist - a primer for DBA

Every once in a while you might get into complexity in managing a process, even though it is a simple one! So this is where a checklist will come handy to ensure you do not commit any 'blunders' on your day-to-day business.You may relate the DBA checklist to Airline pilot's checklist who will always perform the drill without having any miss of list of chores when they fly. For every DBA a checklist to manage the platform is very helpful, I do have a list of points that I form as a checklist whenever...(r... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: Best Practices, checklist, compatability, configuration, DBA, Hardware, SAN, setup, SQL Server

1
kudos

Kudos

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

published 31 days, 6 hours, 59 minutes ago posted by

sa 40 days, 9 hours, 4 minutes ago

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

Thanks for the feedback and followup questions from the SQL Server HA: Quick view of Database Mirroring session between partners post here. From the majority of the followup questions the main topic is to asking process on how quickly you can find the issue within the SQL Server database mirroring environment. Here is a quick notes on what you need to go through if there is a problem reported within the database mirroring partners. Database Mirroring monitor is the first hand tool to see the status...(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, database mirroring, endpoint, firewall, ports, service account, SQL Server, tcp, Troubleshooting

1
kudos

Kudos

Control database management tasks from command line - SQLCMD

published 37 days, 7 hours, 25 minutes ago posted by

sa 45 days, 9 hours, 39 minutes ago

Control database management tasks from command line - SQLCMD

If you remember ISQL or OSQL then you should continue using SQLCmd from SQL Server 2005 onwards, an useful utility lets you enter TSQL statements, system procedures, and script files at the command prompt. Not only as a command line from outside of SQL process, you can run this tool from SSMS Query Editor in SQLCMD mode, in a Windows script file or even in an operating system (Cmd.exe) job step of a SQL Server Agent job. In the recent connection with a client about Database upgrade project, it has...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: behaviour changes, Best Practices, code, command prompt, execution, SQL Server, sqlcmd, TSQL

1
kudos

Kudos

Slipstream and StreamInsight - SQL Server new features for your advantage

published 41 days, 7 hours, 44 minutes ago posted by

sa 50 days, 9 hours, 20 minutes ago

Slipstream and StreamInsight - SQL Server new features for your advantage

Slipstream and StreamInsight, for a second both of them sound similar and you may think they are same too. For my session at Microsoft Tech-Ed North America 2010 - SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field we had a good feedback from the users, waiting to get answer for their questions (after the session) and clarifying their doubts from the Database Platform booth at Tech-Ed Exhibition hall. Keeping that aside I had that embarassing moment (for a second) when...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, downgrade, installallation, merge drop, slipstream, SQL Server, support

Welcome!

Best Practices

SQL Server - What is Transaction log file? Can I delete it? Think about Database Recovery Model too!

SQL Bits 7 - Registrations now open

Cumulative update package 9 for SQL Server 2008 Service Pack 1

SQL Server database maintenance: How to find out the execution duration of ONLINE Index build operation?

SQL Server log messages: Analysis of database is 0% complete (approximately 0 seconds remain). Phase 1 of 3. This is an informational message only. No user action is required.

SQLBits 7 - 30 Sep to 02 October 2010, sessions open for voting

SQL Server Profiler: System is low on disk space on drive 'C'?

SQL Server and Windows Server R/2008 version: Physical Resources support for high-end systems

Trace & Troubleshooting performance: take advantage of server side tracing for SQL Server Analysis Services

Must to have resource to design your SQL Server Architecture for High Availability and Disaster Recovery

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

Microsoft patterns & practices is excited to announce the release of: Developing Applications for SharePoint 2010

Community here is your chance: Vote for 2010's Exceptional DBA Awards winner

SQL Server 2008 Security gotcha: BUILTIN\Administrator is no longer SYSADMIN, only in case of?

Register for PASS Summit 2010 by June 30: Get $600 off full conference rate.

Developer training kits to download for your learning upgrade

SQL Server Hardware Checklist - a primer for DBA

SQL HA: Quick troubleshooting technique review of ENDPOINT within Database Mirroring partners

Control database management tasks from command line - SQLCMD

Slipstream and StreamInsight - SQL Server new features for your advantage

Open ID Login

Standard Login

Forgot Password?

Sign up