This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Network Service permissions.

SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.

August 20, 2009
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server Security

Getting Cannot open database requested by the login for NT AUTHORITY\NETWORK SERVICE? Map that login to your database under User Mapping.

Read More
CDC tool window.

SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008

August 15, 2009
Pinal Dave
SQL Tips and Tricks
Change Data Capture, Database, SQL Data Storage, SQL Scripts, SQL Server, SQL Utility

My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.

Read More
Two red ceramic pitchers stand beside a blue pitcher on a sunlit workbench.

SUM DISTINCT: Equal Amounts Are Not Duplicate Rows

August 14, 2009
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL NULL, SQL Scripts, SQL Server

SUM DISTINCT totals different amounts without checking order identity. I’d establish the row grain first. Compare equal-priced orders, repeated copies and missing amounts.

Read More
Gouache painting: a round revolving spice carousel stands on a counter with seven jars around its rim, one lid vermilion to mark the first position

Modulo: Negative Values Keep the Dividend Sign

August 10, 2009
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL Function, SQL Scripts, SQL Server

Modulo can return a negative remainder for a negative dividend. A second expression normalizes a positive-divisor bucket while keeping the original input and remainder visible.

Read More
SQL Server - Multiple CTE in One SELECT Statement Query

SQL Server – Multiple CTE in One SELECT Statement Query

August 8, 2009
Pinal Dave
SQL Tips and Tricks
CTE, SQL Joins, SQL Scripts

How do you use multiple CTE in one SELECT statement? Two simple examples: independent CTEs joined together, and a second CTE built on the first.

Read More
An unopened present with a red ribbon beside flat balloons and a party hat on a hall table

Calculating Age From a Date of Birth Correctly in T-SQL

August 7, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Use an explicit anniversary rule for calculating age in T-SQL, including February 29, years-months-days output and birthday lookups.

Read More
A wristwatch lying beside a torn-off paper calendar page on a wooden desk.

SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime

August 6, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

Get the time in Hour:Minute Format, or just the date, from a DATETIME with CONVERT styles 108 and 101, or with the TIME and DATE types in SQL Server 2008.

Read More
Previous 1 … 276 277 278 279 280 281 282 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com