SQL Server Savvy
|
46 results found for SQL Server Savvy, displaying items 1 - 20
|
Questions, Answers, and Tips About SQL Server
Stabilize nullability, monitor tables to find script triggers, make SQL Server and Oracle data compatible, implement custom application-locking schemes, and create indexes that use functions or expressions.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Investigate how to install multiple instances of SQL Server, use the TOP statement with a local variable, use UDFs in SQL Server 2000, store extended properties, and more.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about the paging file's importance, SQL Server 7.0 evaluation version's hazards, build numbers, DBCC DBREINDEX and fragmentation, mysterious indexes, permissions problems, and performance tuning.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Karen and Brian explore topics including DTS gotchas, the DTS ScriptPkg utility, FoxPro and SQlL server UDF support, and OLAP Services FoodMart data.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Simultaneously manage SQL Server 6.5 and SQL Server 7.0, determine whether you can pipe output from Query Analyzer into a text file, and discover how to remove decimal points from entries in a character column.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Karen and Brian discuss User DSNs vs. System DSNs, scripts that let you view temporary table structures, enhancements in OLAP Services 7.5, how to disable update triggers, and SQL Agent jobs.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Karen and Brian discuss Win2K's effect on SQL Server users, security account delegation, NULL problems, compressed volumes, and SQL Server 7.0's TRUNCATE TABLE statement.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Discover how to send large email messages via SQL Mail, read system sp code, and make Enterprise Edition use more memory, and learn about SQL Server 7.0's sysperfinfo table, SQL Server Site Index, the TOP operator, and SQL Server 6.5's sql.log.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about single-table backup and restore, SQL Server 7.0 options to remove databases between servers, a REMOVE FILE error message, clustered index performance problems, and more.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Check out DTS Import Wizard upgrades, bcp version settings, the IDENTITY function, Query Analyzer and ANSI settings, and SQL Server version numbers.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about add-ins for OLAP Services, SQL Server 7.0 parallel bcp, the bcp QUERYOUT option, system stored procedures' output format, VBSQL and ADO, and SQL Server log truncation.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
This month, Karen and Brian discuss SQL Server Profiler, Oracle data type incompatibility, multiple indexes for the same table in one query, and database migration resources.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about visible system objects, SQL Server 7.0's improved date aritmetic, distributed heterogeneous gueries, difficult DTS connection names, and the autoshrink function.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers , and Tips About SQL Server
Learn about Microsoft-hosted SQL Server newsgroups, SQL Server 7.0 on a Terminal Server system, SQL Server 7.0's reserved keywords, undocumented error messages, and SQL Server 7.0's Y2K compliance.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about capturing Performance Monitor statistics, the fastest data import method, adding stored error logs, and finding SQL Server 7.0 online resources.
Windows IT Pro
—
Brian Moran
, et al.
In Focas: SGL Server 7.0 Online Resources
Windows IT Pro
—
Brian Moran
, et al.
In Focus: The Many Versions of SQL Server 7.0
Here's a brief marketing-free summary for readers who find the many versions of SQL Server 7.0 confusing.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn about MCDBA certification, Unicode strings, ISQL/w query results, ODBC driver installation, DUMP TRAN commands, and the new Index Tuning Wizard.
Windows IT Pro
—
Brian Moran
, et al.
In Focus: Guidelines for Working with ADO
A list of tips for working with ADO.
Windows IT Pro
—
Brian Moran
, et al.
Questions, Answers, and Tips About SQL Server
Learn how to use the DATALENGTH function, install SQL Server SP4, prevent runaway queries, suppress time values, and delete data from a table with FOREIGN KEY constraints.
Windows IT Pro
—
Brian Moran
, et al.
|
|
Register
