Answers from Microsoft

Advanced Search

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

ADS BY GOOGLE

FEATURED LINKS

WinConnections Conference Fall 2008
Don’t miss the premier event for Microsoft IT Professionals in Las Vegas, November 10-13. Register and book your room by August 25 and receive a FREE room night (based on a three night minimum stay).

Maximize your SharePoint Investment – 8 Cities
Discover best practices and tips for both architecting and administering SharePoint. Early Bird Price of $99 through Sept 15th.

Find a new job now on the all new IT Job Hound!
Search jobs, post your resume, and set up job e-mail alerts!

Master SharePoint with 3 eLearning Seminars
Learn how to build a better SharePoint infrastructure and enable powerful collaboration with MVPs Dan Holme and Michael Noel. Register today!

Top Tools for Virtualization Disaster Recovery & Replication
View this web seminar on August 14th to learn about two tools that will result in faster backup and restore with P2V disaster recovery.

SharePointConnections Conference Fall 2008
Don’t miss the premier event for Microsoft IT Professionals in Las Vegas, November 10-13. Register and book your room by August 25 and receive a FREE room night (based on a three night minimum stay).

VMworld 2008 - Sign Up Today!
Join your peers on September 15-18 at The Venetian Hotel in Las Vegas as VMware hosts VMworld 2008, the leading Virtualization event.

When managing just VMware isn’t enough
Plan/Manage/Secure – NetIQ VMware management. Download whitepaper.

What’s up with your network? Find out with ipMonitor
Availability monitoring for servers, applications and networks – FREE trial

Microsoft® Tech•Ed EMEA 2008 IT Professionals
Advance your thinking with new ideas and practical real-world solutions at Microsoft’s FIVE day technical infrastructure conference 3-7 Nov., 2008. Register before 26 September 2008 to save €300.

Order Your Fundamentals CD Today!
Gain an introduction to Exchange, learn server security requirements, and understand how unified communications can play a role in your messaging strategies with this free Exchange CD.

Are You Really Compliant with Software Regulations?
View this web seminar that will help you with compliance best practices and check out a management solution to assure that you won’t be in jeopardy of an audit.

Virtualization Congress Oct. 14-16 in London
Don't miss Virtualization Congress, the premiere EMEA conference dedicated to hardware, OS and application virtualization. Oct. 14-16 in London.

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technical Resources Directory

Connected Home

Windows Excavator

Windows SuperSite