15,946,316 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
The default search term operator is
OR
for a simple list of search terms.
Any selected filters such as document type, tags, categories, etc. are ANDed to the query in the search box.
You can use brackets,
AND
,
OR
, and
NOT
to improve your search. For example:
C# AND NOT(VB or SQL)
A query of a single
*
will return everything, filtered by any filters.
Filter examples:
Search by Author
author:"author name"
Filter by tag
tag:C#
or
tag:(C++ or Java)
Wildcard search
use "?" or "*" eg.
gr?d
or
gr*
2,778 Results
Filters
Articles
Technical Blogs
Tips & Tricks
Reference Articles
Projects
Assets
Questions
Answers
Forum Messages
News Items
Just My Stuff
My Bookmarks
Sort by
Relevance
Rating (Hi - Lo)
Rating (Lo - Hi)
Popularity (Hi - Lo)
Popularity (Lo - Hi)
Votes (Hi - Lo)
Votes (Lo - Hi)
Modified (New - Old)
Modified (Old - New)
Thread Modified (New - Old)
Thread Modified (Old - New)
Created (New - Old)
Created (Old - New)
Title (A - Z)
Title (Z - A)
Author (A - Z)
Author (Z - A)
Match
All Fields
Title
Description
Author(s)
Tags
Any Date
Last 12 hours
Last 24 hours
Last week
Last 2 weeks
Last month
Last 3 months
Last 6 months
Last year
January
February
March
April
May
June
July
August
September
October
November
December
Rating Range
All - Including Unrated
1.0 - 5.0
2.0 - 5.0
3.0 - 5.0
4.0 - 5.0
4.5 - 5.0
4.8 - 5.0
5.0
More Filters
Article Topics
All Topics
Artificial Intelligence
Internet of Things
DevOps
Containers
High Performance Computing
Hosted Services
Security
Web Development
Mobile Apps
Desktop Programming
Database Development
Productivity Apps and Services
Game Development
Multimedia
General Programming
Programming Languages
Article License
All Licenses
Ms-RL
Custom
CPOL
CDDL
Ms-PL
MPL
CPL
Eclipse
MIT
BSD
Apache
CC (ASA 2.5)
Zlib
Public Domain
CC (Attr 3U)
CC (ASA 3U)
CC (BY-ND 3.0)
LGPL3
GPL3
Forums
All Forums
Feature Forums
General Programming
Web Development
Mobile Development
Product Lifecycle
Database & SysAdmin
General Discussions
Page 1 of 278
Page Size:
10
·
25
·
50
Tag filtered by: SQL-Server
❌
Using IDistributed Cache with EF Core
Please
Sign up or sign in
to vote.
10 Jul 2024
by
Bert O Neill
license:
CPOL
In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.
Database Development
»
Redis
C#
SQL-Server
MySQL
MongoDB
Redis
Query Excel or CSV files with T-SQL
Please
Sign up or sign in
to vote.
19 Jun 2024
by
Federico Di Marco
license:
CPOL
Query Excel or CSV files with T-SQL without importing them in a table first
Database Development
»
Sql Server
SQL
SQL-Server
CSV
SSMS
ini
SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)
Please
Sign up or sign in
to vote.
29 Apr 2024
by
Bert O Neill
license:
CPOL
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
Database Development
»
Sql Server
SQL-Server
data
reporting
SSMS
Data-modeling
Reorganize and Rebuild Indexes and Update Statistics
Please
Sign up or sign in
to vote.
30 Mar 2024
by
GabrieleTronchin
license:
Public Domain
A simple stored procedure to add at your database to keep it reactive
Database Development
»
Sql Server
SQL
Windows
SQL-Server
Automatic Missing Indexes Creation Statements
Please
Sign up or sign in
to vote.
30 Mar 2024
by
GabrieleTronchin
license:
Public Domain
Automatic creation of non clustered indexes using system SQL entities
Database Development
»
Sql Server
SQL
Windows
SQL-Server
POCO Generator
Please
Sign up or sign in
to vote.
7 Jan 2024
by
yuvalsol
license:
CPOL
POCO generating application for SQL Server
Database Development
»
Sql Server
C#
SQL
.NET
SQL-Server
SQL Server: Unexpected Behavior of the LIKE Operator When Used with the ISNULL Function
Please
Sign up or sign in
to vote.
6 Dec 2023
by
scastelli
license:
CPOL
SQL resolves special character challenges, streamlining NULL parameter handling
Database Development
»
Sql Server
SQL
SQL-Server
spSearchTables: Search and Find Tables or Columns by Name or Value
Please
Sign up or sign in
to vote.
21 Nov 2023
by
Federico Di Marco
license:
CPOL
spSearchTables: a helper T-SQL stored procedure for digging into (large) databases
Database Development
»
Sql Server
SQL
SQL-Server
T-SQL
SSMS
How to "Monitor Data Changes in SQL Server Tables with Triggers"
Please
Sign up or sign in
to vote.
7 Aug 2023
by
zidane168
license:
CPOL
Use SQL triggers to keep track of the changes made to your data
Desktop Programming
»
System
SQL
SQL-Server
system
management
trigger
operations
CSV to SQL Server
Please
Sign up or sign in
to vote.
11 Jul 2023
by
Igor Krupitsky
license:
CPOL
This application lets you copy tables from folder with CSV files to SQL Server
Database Development
»
Sql Server
VB
SQL-Server
Page 1 of 278
1
2
3
4
5
6
7
8
9
10
First
·
Prev
·
Next
·
Last
Submit an article or tip