Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


Answers from Microsoft
98 results found for Answers from Microsoft, displaying items 1 - 20
 
[August 2003]  
Using a Stored Procedure in a CASE Expression
You can't execute a stored procedure from a CASE expression, but you can use CASE to return a character string that you can use in the execution of the stored procedure.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[August 2003]  
Deleting Multiple Records
Learn how to delete multiple records from a table by using a view as the filter.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[June 2003]  
Full-Text Search Basics
Microsoft provides answers about the capabilities of SQL Server 2000's full-text search component.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[June 2003]  
Tracking Index Usage
Use SQL Server Profiler to determine which indexes you need to keep on your tables.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[June 2003]  
Generating Scripts for SQL Server Jobs
SQL-DMO gives you a way to list jobs running on SQL Server and obtain their scripts.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[May 2003]  
Analyzing a Query from the Inside Out
Microsoft's SQL Server development team takes a close look at a query that works from the inside out to return information from tables that are related only indirectly.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[May 2003]  
Working Around a Varchar Truncation
How can I keep SQL Server 7.0 from truncating varchar data?
SQL Server Magazine  — Microsoft's SQL Server Development Team

[May 2003]  
Error Investigation Reveals Ghostly Objects
When you delete rows, pages, or extents, SQL Server can mark those objects as "ghosts" and clean them up later. Here's how one DBA unearthed these ghostly objects while investigating a mysterious error code.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[April 2003]  
Moving SQL Server 7.0 Databases to SQL Server 2000
SQL Server doesn't rename directories as part of the upgrade process. Here's a renaming problem you might face when upgrading and how to handle it.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[April 2003]  
Replicating Data in a Franchise Company
Here's a replication tip for ensuring the data that your franchises transfer to your head office is synchronized and includes modifications from each branch.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[April 2003]  
Choosing the Right Defragmentation Method
Do you need to defragment your database but still maintain high availability? Microsoft offers several options for defragmenting tables in SQL Server 2000.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[March 2003]  
Importing Word Documents into SQL Server
Microsoft's SQL Server development team explains how to import Word documents into SQL Server, then index them.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[March 2003]  
Deleting Spaces in a SQL Server 6.5 Char Column
A sample script shows how to remove extraneous spaces from a char column.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[February 2003]  
Automating Defragmentation
Manually checking and defragmenting your database's tables can be a laborious process. Here's how you can eliminate fragmentation from the start and how to automate defragmentation when you need it.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[February 2003]  
Adding Columns to Replicated Tables
How can you add a column to a replicated table without reinitializing the entire publication? The SQL Server Development Team has an answer.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[February 2003]  
Dividing an Update into Batches
Here's how to use the ROWCOUNT setting to divide a long update into batches and maintain good performance.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[January 2003]  
Determining a Stored Procedure's Execution Status
Wrapping your stored procedure call with state-change logic will let you determine the execution status of the procedure.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[January 2003]  
Initializing a Database When Installing Replication
Generate scripts to recreate stored procedures and triggers every time you set up replication.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[January 2003]  
Importing an XML File
Microsoft's SQL Server development team shares 3 approaches for importing an XML file into SQL Server 2000.
SQL Server Magazine  — Microsoft's SQL Server Development Team

[December 2002]  
Covered Query vs. Covering Index
What constitutes a covered query? What’s the definition of a covering index? And when do you use one, or the other, or both? Microsoft’s SQL Server development team sheds light on one reader’s question.
SQL Server Magazine  — Microsoft's SQL Server Development Team





     [1]  2  3  4  5   next page 


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

Latest Advancements in SSL Technology
There are a variety of different kinds of SSL to explore to ensure customer data is kept confidential and secure. In this paper, we will discuss some of these SSL advances to help you decide which would be best for your organization.

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Solving PST Management Problems
In this white paper, read about the top PST issues and how to administer local/network PST Files.

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Maximize Your SharePoint Investment: Get Your Data Moving
Watch this web seminar now to learn how to maximize your SharePoint investment! Join us as we take a look at the complex business of securing, accessing and managing vast amounts of information in a global network and various ways to get your data moving.

List Your Products in Our Technology Resource Directory
Don't miss the chance to post your free listing in this comprehensive directory for IT and developer professionals, powered by Windows IT Pro. But hurry! Deadline ends Oct. 9.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing