СОДЕРЖАНИЕ

1.	СОВЕТЫ
1.1.	Счётчики производительности SQL Server и Windows (продолжение)
2.	ССЫЛКИ НА СТАТЬИ
2.1.	Статьи на русском языке
2.2.	Новые и обновлённые технические статьи Microsoft
2.3.	Англоязычные статьи
3.	ФОРУМ SQL.RU
3.1.	Самые популярные темы недели
3.2.	Вопросы остались без ответа

СОВЕТЫ

Счётчики производительности SQL Server и Windows

1.    Введение
2.    Анализ узких мест
3.    Счётчики
4.    Типы счётчиков
5.    Память
5.1. Поиск узких мест использования памяти Windows 2000
5.2. Наборы счётчиков мониторинга памяти
5.3. Системная таблица sysperfinfo
5.4. Диагностика всплесков отложенной записи
6.    Процессор
6.1. Поиск узких мест использования процессора Windows 2000
6.2. Набор счётчиков мониторинга процессоров
7.    Дисковая подсистема
7.1. Поиск узких мест использования дисковой подсистемы сервера Windows 2000
7.2. Набор счётчиков мониторинга дисковой подсистемы
8.    Сеть
8.1. Поиск узких мест сети
8.2. Набор счётчиков мониторинга сети

9. Встроенные средства контроля производительности SQL Server

Наряду с упоминавшейся уже выше в этой статье системной таблицей sysperfinfo, существуют и другие средства мониторинга производительности работы компонент MS SQL Server. Упоминания о многих из них уже убраны из SQL Server Books Online, но, видимо, из соображений обратной совместимости, они продолжают присутствовать в поставляемом конечному пользователю дистрибутиве и по сей день.

9.1. Статистические системные функции

Следующие серверные функции позволяют DBA в реальном масштабе времени получать статистическую информацию о производительности MS SQL Server:

1. @@cpu_busy - возвращает время в миллисекундах со времени последнего запуска сервера, которое процессор потратил на свою работу.
2. @@io_busy - возвращает время в миллисекундах со времени последнего запуска сервера, которое SQL Server потратил на выполнение операций ввода - вывода.
3. @@idle - возвращает время в миллисекундах со времени последнего запуска сервера, которое SQL Server простаивал.
4. @@pack_sent - возвращает число отправленных в сеть SQL сервером пакетов, со времени последнего запуска сервера.
5. @@pack_received - возвращает число полученных SQL сервером из сети пакетов, со времени последнего запуска сервера.
6. @@packet_errors - возвращает число ошибок сетевых пакетов, которые произошли при подключении к серверу баз данных, со времени последнего запуска сервера.
7. @@total_read - возвращает число операций дискового чтения, выполненных SQL сервером со времени последнего запуска.
8. @@total_write - возвращает число операций записи на диск, выполненных SQL сервером со времени последнего запуска.
9. @@total_errors - возвращает число ошибок операций чтения/записи с дисков, которые выполнял SQL сервер со времени последнего запуска сервера.
10. @@connections - возвращает число подключений (или их попыток) к SQL Server, со времени последнего запуска сервера.
11. fn_virtualfilestats - Возвращает статистику ввода-вывода для файлов базы данных, включая журналы транзакций.

9.2. Системная таблица spt_monitor и процедура sp_monitor

SQL Server использует представленные выше статистические функций в системной хранимой процедуре sp_monitor, которая отображает текущие значения, возвращённые этими функциями, и показывает насколько они изменились со времени последнего её исполнения. Для сравнения текущих и предшествующих значений используется системная таблица spt_monitor, которая вместе с процедурой базируется в базе данных master.
Вызывается она просто:

USE master
EXEC sp_monitor

Возвращает она четыре таблицы, которые имеют следующий вид:

last_run	current_run	Seconds
2003-09-11 13:36:04.677	2003-09-12 14:11:38.537	88534

cpu_busy	io_busy	idle
8458(2229)-2%	958(166)-0%	688914(169139)-191%

packets_received	packets_sent	packet_errors
2162601(519325)	2526801(597183)	0(0)

total_read	total_write	total_errors	connections
67808(11979)	1025105(241354)	0(0)	142865(34499)

Статистическая информация по столбцам выводится в формате number(number)-number% или number(number). Первое число показывает количество секунд (для: cpu_busy, io_busy, и idle) или общее количество (для других переменных), с момента последнего перезапуска SQL Server. Число в круглых скобках показывает количество секунд или общее количество с последнего запуска процедуры sp_monitor. Последняя цифра показывает, какая доля в процентном отношении от полного времени или количества относится к последнему измерению со времени последнего запуска sp_monitor. Например, если cpu_busy показывает как 8458(2229)-2%, это означает, что: CPU были заняты 8458 секунд, со времени последнего запуска SQL Server; 2229 секунд он был занят со времени последнего запуска sp_monitor; и 2 процента от полного времени составляет интервал измерения от последнего запуска sp_monitor. В теле процедуры это вычисляется следующим образом:

cpu_busy = 
substring(
convert(varchar(11),  convert(int, ((@cpu_busy * @mspertick) / 1000))) 
+ '(' + 
convert(varchar(11), convert(int, (((@cpu_busy - cpu_busy)*@mspertick) / 1000))) 
+ ')' + '-' + 
convert(varchar(11), convert(int, ((((@cpu_busy - cpu_busy)*mspertick)/1000)*100)/@interval)) 
+ '%', 1, 25)

9.2. DBCC SQLPERF(...)

В ранних версиях SQL Server, до появления системной таблицы sysperfinfo, для получения статистической информации о производительности использовалась команда dbcc sqlperf(…). В MS SQL Server 2000 сохранились некоторые её возможности (в порядке поддержки обратной совместимости) но в документации описана только одна команда: dbcc sqlperf (logspace). В этой статье приводятся три команды, которые возможно было исполнить на MS SQL Server 2000 SP3a. Для правильного исполнения этих команд необходимо настроить параметры среды:

SET NOCOUNT ON
SET STATISTICS TIME ON
dbcc traceon(3604)

Команда dbcc sqlperf(lrustats) выдаёт подробности использования кэша. Ниже представлен пример вывода результатов её исполнения:

Statistic	Value
Cache Hit Ratio	99.994118
Cache Flushes	0.0
Free Page Scan (Avg)	0.0
Free Page Scan (Max)	0.0
Min Free Buffers	331.0
Cache Size	4362.0
Free Buffers	922.0

Команда dbcc sqlperf(IOSTATS) выдаёт активность операций ввода-вывода. Вот пример результирующей таблички:

Statistic	Value
Reads Outstanding	0.0
Writes Outstanding	0.0

Database Name	Log Size (MB)	Log Space Used (MB)	Status
master	3.3671875	31.540024	0
tempdb	0.7421875	58.421051	0
model	0.4921875	68.650795	0
msdb	1.2421875	45.715408	0
pubs	2.2421875	34.342335	0
Northwind	9.5546875	28.899223	0
distribution	0.9921875	55.216534	0

ПРОДОЛЖЕНИЕ СЛЕДУЕТ

[В начало]

ССЫЛКИ НА СТАТЬИ

Статьи на русском языке

Об SQL Server Yukon
Поль Тюрро
Испытание первой бета-версии разрабатываемой Microsoft новой редакции SQL Server под названием Yukon назначено на середину 2003 г., а выпуск продукта ожидается в начале 2004 г. Это событие по своему значению приравнивается к выходу Windows Server 2003, поскольку Yukon станет для пользователей новым сервером баз данных и платформой, на которой будут строиться новая служба каталогов Active Directory (AD) и версии Microsoft Exchange Server, файловая система Windows и другие продукты. По словам представителей Microsoft, технология Yukon обладает расширенными возможностями программирования, усовершенствованной корпоративной базой данных, а также развитой бизнес-логикой...
Модели восстановления изнутри
Кэлен Дилани
Для меня возможность описать модель восстановления (Recovery Model) — одно из наиболее примечательных качеств SQL Server 2000 и одновременно одно из самых первых свойств SQL Server 2000, о которых я рассказывала в своих статьях. В то время продукт находился еще на стадии бета-тестирования, но было очевидно, что об этом новом свойстве сервера баз данных многие захотят узнать заранее, прежде чем выполнять обновление SQL-систем...
Блюз помех
Хертс Чен
Разработчики приложений и баз данных, вероятно, сталкивались с чрезвычайно длительным выполнением такими утилитами, как bcp (программа экспорта данных), служба передачи данных DTS и репликации данных, копирования большого количества данных в разнообразные источники. Например, передача снимка базы, которая содержит 500 Мбайт данных, с ограничениями по ключам и индексами, между двумя мощными четырехпроцессорными серверами с оперативной памятью объемом 1 Гбайт и дисковым массивом RAID 5 потребует 2 ч в рабочее время или 1,5 ч в ночное время. Подобная производительность неприемлема для серверов промышленного назначения с круглосуточной нагрузкой или распределенного хранилища данных предприятия, время состояния которого в непиковом режиме слишком мало, чтобы обеспечить перен...

[В начало]

Новые и обновлённые технические статьи Microsoft

BUG: A Failed Assertion Is Generated During a BULK INSERT Statement
BUG: A SET USER Command Run by Using an Xp_cmdshell or a Cmdexec Job Step Returns Incorrect Value for the Service Log On Account in a SQL Server 2000 Cluster
BUG: Error Message "Either BOF or EOF is True, or the current record has been deleted." Occurs When You Archive an OLAP Database
BUG: SQLOLEDB Incorrectly Converts Char Data When AutoTranslate Is Turned On
FIX: 70rebind.exe for Windows 2000 and MDAC Upgrades on Clustered SQL Server 7.0 Servers
FIX: A Parameterized UNION Query Inside a Stored Procedure Returns Incorrect Results
FIX: A Transact-SQL Statement That Is Embedded in the Database Name Runs with System Administrator Permissions
FIX: Dimension Calculated Member Caption Blank If Dimension Uses Caption Type Member Property
FIX: Inserting Unicode Data into SSCE Causes SQL Server CE to Stop Responding or Causes an Exception Error
HOW TO: Manually Remove SQL Server 2000 Default, Named, or Virtual Instance
INF: How to Obtain the Latest SQL Server 2000 Service Pack
MS03-031: Security Patch for SQL Server 7.0 Service Pack 4
MS03-031:Security Patch for SQL Server 2000 Service Pack 3
SAMPLE: Mfceqado.exe Shows How to Use English Query with MFC and ADO
SQL Server 2003 Performance Counters Do Not Appear in the Performance Collection Rules of the SQL Server Management Pack

[В начало]

Англоязычные статьи

SQL Server interesting facts - Part 3: Murphy’s laws for SQL Server
Alexzander Nepomnjashiy
Murphy’s laws for databases: If you have created the new database, filled it with the data, “sticked” the users to it etc., it turns out instantly, that the data structure and its content is needed to be changed
How the Query Optimizer Uses Statistics
This tip is one of a series from SQL Server Magazine. For additional tips, visit the SQL Server Tips and Tricks Center. When the query optimizer in SQL Server 7.0 examines the distribution statistics of a composite index, does it take into account the statistics for each column in the index or just the statistics in the first column (assuming that this table has only index statistics, not column statistics)? If the optimizer considers statistics for each column in the index, could it choose an index because the last column in that index has favorable statistics? Consider the following example (assuming the table contains data)
Where Do I Want To Go Today? - Index Tuning Wizard
Steve Jones
Taking a note from Microsoft's own page, I've decided to share some of my wishes for where I want SQL Server to go. Today. Meaning this is what I'm looking for now, the things that I'd like to see implemented in future releases. Now I missed the Yukon preview and haven't read too terribly much on it, so I may be asking for something that's coming. If it's not under NDA, let me know
Updating SQL Server Connection Properties from the DTS Package INI File
Muthusamy Anantha Kumar
In a typical development, QA or production environment, it can be very hectic to change all of the connection parameters, such as source file path, destination server name, table name, userID, password etc. in the DTS package when we move the packages from one environment to another environment. This article will step you through the use of the INI file with DTS package and how to update the connection properties from the INI file during run time
SQL Server Connection Pooling Myths
Shawn Kresal
Many of us are already familiar with connection pooling and understand to some degree its importance in web and SQL Server programming. We’ve all heard the adage that “connections are expensive” and “pooling is good”. This article will examine the topic in more detail, bringing to light some of the finer points of connection pooling
Automate DTS Logging
Haidong Ji
Many DTS packages are written by developers who may not know much about SQL and/or SQL Server. With the popularity of DTS as an ETL tool increasing everyday, many SQL Server DBAs are called to debug and troubleshoot DTS packages that were poorly written and organized. One important tool to help this is DTS logging
MDX Essentials - MDX Time Series Functions, Part III: The LastPeriods() and ParallelPeriod() Functions
William Pearson
This is the eleventh article of the series, MDX Essentials. The primary focus of this series is an introduction to MDX. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs
Updating SQL Server Connection Properties from the DTS Package INI File
Muthusamy Anantha Kumar
In a typical development, QA or production environment, it can be very hectic to change all of the connection parameters, such as source file path, destination server name, table name, userID, password etc. in the DTS package when we move the packages from one environment to another environment. This article will step you through the use of the INI file with DTS package and how to update the connection properties from the INI file during run time
Using SQL Server's CHARINDEX and PATINDEX
Gregory A. Larsen
If you have written many applications then you probably have run across situations where you need to identify if a specific character or set of characters appears in a string. In this article I will discuss using the CHARINDEX and PATINDEX functions to search text columns and character strings. I will show you how each of these functions operate, and explain the differences between them. Also provided are some examples on how you might consider using these functions to solve a number of different character search situations
Populating the TreeView Control from a Database
Don Schlichting
TreeView is a new Internet Explorer WebControl for ASP.NET that presents hierarchical datasets, folders, and XML documents in a familiar parent child view similar to the Windows File Explorer. This article will provide an introduction to the TreeView and then provide detailed steps for populating the tree from a database
Damming the Database Holes
Lisa Vaas
Eight months after the SQL Slammer worm threw SQL Server database administrators into a tizzy, Microsoft Corp. is committing itself to providing semiautomatic updates that will patch holes in the enterprise database
Top 10 SQL Server security blunders, part II
Jan Stafford
A security breach is never pretty. When a hacker gets into a database, however, things get downright ugly
Top 10 SQL Server security blunders, part I
Jan Stafford
Do you ever lock the front door and leave the back door wide open? That kind of half-safe security practice is all too common among database administrators, said database security expert Aaron C. Newman. In many cases, DBAs get lucky and hackers overlook their oversights. Too often, their luck runs out
Practicing Recovery
Brian Moran
Microsoft escalation engineers bring a vast amount of experience to the Product Support Services (PSS) groups. In Tuesday's special edition of SQL Server Magazine UPDATE, I told you about the role of Bob Ward, an escalation engineer with SQL Server PSS, and explained the evolution of PSS. This week, let's look at some practical advice that Ward gave me
A Brief History of SQL
Frank Kalis
The original concept behind relational databases was first published by Edgar Frank Codd (an IBM researcher, commonly referred to as E.F.Codd) in a paper, “Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks” (RJ599), dated 08/19/1969. However, what is commonly viewed as the first milestone in the development of relational databases is a publication by Codd entitled „A Relational Model of Data for Large Shared Data Banks“ in Communications of the ACM (Vol. 13, No. 6, June 1970, pp. 377-87). This was only a revised version of the 1969 paper
Most useful counters for SQL Server performance monitoring
Svetlana Kuvshinkova
Hi friends! This is my first attempt to incorporate: my past article Some tips on SQL Server server performance monitoring, Myitforum.com columnist comments and my changed views on subject (I mean SQL Server performance monitoring) into one article
SQL Server profiling, monitoring and tuning: Before we begin … (Part 1)
Svetlana Kuvshinkova
By this article (first in my series) I would like to begin discussion about factors (that contribute to SQL Server performance) such as hardware, operating system configuration parameters, network, front-end applications, and, finally, database design and Transact-SQL code your application use. We will discuss ways the database administrator use monitoring tools and situations when using these tools are applicable. We will cover performance monitoring and profiling “best practices” and show various Microsoft SQL Server 2000 optimization tips, tuning techniques and approaches
SQL Server profiling, monitoring and tuning: Choosing the right monitoring tool … (Part 2)
Svetlana Kuvshinkova
There are a several dozens (or hundreds … frankly speaking I do not know) tools, available on the market, we can use to monitor database server performance. Most of them are comes from independent, third party software vendors (for example: iWatch and Spotlight on SQL Server (from Quest Software Inc.), Zero Impact SQL Monitor, Zero Impact Service Level Monitor, Zero Impact Top N Sql Analyzer and eData Usage Analyzer (included into SQL Power Tools package, from SQL Power Tools, Inc.), etc.). The tool you choose to use is largely based on your preference (and out of this article scope), each tool has its own set of benefits, advantages and unique abilities. Here, I would like to name here only one, common their disadvantage: high cost (can vary in a very wide range: from couple hundreds to several tens thousands dollars). Fortunately, Microsoft includes two powerful tools (of course, really, more then two … :-)): System Monitor (or Performance, as it visible under “Administrative Tools” program group) (as a part of Windows NT 2000 operating system) and SQL Server Profiler (as a part of SQL Server 2000 database server) at zero cost for you
SQL Server profiling, monitoring and tuning: SQL Server Performance Objects (Part 3)
Alexzander Nepomnjashiy
Friends, can I ask you one unusual question? Do you know what is your wife doing right now? Not sure J? But I know what mine’s wife doing!!! She is trying to prepare next chapter in SQL Server profiling, monitoring and tuning series. You can check she’s previously written chapters: “SQL Server profiling, monitoring and tuning: Before we begin … (Part 1)” and “SQL Server profiling, monitoring and tuning: Choosing the right monitoring tool … (Part 2)”
SQL Server profiling, monitoring and tuning: System Monitor (Part 4)
Svetlana Kuvshinkova
We continue our discussions, started by “SQL Server profiling, monitoring and tuning: Before we begin … (Part 1)”, “ SQL Server profiling, monitoring and tuning: Choosing the right monitoring tool … (Part 2)” and “SQL Server profiling, monitoring and tuning: SQL Server Performance Objects (Part 3)” articles. In this one, I will give you general overview of Windows 2000 System Monitor, what it stands for, how to use this tool, its benefits (and limitations, too!!!). Also, we discuss performance objects, useful for monitoring server hardware subsystems (CPU unit(s), hard disk(s) (drive(s)), random-access memory (RAM), network interface card(s) (NICs)). Lately, in my future article “SQL Server profiling, monitoring and tuning: System Monitor most useful performance counters (Part 5)” we discuss most widely used and most useful System Monitor counters
SQL Server profiling, monitoring and tuning: SQL Enterprise Manager, SQL Server commands, statements and operators (Part 5)
Svetlana Kuvshinkova
We will continue our discussions, started by: “SQL Server profiling, monitoring and tuning: Before we begin … (Part 1)”, “SQL Server profiling, monitoring and tuning: Choosing the right monitoring tool … (Part 2)”, “SQL Server profiling, monitoring and tuning: SQL Server Performance Objects (Part 3)” and “SQL Server profiling, monitoring and tuning: System Monitor (Part 4)” articles. Here, in this one, we will discuss how DBAs benefit from using Enterprise Manager and SQL Server internals (system stored procedures, functions, SET commands, DBCC functions and trace flags) in process of SQL Server performance monitoring
Calling CryptoAPI from Stored Procedures
Gregory A. Larsen
Do you have sensitive data stored in SQL Server? Would you like to encrypt or hash some of that sensitive data? This article will show you how to call CAPICOM to invoke CryptoAPI from TSQL to hash or encrypt/decrypt data
Timestamps
Trudy Pelzer
This month, I’ll discuss the TIMESTAMP data type, or, to use its SQL Server name, the DATETIME data type. My objective is to compare the functionality of IBM DB2 v8.1, Microsoft SQL Server 2000, and Oracle9i (the Big Three) with respect to the data type's range and precision, as well as time zones. Hopefully you'll get a clear idea along the way about why TIMESTAMP is useful, and why using it can be dangerous
Replication Between Adaptive Server Enterprise and Microsoft SQL Server
Sybase, Inc.
This white paper describes how to configure replication from Adaptive Server Enterprise (ASE) to Microsoft SQL Server (MS SQL Server), and from MS SQL Server to ASE
How to Fix the Problem When ADO Truncates Milliseconds from SQL Server Datetime Columns
Brian Lockwood
If you create a SQL Server table that contains a datetime column and populate it with a GetDate() default then try to query it with ADO, you will discover that the data returned from datetime columns is returned without milliseconds. If you need milliseconds returned, this can be very annoying to deal with
Create a Database Schema Repository with Meta Data Services in SQL Server 2000
Alok Mehta and Ricardo Rodriguez
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository
Paging results using T-SQL
Stephen Loschiavo
In the world of Internet development, there are many times when a web page needs to display a subset of a large result set, that is, "paged results." Microsoft's ADO and the .NET platform offer this as a feature of the datagrid class, however the problem with this is that the complete recordset (containing all the data) is sent to the web server each time a page is viewed. This has an impact on web server memory and the bandwidth between the web server and the database server (if they are on separate machines)
Implementing SQL Server in a DotNet Environment: .NET Connection Pooling and Connection Management
Eric Charran
Many business organizations are developing next generation business solutions which require a large degree of richness and functionality at a decreased total cost of ownership. These business solutions must be constructed in a time-effective manner and often integrate across platforms. Technical teams are finding themselves forced to choose a stable and robust platform to develop these solutions on, while meeting the requirements and constraints of budgets and business needs
Question: "How can I find out if two tables are equal to each other?"
Joe Celko
How can I find out if two tables are equal to each other? This is a common programming problem and the specification sounds obvious
DBAzine SQL Server Tip #3: Obtaining Operating System File Information
Gregory A. Larsen
Ever want to return operating system file information via a SQL Server stored procedure (SP), or Transact SQL (TSQL)? If so, let me tell you about the undocumented SQL Server xp_getfiledetails extended SP
Upgrading to Windows 2003
Chris Kempster
This whitepaper encompasses some of the experiences I had with upgrading a application development teams server environment from Windows 2000 to Windows 2003. The paper will include the basic processes I followed in terms of documenting and managing application testing and some of the pre/post installation issues
SQL Server, XML, and the DBA
Daryl Barnes (and others)
Some of the reasons you have bought this book may include: You need to return queries on SQL Server relational data in an XML format. You want to store XML data in SQL Server. You want to find out more about SQL Server's XML capabilities in general
SQL Server Application and Transact-SQL Performance Checklist
Brad M. McGehee
Of all the areas that can negatively affect the performance of SQL Server, the application code used to access SQL Server data, including Transact-SQL code, has the biggest potential of hurting performance. Unfortunately though, this is an area that a lot of DBAs don't directly control. And because of this, this area if often neglected when performance tuning SQL Server-based application
Using Performance Monitor to Identify SQL Server Hardware Bottlenecks
Brad M. McGehee
The best place to start your SQL Server performance audit is to begin with the Performance Monitor (System Monitor). By monitoring a few key counters over a 24 hour period, you should get a pretty good feel for any major hardware bottlenecks your SQL Server is experiencing
How to Perform a SQL Server Performance Audit
Brad M. McGehee
[Note: This is the first part of a multi-part article. Other parts of this article will become available over the next few months.] If you have been a DBA for long, then you will know that performance tuning SQL Server is not an exact science. And even if it were, it would still be difficult to find the "optimal" configuration for the "optimal" performance. This is because there are few absolutes when it comes to performance tuning. For example, while one particular performance-tuning tip may help boost performance one way, at the same time it might hurt performance in another way
Diagnose Server Performance Problems with SQL Server's SQL Profiler
Drew Georgopulos
SQL Profiler is a great SQL Server tool that can help you reach your database optimization goals. This 10-Minute Solution presents a few preparatory steps to start using Profiler for monitoring performance problems. It discusses some techniques, tools, and commands that reveal information about server behavior
SQL Server for CE Achitecture and Replication using eVB
Daniel Grandestaff
When designing a mobile solution, there are some business issues that need to be considered before the architecture can be designed. Is the application going to be connected to the host server continuously? Or is it going to be connected intermittently? Or rarely? These scenarios can greatly affect the behavior of the final product

[В начало]

ФОРУМ SQL.RU

Самые популярные темы недели

Ваше мнение об упражнениях SELECT на http://sql.ipps.ru
Новые упражнения на http://sql.ipps.ru
Книга по SQL 2000
Касяк с протоколами в Sql2000
Аудит изменений таблицы
Изменения в базу по триггеру
Устанавливать ли SP4 для Windows 2000
Разные подсети и connect к Sql2000
Как вывести сообщении print из триггера?
В чём прикол: Delfi+ADO+MSSQL - где теряется скорость запроса?
На сколько можно доверять Репликации транзакций.
константы и переменные вопрос на засыпку или что делать?
Как сделать Быстрый сервер?
Сервер НЕ ест память.. Как накормить? Или не надо?
подскажите, почему два подряд запроса не выполняются
Четыре SCSI-диска. Как распорядиться ?
База встает в Loading
Сериализация вызовово процедур
Выбор в разных таблицах в зависимости от значения в поле
Не смешно: Как ужать БД ? (+++)

[В начало]

Вопросы остались без ответа

SQL Parser
Организация поиска
Index Tuning вылетает
не идет backup transaction log в 6.5
Кто-нибудь встречал подобную ошибку 3157
Itanium 2 vs XEON
После передергивания SQL Server пишет, что does not exist or access denied
Интеграция SP3 в MS SQL Server 2000
Time out expired
Где увидеть удаление временных таблиц #
Возможны ли операции с xml файлами из Transact-SQL?
Создание таблицы на прилинкованном Excel'е
Вопрос по PowerDesigner
Ошибка 1053 при установке MS SQL Server 2000
Рассылка через CDO - как аттачить файлы?
Учебник для начинающего
два подзапроса слить в один, кэш
Шринкование - второй аргумент функции процент???

[В начало]