SQL.RU
 client/server technologies
 Главная | Документация | Статьи | Книги | Форум | Блоги | Опросы | Гостевая | Рассылка | Работа | Поиск | FAQ |
   
#356<<  #357  >>#358

СОДЕРЖАНИЕ

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

 

СТАТЬИ

Основы ввода-вывода Microsoft SQL Server. Часть 2 (продолжение)

По материалам статьи Bob Dorr: Microsoft SQL Server I/O Basics. Chapter 2

Закрепление страниц памяти

И 32-х и 64-битные редакции SQL Server могут использовать программный интерфейс AWE для закрепления страниц в памяти ( lock pages in memory), как это делается посредством VirtualLock, и потому закрепление всех страниц в памяти не гарантируется в том смысле, как это гарантируется при использовании AllocateUserPhysicalPages. Иногда это может вводить в заблуждение, поскольку управляющие доступностью памяти через окно AWE параметры глобальной конфигурации (выводимые при вызове sp_configure) существуют, но не используются в 64-битной редакции SQL Server. Вместо этого, при использовании установок интерфейса AWE будет предоставлено только разрешение на закрепление страниц в памяти. Разрешение уровня операционной системы: "Lock Pages In Memory" необходимо SQL Server для выполнения распределений через AWE.
Закрепление страниц в памяти может положительно сказаться на обслуживании ввода-вывода, и может снизить затраты на регулировку рабочего множества SQL Server.

Предупреждение: не используйте AWE или закрепление страниц без предварительного тестирования. Принудительное задействование физической памяти может привести к нежелательным эффектам вытеснения физической памяти для системы в целом. Система или компоненты аппаратного обеспечения в условиях вытеснения физической памяти работать хорошо не будут. Используйте эти возможности с осторожностью.

Для эффективного исполнения операций ввода-вывода, используемая для этого память не должна сталкиваться с отсутствием страниц в физической памяти (page faults). Т.о., если память не закреплена, обращение к отсутствующим в физической памяти страницам становиться возможным. Поскольку большинство приложений память для ввода-вывода не закрепляет, операционная система сама переводит память в закреплённое состояние. Когда ввод-вывод закончен, память переводится назад, в не закреплённое состояние. 64-битный SQL Server 2005 Enterprise Edition определяет наличие разрешения на закрепление страниц в памяти, и устанавливает закрепление страниц кэша данных. 32-битный SQL Server требует что бы был установлен параметр глобальной конфигурации, включающий поддержку доступа к памяти через механизмы AWE, после чего становиться возможным закрепление страниц памяти. Это позволяет во время исполнения запросов ввода-вывода избегать переходов между закреплённым и не закреплённым состоянием страниц памяти, что повышает эффективность операций ввода-вывода. Чтобы отключить такое закрепление, достаточно удалить разрешение на уровне системы на эту операцию, либо включить флаг трассировки -T835 для 64-битной редакции сервера баз данных.

Важно: SQL Server старается сократить число листаний, отдавая память обратно операционной системе тогда, когда он может это сделать. Однако, в некоторых условиях сделать это бывает сложно. Когда страницы закреплены, они не могут быть подвержены листанию. Мы рекомендуем использовать закрепление страницы с осторожностью.

SQL Server не всегда может избежать операции листания. Закрепление страниц может использоваться для того, чтобы избежать листаний, в качестве методики поиска проблем, если Вы имеете причину полагать, что повреждение памяти, возможно, произошло во время операции листания.

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

[В начало]

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

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

2 мая 2007 г. стал доступен русский перевод февральского BOL
Александр Гладченко
Ближе к вечеру 2 мая стало известно, что на сайте загрузки Майкрософт появилась замена апрельской версии 2006г. электронной документации по SQL Server 2005.

Худшие методы (MS SQL Server) - использование неуточненных имен
Christoffer Hedgate
Когда Энди недавно добавил одну часть в ряду Худших Методов - о непродуманном добавлении столбца, это заставило меня вспомнить о худшей практике, с которой я пытаюсь сражаться в течение долгого времени. Возможно, она не столь специфична, как большинство других худших методов, но причина одного из худших методов, с которыми я часто сталкиваюсь, - это заурядная лень. Одной из ошибок, которую люди часто допускают только потому, что они ленивы, является то, что имена объектов не уточняются именем владельца. Я собираюсь обсудить это здесь, а в последующей статье я хочу обсудить некоторые другие ошибки, причиной которых является лень.

Десять непреложных законов безопасности
Microsoft
В центре обеспечения безопасности корпорации Майкрософт ежегодно анализируются тысячи отчетов о нарушении безопасности. Иногда оказывается, что в отчете действительно описывается уязвимость системы безопасности, возникшая как следствие изъяна в одном из продуктов корпорации Майкрософт. В этих случаях специалисты корпорации Майкрософт как можно скорее разрабатывают исправление, устраняющее эту ошибку (см. раздел A Tour of the Microsoft Security Response Center ["Общие сведения о центре обеспечения безопасности корпорации Майкрософт"]). Бывает также, что описываемая проблема является следствием ошибки при использовании продукта. Однако многие отчеты не попадают ни в одну из этих категорий - хотя в них описываются настоящие проблемы с системой безопасности, однако эти проблемы не являются следствием изъянов в продуктах. За годы работы сотрудники центра создали список подобных проблем, назвав его "Десять непреложных законов безопасности".

Microsoft Visual Studio Team Edition for Database Professionals Community Technology Preview for Service Release 1
Александр Гладченко
Стал доступен для скачивания предварительный выпуск сервисного релиза для Team Edition for Database Professionals. Вы можете загрузить файлы SR1 CTP по этим ссылкам

SQL Server code name "Katmai"
Александр Гладченко
9 мая 2007 г. в Сиэтле на первой конференции Microsoft посвящённой Business Intelligence, была представлена следующая версия флагманской СУБД и платформы анализа данных Microsoft SQL Server ™ под кодовым названием "Katmai", выпуск которой намечен на 2008 год

Объекты управления SQL Server
John Papa
Разработчикам баз данных необходимо не только запрашивать данные и манипулировать ими, но и на регулярной основе выполнять административные задачи. Объекты управления SQL Server™ (SMO) предлагают разработчикам надежный набор средств для таких операций, как резервное копирование и восстановление баз данных и выдачи команд языка определения данных (ЯОД). Используя SMO, вы можете также подключиться к SQL Server, перебрать коллекцию объектов базы данных и выполнить над ними различные операции.

[В начало]

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

Logon Triggers in SQL Server 2005 SP2
Decipherinfosys
Logon triggers have existed in Oracle for a very long time. We had covered one of the possible applications of such a trigger in a previous blog post. In SP2, SQL Server now has the logon trigger which can be used to enforce security and do easy audit trails for the logins occurring in the application. These triggers fire after the authentication phase is completed but prior to the user session being established. Let's do a test run to see this functionality:

NOT FOR REPLICATION Database Unit Tests
James.Rowland-Jones
I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option. I thought it might be helpful to put up a post with tests for all the other object types that can have this option set.

SQL Server Service Accounts - Best Practices and Deployment Considerations
James.Rowland-Jones
We have recently had an internal discussion on service accounts predominantly on the subject of whether it is better to have one service account for sql server that is used in all environments or whether separate accounts should be used in each environment. Perhaps surprisingly everyone came down on the same side (how often does that happen???) and we all seemed to agree on every point. I thought I'd share this with you.

SQL Server 2005: Using EXCEPT and INTERSECT to compare tables
Jeff Smith
Previously, I had written that UNION ALL (combined with a GROUP BY) is a really quick and easy way to compare two tables. You don't need to worry about NULLS, the code is fairly short and easy to follow, and you can view exceptions from both tables at the same time.

Query Plans and Read Committed Isolation Level
Craig Freedman
Last week I looked at how concurrent updates may cause a scan running at read committed isolation level to return the same row multiple times or to miss a row entirely. This week I'm going to take a look at how concurrent updates may affect slightly more complex query plans.

Recycling Conversations
Remus Rusanu
In my previous post http://blogs.msdn.com/remusrusanu/archive/2007/04/24/reusing-conversations.aspx I promised I'll follow up with a solution to the question about how to end the conversations that are reused for the data-push scenario (logging, auditing, ETL for DW etc).

Using PowerShell to browse SMO objects
Allen White
I'm trying to solve a problem with one of my applications, and need to browse the SMO objects for a particular database. In the past I'd have fired up VB.Net and gone into the debugger and poked around that way. Not so any more with PowerShell! I open up a PowerShell session and enter these commands to establish the environment, connect to the server, and grab the database object:

Query XML data from a table with XML data type
Muthusamy Anantha Kumar
The objective of this article is to guide Microsoft SQL Server Database Administrators on how to:

System Monitor (Perfmon) shows numbers instead of counter names
Rob Farley
I came across this the other day. It was during a course I was teaching, so the timing couldn't have been worse. I don't have a screenshot, because I just wanted to get it sorted and didn't think "Ooh, I'll grab that to make my blog post better". But essentially, in the "Add Counters" dialog box of Performance Monitor / System Monitor, all the drop-down lists were full of numbers, no names. There's a way to unload the counter details for groups of counters and load them back in again, using "unlodctr.exe " and "lodctr.exe " (or something like that). But this doesn't work in this particular situation, where all the counter names are lost. The answer is: "lodctr.exe /r". The /r tells it to rebuild the sections of the registry that store this information, based on the list of what should be there (in the registry) and the backup set of .ini files. It takes a minute or so, and it doesn't give you lots of useful information - but if you're having this problem, try this and you'll hopefully see the success that I had!

Dynamic Connection Strings in Reporting Services 2005
Bilal Khawaja
Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.

Returning a week number for any given date and starting fiscal month
Paul Alcon
This article was written by Paul Alcon. Paul writes "Sql Server comes with a host of built in functions such as ISNULL, CONVERT and CAST. Now if that wasn't enough rope to hang ourselves with, as of Sql Server 2000 we gained the ability to create our own user defined functions. In this article I will be looking at the three main date functions DATEADD, DATEPART and DATEDIFF (there is a fourth called DATENAME but I want to get to the end of this article before you fall asleep so I decided to leave it for another date and time! And no it doesn't foretell the name of your future blind date so it's not as interesting as it sounds anyway) Then I will be combining all three in a user defined function of our own by which time our necks will be well and truly stretched!"

Research & Markets: Analyze the Improved Security Features of Microsoft SQL Server 2005
Laura Wood
DUBLIN, Ireland--(BUSINESS WIRE)--Research and Markets (http://www.researchandmarkets.com/reports/c55606) has announced the addition of "Microsoft SQL Server 2000 and 2005 Analysis Services" to their offering.

Two new SQL 2005 Full Text Search KB articles...
John Kane
Two new SQL Server 2005 (Community Technical Preview or CTP) Full-text Search KnowledgeBase (KB) articles have been published this month:

Microsoft Full-Text Search Technologies
Microsoft
This white paper introduces the basic concept of full-text search and explains how different Microsoft® products implement full-text search. This information can help you to determine which Microsoft products are best for your information retrieval needs.

Introducing Microsoft Full-Text Search Technologies
Microsoft
This chapter reviews the concept of full-text search and explains how different Microsoft® products implement full-text search. This information can help you to determine which Microsoft products are best for your information retrieval needs.

Full Text Search Adobe PDF files stored in SQL Server...
John Kane
I've often been asked how to Full-text Index (FTI) Adobe PDF files stored in SQL Server 2000 and then use CONTAINS or FREETEXT to Full-text Search (FTS) the contents of binary files... Below is a TSQL script that I've often posted in the public fulltext newsgroup:

SSIS: Checking for IsNumeric()
Jamie Thomson
Many ex-DTS users are miffed that the SSIS expression language does not have an equivalent of the VB Script IsNumeric() function that is used so extensively in DTS and to be honest, its a fair shout.

Encrypted SQL Server SSIS Configurations
Larry Charlton
There are several aspects of securing SSIS configurations in a SQL Server. The SQL permissions to the configurations themselves, the bytes stored on disk and in backups, the network packets between client and server, and so on. This will deal with encrypting the bytes on disk transparently for SSIS packages.

In CASE you didn't know ....
Jeff Smith
A Google search for the phrase sql "case statement" returns 127,000 results. Meanwhile, if we do a search for the phrase sql "case expression" we get back only 43,900 results. What does this mean? Most people don't understand what SQL's CASE feature really is, how to use it, or how it works!

Using 64 bit SQL Server 2005? Lock Pages in memory!
Tony Rogerson
Watch yourself on this one, my client has an 8GB machine, two SQL instances (standard edition), one uses 6GB (production) and one uses 512MB of memory (development), the server is dedicated so there is a reasonable amount of available memory.

SQL2005 SP2 Regression :- Cannot manage a server using Management Studio where server name > 30 characters
Tony Rogerson
So, anybody use SQL Instances? Anybody got a server name > 30 characters? Well, you are stuck on SP1 until a hotfix is produced to fix this regression in Management Studio. If you find this important, the fact that they've hard coded (picked out the blue no doubt) 30 characters for a server name instead of using sysname then show your disgust and disapprovement at my connect entry...

Factoring Log Shipped databases into the automated backup programs
Allen White
I had two articles published in April on the Simple-Talk web site (Automate your Database Maintenance using SMO and Alert-based Transaction Log Backups - Automate your database Maintenance Part 2), and after they were published a need popped up here requiring me to set up log shipping for a couple of my production databases. Well, my automated transaction log backups would prevent the successful updates via transaction log backups in the log shipping databases, so I added the following code in both programs, within the loop through the databases:

Debugging SSIS packages
Eric Johnson
New to SQL Server 2005, SQL Server Integration Services (SSIS) adds an enterprise-level extract, transform and load (ETL) tool to the ever-growing suite of SQL Server tools. SSIS replaces DTS, which was only around for two releases of SQL Server and grabbed limited following. Besides being slow and a little tricky to work with, DTS didn't offer any easy ways of debugging packages when you had problems. In the latest SQL Server release, a whole host of methods exist for debugging SSIS packages and for helping you find the root cause of your problems.

SQL Server Security: Server Roles
Brian Kelley
As yo probably know, Brian covers security topics for us and does a great job. This week he looks at the fixed roles and points out a few things you may not have thought about.

Performance Impact of Using NTFS Compression with Read-Only Databases
Linchi Shea
SQL Server 2005 supports placing read-only filegroups or read-only databases on NTFS compression. In other words, you can compress the database files in a read-only filegroup or a read-only database. This can be a very useful feature if saving disk storage is of high priority.

Implementing Application Failover with Database Mirroring
Writers: Michael Thomassy, Sanjay Mishra
Database mirroring allows a database to fail over from one server to another. For a seamless user experience, it is important that the application automatically reconnect to the current principal server. This paper describes how to enable your application to automatically fail over when database mirroring failover occurs. The providers for client redirect covered in this paper are Microsoft SQL Native Client, ADO.NET, and Microsoft JDBC Driver.

Analysis Services 2005 Delivers New Features -- Start to Finish
Baya Pavliashvili
MSAS 2005 introduces Unified Dimensional Model (UDM) - a concept that attempts to use MSAS for reporting as well as analytics. Traditional analytics lack flexibility but they provide faster response time than traditional reports. Traditional reports are flexible, but usually take a long time to generate. Let me elaborate on this idea and show you how it applies to different versions of Analysis Services.

Choosing client for SSAS 2005: Excel 2003 or Excel 2007
Ramunas Balukonis
After we migrated Analysis Services from 2000 to 2005 we discovered that the same (or analogous) queries against SSAS 2005 runs even slower than AS 2000. Our users used MS Excel 2003 as front end on AS 2005. After some time I installed MS Excel 2007. Then I tried to do the same Pivot Table actions on both Excel versions (2003 and 2007): make Pivot Table from Advenure Works database placing days of [Date].[Calendar] [July 2003] and [August 2003] on rows, [Mountain-200 Silver, 38] and [Mountain-200 Silver, 42] from product [Product].[categories] on columns and [Sales Amount] as facts

Describing the cube
Ramunas Balukonis
One of the features I missed in OLAP clients are objects descriptions (measures, calculated member, dimensions and so on). Only SSAS administrator could see objects descriptions. But description information for end users are also needed, even critical. I would like to see description information on OLAP objects tooltip, as example.

2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
Anthony T. Mann
Business Intelligence (BI) just became a lot easier! The release of the 2007 Microsoft® Office system, used in conjunction with Microsoft® SQL Server 2005, delivers numerous benefits in terms of Return on Investment (ROI) for a company, design and implementation for its Information Technology (IT) department, and ease of use for end-users.

SQL Server 2005 Row Versioning-Based Transaction Isolation
Kimberly L. Tripp, Neal Graves
Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications. (59 printed pages)

Temporary Tables - MS SQL Server
Decipherinfosys
Yesterday, we had covered the basics of temporary tables in Oracle. Today, we will cover the basic features of temp tables in MS SQL Server. Unlike Oracle, MS SQL Server has local and global temporary tables. Usage of temporary tables in MS SQL Server is more developer friendly and they are widely used in development. Local temporary tables are visible only in current session while global temporary tables are visible across all sessions.

WSS 3.0 and SQL Server Embedded Edition
Decipherinfosys
If you have installed WSS 3.0 in a standalone configuration, the install also sets up an instance for SQL Server Embedded Edition. This is the instance where it creates it's content management and search databases. However, when you un-install WSS 3.0 from the system, it does not automatically remove this instance. Here is how you can remove that instance manually:

Microsoft vs. Teradata
Mark Whitehorn
Column Microsoft and Teradata are both significant players in the BI market but they have wildly different approaches to the challenges of extracting information from data. The reason lies in the fact that the two companies elected to solve two very different, but equally intractable, computational problems in order to get their BI systems to perform well.

Checking for Overlapping Rows in a Slowly Changing Dimension
John Welch
A question was posted on the MSDN forums about validating that there are no overlapping rows in a slowly changing dimension (SCD). It is common to use a start and end date in a type 2 SCD to designate when each version of the dimension member was in effect. However, it can create problems if the date ranges for one version of the row overlap with other versions of the row.

Handling Multiple Errors in SSIS
John Welch
One actual failure in SSIS can trigger a whole series of error messages. For example, failure to convert a column value from a string to an integer in a Derived Column transform generates the following messages:

Handling Flat Files with Varying Numbers of Columns
John Welch
A common question on the forums has been how to handle flat files that have a varying number of columns. For example, one row contains 3 columns, and another row may contain on two columns. The example below shows a sample file that uses a comma to delimit the columns, and a cursor return / line feed to delimit the row.

How do you set "(Select All)" as the default for multi-value parameters in Reporting Services?
Russell Christopher
The short answer is that you can't, although there is a workaround. Essentially, "(Select All)" as implemented in Reporting Services simply does this:

Using SQL 2005 with Expression Web
Don Schlichting
This article will explore various methods of accessing SQL Server from inside Microsoft Expression Web. Microsoft Expression Web is a graphical development tool for creating web pages and is part of the new Expression Studio. The Studio itself consists of four components, Expression Web, Expression Design, Expression Blend, and Expression Media. Expression Media is an asset management tool, complete with version checks. Expression Design is a graphical design and illustration tool. Expression Blend allows various art and design elements to be mixed into a unified user interface. Lastly, Expression Web, the focus of this article, creates web pages. The web pages can be simple or use advanced Expression Web features such as CSS, XML, XPath expressions, and will conform to the XHTML 1.0 Transitional standard. The following URL gives an overview of Microsoft Expression Studio; www.microsoft.com/expression/expression-studio/overview.aspx .

Logical Functions: IsGeneration(): Conditional Logic within Calculations
William Pearson
It should come as no surprise, to anyone who works with MDX on a regular basis, that, in working with multidimensional data, it is not uncommon to find ourselves confronted with business needs to have some calculated members give different results, depending upon "where in the cube" they are being evaluated. It is in these scenarios where we find great utility in leveraging the combination of conditional logic and the properties of sets, tuples, hierarchies, levels and / or members to determine the "evaluation location" of the member(s) of interest. Based upon the location that is ascertained, we can render the formula required to give the result we need for the given "position."

SQL SERVER - UDF - Function to Convert List to Table
Pinal Dave
Following Users Defined Functions will convert list to table. It also supports user defined delimiter. Following UDF is written for SQL SERVER 2005. It will also work well with very big TEXT field. If you want to use this on SQL SERVER 2000 replace VARCHAR(MAX) with VARCHAR(8000) or any other varchar limit. It will work with INT as well as VARCHAR.

Top 10 Hidden Gems in SQL Server 2005
Cihan Biyikoglu
SQL Server 2005 has hundreds of new and improved components. Some of these improvements get a lot of the spotlight. However there is another set that are the hidden gems that help us improve performance, availability or greatly simplify some challenging scenarios. This paper lists the top 10 such features in SQL Server 2005 that we have discovered through the implementation with some of our top customers and partners.

How SQL Server Chooses the Type of Join
Mike Dillon
How many times have you had a stored procedure run quicker in Query Analyzer than it does in the application? Mike Dillon tracked down one possible cause in this article.

Metadata about computed columns
Louis Davidson
To page 257 of my Pro SQL Server 2005 Database Design and Optimization, I want to add the following example about getting the metadata about computed columns.

Using application locks to implement a critical section in T-SQL code
Louis Davidson
This is being added to the addendum (located here) for my "Pro SQL Server 2005 Database Design and Optimization" book and would have appeared in the pessimistic locking section on page 478 in Chapter 9: Coding for Integrity and Concurrency; Pessimistic Locking. You can download the entire addendum here: Addendum.

Query XML data from a table with XML data type
Muthusamy Anantha Kumar
The objective of this article is to guide Microsoft SQL Server Database Administrators on how to:

Enforce Business Rules for All Your Data with Constraints
Alexander Kuznetsov
The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.

Chunks: the hidden key to RAID performance
Robin Harris
George Ou, Technical Director at ZDNet and a fellow ZDnet blogger, has a great post about real life RAID performance - hardware vs software - plus some helpful comments about data layout, especially for MS SQL Server. As George notes, data layout can have a major impact on storage performance. But what about RAID itself? What is the theory behind RAID performance?

Non-standard RAID levels primer: RAID 1E
Scott Lowe
Scott Lowe introduces a RAID level that's a little off the beaten path. Learn more about RAID 1E and how it differs from the more common RAID levels.

Two approaches to recording shift work in SQL Server
Arthur Fuller
If you want to list employees' time sheet records in SQL Server by the shift, you should assume that an employee could begin work at any time between the start and stop times of the shift. Learn two ways to preserve the correct groupings in your list.

Defining SQL Server constraints with TSQL
Tim Chapman
Take your database administration skills to the next level by learning how to define constraints with TSQL. This advanced skill shows that you don't always rely on graphical interfaces when designing database objects.

Proper Case
Joe Celko
SQL Apprentice Question: I have a ProperCase function that works well. However, I'm constantly adding "exceptions" into the funciton. For example, I want IPA uppercase, but not when it's in constIPAtion. This got me to thinking that it might be easier to add all my cases into a table, rather than constantly editing my function. But it's not working quite the way I'd expect it to. So rather than reinvent the wheel, I thought I'd come here and see if anyone has taken a table approach to ProperCase. If so, can you please share how you did this?

Naming Conventions
Joe Celko
SQL Apprentice Question: I'm coming from a MS Access background and so I'm very used to and comfortable with the hungarian (Leszynski et al) naming conventions. However, I'm getting started into my first SQL Server Database and really want to use the appropriate up to date standard naming convention (ISO compliant).

Stored Procedures---Stacking Ifs
Joe Celko
SQL Apprentice Question: What is the proper syntax for stacking these IFs in a Stored Procedure???

SQL Server "Katmai" to Deliver Entity Data Platform and Support LINQ
Roger Jennings
Microsoft's announcement this morning that 2008 is the target release date for SQL Server "Katmai" (presumably SQL Server 2008) might explain why the ADO.NET team dropped the Entity Framework (EF) from Visual Studio "Orcas" and postponed EF's target release date to the "first half of 2008."

Avoid defining Default Member
Ramunas Balukonis
Default Members are good thing in BI environment. You can define Default member as "Last month" in Date dimension, "Active" in status dimension and so on. But be careful defining default members: Analysis Services returns incorrect results with default member in some circumstances. To reproduce buggy behaviour, open Adveture Works, define default member as [Road Bikes] subcategory in [Product].[Product Categories] hierarchy. First, set Category attribute default member to "[Product].[Category].&[1]" or [Product].[Category].[Bikes], and then set "subcategory" default member to "[Product].[Subcategory].[Subcategory].&[2]" or [Product].[Subcategory].[Subcategory].[Road Bikes].

Finding the last executed SQL statement for a given SPID
Decipherinfosys
There are times when you would need to find out the last SQL statement that was sent from a client to a SQL Server instance. There are a couple of ways of getting that information and we will list the different options in this blog along with the mention of the versions when those options became available. For this blog post, let's open up two different sessions in Query Analyzer (SQL 2000 users) or Management Studio connecting to a SQL 2005 instance. In the first session, fire off this SQL:

Microsoft SQL Server "Katmai" Builds on Proven Success of SQL Server 2005, Empowering Customers to Manage the Data Explosion
Microsoft
Vision for next release of SQL Server announced at Microsoft's first Business Intelligence Conference.

How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically
Microsoft
This article describes how to use Microsoft Windows Management Instrumentation (WMI) in Microsoft SQL Server 2005 to change either of the following items:

SYSK 345: How To Assure Correct LastUpdatedDateTime Value in Your SQL Tables
Irena Kennedy
Often, developers add LastUpdatedDataTime (or LastUpdatedTimestamp) and LastUpdatedByUser columns to tables in relational databases.

Hamming Distance Algorithm in SQL
Jeff Smith
Here's a simple User-Defined Function implementation of the Hamming Distance Algorithm for SQL Server:

Repeatable Read Isolation Level
Craig Freedman
In my last two posts, I showed how queries running at read committed isolation level may generate unexpected results in the presence of concurrent updates. Many but not all of these results can be avoided by running at repeatable read isolation level. In this post, I'll explore how concurrent updates may affect queries running at repeatable read.

SQL Server 2008
David Portas
Microsoft have officially announced their intention to have Katmai available in 2008. (The title of this post is nothing more than idle speculation. Katmai doesn't have an official name yet.)

Index Build strategy in SQL Server - Part 4-1: Offline Serial/Parallel Partitioning (Non-aligned partitioned index build)
Queryproc
Recall that in the previous posts on index build, we defined "aligned" as the case when base object and in-build index use the same partition schema, and "non-aligned" to be the case when heap and index use different partition schemes, or the case when heap is not partitioned. In this post, we will talk about the two scenarios of non-aligned partitioned index build, source partitioned and source not partitioned.

Avoiding False Conflicts Resulting From Interrupted Sync
Rafik Robeal
A great thread on the sync services forum yesterday brought up this interesting question on what happens if the sync session is interrupted due to connection failure or client application crash …etc. To visualize the scenario in your mind, picture an n-tier sync app which uses a web service to upload changes to the server. At sync time, the web method was called to upload changes to the server; the server applies the changes but prior to returning to the client the connection was dropped. In this case, the client has not received the acknowledgement from the server and thus didn't save the new sent anchor. In the next sync, the client will attempt to upload the changes that it sent last time along with any new changes to the server. Now, the question is how can you, the developer, deal with duplicate application of same rowa and what can the DbServerSyncProvider do to help you out?

Microsoft President Jeff Raikes Declares, "It's a New Day for Business Intelligence"
Microsoft
Raikes announces product momentum, strategic alliances and acquisition at first-ever BI Conference in Seattle.

Dynamic SQL and digital signatures in SQL Server 2005
Raul Garcia
As I already mentioned, dynamic SQL is a quite powerful, but also quite dangerous. In SQL Server 2005 we introduced a new feature that is also quite powerful and when used properly can be quite useful; but it is important to learn and understand any such feature in order to use it properly. In this small article I will describe a little bit more about the interaction between these two features.

SQL SERVER Index Optimization CheckList
Pinal Dave
Index optimization is always interesting subject to me. Every time I receive request to help optimize query or query on any specific table. I always ask Jr.DBA to go over following list first before I take a look at it. Most of the time the Query Speed is optimized just following basic rules mentioned below. Once following checklist applied interesting optimization part begins which only experiment and experience can resolve.

Author Visit - MIS2007 Part II - Database Raid Discussion
Pinal Dave
MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting.

Granting permissions in SQL Server 2005
Adam Machanic
Imagine for a moment that you're a SQL Server 2000 production DBA (unless, of course, you are). You arrive at the office one morning, get a hot drink and check your e-mail. There are two new co-worker requests in your inbox: Bob in purchasing needs read-only access to all of the sales data so he can run reports to predict upcoming material acquisition volumes; John in Web development has a problem with a production Web application and needs access in order to run a Profiler trace to identify the problem. These seem like easy requests to fulfill -- or are they?

CTE Performance
Peter He
SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform.

Advanced XML Processing
Jacob Sebastian
Continuing on with his series on XML, Jacob Sebastian looks at some more advanced XML techniques in SQL Server 2005.

Use SqlBulkCopy to Quickly Load Data from your Client to SQL Server
Jeff Smith
The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.

Starting SQL Server in Minimal Configuration
Jay Dave
Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.

Business Strategist and Best-Selling Author, Double-Digit Growth
Michael Treacy
Your organization can achieve it, even if others can't. Michael Treacy demonstrates, through fresh and compelling case examples, that the foundation of steady double-digit growth is a discipline that can be developed by any management team. With a structured growth discipline, firms are more likely to achieve high growth by "grinding it out" than they are by "betting the farm" on risky strategies. Based on his book of the same title, Michael Treacy presents four key insights about the management discipline of double-digit growth firms:

Why Does OBJECTPROPERTY Have A TableIsFake Property?
Denis
You can run the following function (OBJECTPROPERTY(object_id, N'TableIsFake') ) on an object and it will return 1 if the table is fake and 0 otherwise. What does BOL say? The table is not real. It is materialized internally on demand by SQL Server. So does this mean it is a table valued function?

Q&A: Next version of SQL Server will boost scalability, development features
Ted Kummert
May 09, 2007 (Computerworld) -- SEATTLE -- At its first Microsoft Business Intelligence Conference here today, Microsoft Corp.-- which had been holding details about the next version of SQL Server close to the vest - announced the target ship date and new details for the follow-on to SQL Server 2005. Code-named "Katmai," the next release will include support for unstructured data and will boost scalability and administration, saidTed Kummert, Microsoft's corporate vice president of the Data and Storage Platform Division. Kummert spoke to Computerworld today about the next version of SQL Server, which will focus on enterprise scalability, developer productivity and providing users with pervasive insight about data.

Goldilocks and the Four Schemas
Brian Moran
Once upon a time, there was a DBA named Goldilocks. While walking through the forest one day, she stumbled upon a developer's cubicle. There was no door (everyone knows that cubicles don't have doors, even in fairytales) so she walked in without knocking. Pinned to the developer's corkboard were four database schemas. Goldilocks had a presentation to give the next day and wanted a sample database to run some queries against. She reviewed the first schema, called Pubs. "This schema is too simple!" Goldilocks exclaimed. The next schema was called Northwind. Goldilocks thought in addition to being too simple, that schema was chock-full of design problems. The third schema was called AdventureWorks. "Hmm, this schema is much better," Goldilocks thought at first glance. But after reviewing AdventureWorks in more detail, she threw up her hands in despair and said, "This schema is too big and complicated. I can't remember all the silly table names and relationships between the tables. How will I ever use it for demos?"

MICROSOFT GIVES PEEK AT NEXT VERSION OF SQL SERVER
J. Nicholas Hoover
The company shows off Katmai, the next version of its data platform, at its first business intelligence conference. Microsoft is giving a sneak peek at the next version of its SQL Server data platform, code-named Katmai, as the company's first-ever business intelligence conference kicks off today.

Simple update question
Joe Celko
SQL Apprentice Question: I have a simple update query in Sql 2k and want to update only one field instead of all 3 fields

'Katmai' SQL Server To Go 'Beyond Relational'
Barbara Darrow
The next SQL Server database, code-named Katmai, will extend its reach beyond structured and semi-structured to unstructured data and will make its debut next year, a Microsoft executive said Wednesday.

[В начало]

ФОРУМ SQL.RU

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

Помогите оптимизировать запрос.
SQL 2005. Инсрументы разработчика - крик души.
и снова deadlock :-(
"Баковское" округление на T-SQL (как Math.Round в .NET)
MSSQL XML Internet
прикаскадном удалении не исполняется триггер
24 000 000 записей
Строковое преобразование
ХП для вычисления
Кодировка
Хранимка и значение автоинкремента
В ХП не могу создать таблицу
Call stack для процедуры
Репликация слиянием с фильтром
Хранимые процедуры на C#
Поймал сейчас офгенный глюк
Запрос по диапазону значений
Как лучше всего хранить месяц-год
Две репликации на одну базу
Какой RAID лучше поставить сервер (SQL2005)

[В начало]

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

Определение существования TAPE устройста
Перенос проекта
Линкование OpenOffice.org Base
Опрос: Usage xs:date & xs:dateTime and negative dates in SQL Server XML Schema Collections
DMO-SQL function ExecuteWithResultsAndMessages2 Not returns values!!

[В начало]

#356<<  #357  >>#358
Rambler's Top100 Рейтинг@Mail.ru  Administrator: Обратная связь 
Copyright: SQL.Ru 2000-2013