Browse Blog Posts by Tags

All Tags » sql server (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Распараллеленное соединение вложенных циклов (Nested Loops)

По материалам статьи из блога Craig Freedman : Parallel Nested Loops Join Перевод Ирины Наумовой Техническая редакция Александра Гладченко SQL Server распараллеливает соединение вложенных циклов (Nested Loops Join) , распределяя в случайном порядке строки внешней таблицы по потокам вложенных циклов....

Posted to Irina Naumova by Ирина Наумова on Mon, May 20 2013
Filed under: Filed under: SQL Server
Tips for DBA: Scripting jobs using Powershell (separated files)

Вашему вниманию предлагается сильно упрощённый пример сценария Powershell, который предназначен для скриптования заданий SQL Server в отдельные файлы. Тут используется папка для файлов C:\TEMP, которая должна быть предварительно создана и, желательно, пуста. Поскольку имена заданий будут использованы...

Posted to Alexander Gladchenko by gladchenko on Wed, Mar 27 2013
Filed under: Filed under: SQL Server, PowerShell, Tips for DBA
Calling Stored procedure from EF takes long time and times out!

Hi Folks, I was going through an interesting performance issue when calling a stored procedure from my web application more than one time and the WCF was timing out because of the stored procedure execution takes long time to execute. At the first, I...

Posted to Moustafa Arafa Blog by on Wed, Mar 20 2013
Filed under: Filed under: asp.net, EF, Performance, SQL Server
Optimizando SQL Server para SharePoint de acuerdo a mejores practicas

En esta ocasión decidí grabar una breve demostración de cómo optimizar SQL Server 2008 R2 para trabajar con SharePoint. Básicamente recurrí a las mejores prácticas de SQL Server para SharePoint publicadas aquí y el resultado fue justamente las configuraciones...

Posted to Haaron Gonzalez by haaron on Sat, Jan 5 2013
Filed under: Filed under: SharePoint, SharePoint 2010, Configuracion, SharePoint 2013, SQL Server 2008 R2, SQL Server
Backup of SQL Server databases from within Microsoft Access

WARNING : Some of the following instructions may not be best practice. This is a personal database so I can afford to take some shortcuts and not do thorough research. If you do use these tips and sample code in production check back in a week and a month to see if there...

Posted to Tony's Microsoft Access Blog by Tony on Sun, Dec 16 2012
Filed under: Filed under: Access, SQL Server, Disaster Recovery
SQL Server utility–sp_Blitz

I’ve been doing some work lately in SQL Server. I mentioned some issues I was having to my fellow Access MVPs and got some tips. Former Access MVP Tom Wickerath came across an excellent stored procedure that does a large number of checks of your SQL Server environment. sp_BLITZ™ – SQL...

Posted to Tony's Microsoft Access Blog by Tony on Sat, Dec 15 2012
Filed under: Filed under: Access, SQL Server
SQL Server # Database Backup Report using T-SQL

Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_name as DBName, b.backup_start_date...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Wed, Oct 17 2012
Filed under: Filed under: sql, sql server, sql 2005, script, sql 2000, sql server 2005, Sql server 2008, sql server 2008 ctp, sql server 2000, sql 2008, sql server 2008 november ctp, sql 2008 r2, sql server 2008 R2 CTP, sql server 2008 r2, sql 2012, sql server 2012, sql 2012 r2
Изменения в SQL Server 2012, связанные с диспетчером памяти

По материалам статьи Juergen Thomas: Memory Manager surface area changes in SQL Server 2012 в блоге SQLOS Team Автор: G Bowerman Перевод: Александр Гладченко Технический редактор: Ирина Наумова Множество изменений было внесено в компоненты диспетчера памяти SQLOS новой версии SQL Server 2012. Эти изменения...

Posted to Alexander Gladchenko by gladchenko on Mon, Sep 3 2012
Filed under: Filed under: SQL Server, SQLOS
Tips for DBA: Экспресс-диагностика достаточности памяти системе и экземпляру SQL Server

По ссылке в сценарии можно найти статью, которая меня вдохновила написать пример сценария, который может оказаться полезным для экспресс-диагностики проблем распределения оперативной и виртуальной памяти для нужд запрашиваемого экземпляра SQL Server и операционной системы. Я оставил только реальные ...

Posted to Alexander Gladchenko by gladchenko on Tue, Jun 19 2012
Filed under: Filed under: SQL Server, Tips for DBA, Troubleshooting
Оптимизации ввода-вывода для нагруженных баз данных

В докладе будут рассмотрены вопросы оборудования дисковых подсистем для задач SQL Server в приложениях хранилищ данных и OLTP нагрузки. Будут рассмотрены варианты использования сетей на основе Fibre Channel и коммутаторов SAN. Вы увидите какие ограничения могут накладывать на производительность ввода...

Posted to Alexander Gladchenko by gladchenko on Wed, May 2 2012
Filed under: Filed under: SQL Server, 24 HOP, PASS, IO
Livro de SQL Server 2012

Mais um livro grátis da Microsoft Press! http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx

Posted to Carlos Fernando Paleo da Rocha
SBS MVP in Brazil by paleo on Thu, Mar 15 2012
Filed under: Filed under: SQL Server
SQL Server 2012 releases RTM and Evaluation edition, don't missing virtual event launch 07th March 2012

SQL Server 2012 released – out there still organization in process to upgrade to SQL Server 2008 version the next release of product is ready now! In Microsoft's words: The world’s most widely deployed data platform, Microsoft SQL Server 2012, has...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 7 2012
Filed under: Filed under: sql server, version, documentation, beginners, new features, sql server 2012, virtual launch, #sql2012, #sqlfamily
SQL Server Express LocalDB - The New Express!

With the introduction of SQL Express LocalDB (part of SQL Server 2012 a.k.a. "Denali"), the available Microsoft SQL database options available now are: Regular SQL Server SKUs SQL Server Express SQL Server Compact Edition (CE) SQL Express LocalDB LocalDB is a lightweight version of SQL Express...

Posted to Blue Blip by Siva M on Wed, Feb 1 2012
Filed under: Filed under: SQL Server
Изменения в автоматическом обновлении статистики SQL Server -T2371

По материалам статьи Juergen Thomas: Changes to automatic update statistics in SQL Server - traceflag 2371 Перевод: Александр Гладченко Технический редактор: Ирина Наумова C 1998 года, когда вышел SQL Server 7.0, базовым принципом дизайна автоматического обновления статистики было отслеживание количества...

Posted to Alexander Gladchenko by gladchenko on Fri, Jan 27 2012
Filed under: Filed under: SQL Server, Tips for DBA
How to keep a track of list of SQL Server versions and builds releases?

I believe until SQL Server 2000 (or even SQL 2005) it was easy to remember the release version of your SQL Server instance. Since the changes affected from SQL Server Release Services and inception of Cumulative Update packages it is hard to keep a track...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 17 2012
Filed under: Filed under: sql server, dba, release, version, service pack, cumulative update, Database Maintenance, blogger
Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 16 2012
Filed under: Filed under: sql server, management, ssms, dba, best practice, beginners, cookbook, ucp, #sql2k8r2cookbook, data tier, utility control point
SQL Server Opertional practices: Support ended for SQL Server 2005 Service Pack 3 and its time to upgrade too!

As of today the support for SQL Server 2005 Service Pack 3 ends, though the mainstream support for SQL Server 2005 was ended on 12th April 2011. This means only extended support is available for this version until 12th April 2016. Though there is a differnt...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 10 2012
Filed under: Filed under: sql server, dba, upgrade, best practices, lifecycle, administrator, sp_configure, sp3, upgrade advisor, #sql2k8r2cookbook, support life cycle
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 9 2012
Filed under: Filed under: sql server, performance, high availability, database mirroring, key, solution accelerator, cookbook, #sql2k8r2cookbook
Microsoft SQL Server 2012 Licensing Model Changes

The long and short of it is there are several changes in the way SQL 2012 will be offered from a licensing and product stand point. The Three Main Versions of SQL Server Server + CAL Core-Based Enterprise Business Intelligence (NEW) Standard What you need to know about Core based Licensing Microsoft...

Posted to Winrox - Architecture of Acceleration(TM) by jeffl on Sun, Jan 8 2012
Filed under: Filed under: Licensing, News, SQL Server, SQL, 2012
Master SQL Chef series: Designing automated administration #sql #sql2k8r2cookbook

The administrative tasks such as managing backups, jobs, alerts and database maintenance activites are essential for every DBA. The tasks will be more complex and larger when the data platform is spread across the Enterprise, key task is to be able to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 4 2012
Filed under: Filed under: sql server, security, jobs, best practices, system, schedule, policy based framework, cookbook, automated administration, builtin

Page 1 of 95 (1897 items) 1 2 3 4 5 Next > ... Last »

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.