Altering column size in SQL Server
Learn altering column size in sql server with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
Tag: Database
How to increase the performance of a Database?
Learn how to increase the performance of a database? with practical examples, diagrams, and best practices. Covers sql, database, sql-server-2005 development techniques with visual explanations.
How does database indexing work?
Learn how does database indexing work? with practical examples, diagrams, and best practices. Covers sql, database, performance development techniques with visual explanations.
JOIN three tables
Learn join three tables with practical examples, diagrams, and best practices. Covers sql, mysql, database development techniques with visual explanations.
Using git repository as a database backend
Learn using git repository as a database backend with practical examples, diagrams, and best practices. Covers database, git, database-performance development techniques with visual explanations.
Categories:
SQL query to find third highest salary in company
Learn sql query to find third highest salary in company with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
SQL CASE WHEN with multiple AND and OR
Learn sql case when with multiple and and or with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
Database design for database-agnostic applications
Learn database design for database-agnostic applications with practical examples, diagrams, and best practices. Covers sql, database, database-design development techniques with visual explanations.
Insert into ... values ( SELECT ... FROM ... )
Learn insert into ... values ( select ... from ... ) with practical examples, diagrams, and best practices. Covers sql, database, syntax development techniques with visual explanations.
SQL select statements with multiple tables
Learn sql select statements with multiple tables with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
Foreign keys vs secondary keys
Learn foreign keys vs secondary keys with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
query for substring formation
Learn query for substring formation with practical examples, diagrams, and best practices. Covers sql, database, string development techniques with visual explanations.
Create new user in MySQL and give it full access to one database
Learn create new user in mysql and give it full access to one database with practical examples, diagrams, and best practices. Covers sql, mysql, database development techniques with visual explanat...
SQL Server Insert Example
Learn sql server insert example with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
How to check if a table exists in a given schema
Learn how to check if a table exists in a given schema with practical examples, diagrams, and best practices. Covers sql, database, postgresql development techniques with visual explanations.
SQL Inserting multiples values using the result of a select
Learn sql inserting multiples values using the result of a select with practical examples, diagrams, and best practices. Covers sql development techniques with visual explanations.
Difference between CASCADE and RESTRICT? SQL DDL database
Learn difference between cascade and restrict? sql ddl database with practical examples, diagrams, and best practices. Covers sql, database, ddl development techniques with visual explanations.
Altering SQL table to add column
Learn altering sql table to add column with practical examples, diagrams, and best practices. Covers sql, sql-server, database development techniques with visual explanations.
What is a "Scalar" Query?
Learn what is a "scalar" query? with practical examples, diagrams, and best practices. Covers sql, database, executescalar development techniques with visual explanations.
What is purpose of using mysql_secure_installation?
Learn what is purpose of using mysql_secure_installation? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
Setting up new instance of MySQL what is Current Root Password?
Learn setting up new instance of mysql what is current root password? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
MySQL: Is there a way to update an entire table in one query?
Learn mysql: is there a way to update an entire table in one query? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
Is there a performance hit using decimal data types (MySQL / Postgres)
Learn is there a performance hit using decimal data types (mysql / postgres) with practical examples, diagrams, and best practices. Covers mysql, database, postgresql development techniques with vi...
Dividing a column by 12, MySQL Query
Learn dividing a column by 12, mysql query with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
In mysql, the show databases; command doesn't list all of my databases
Learn in mysql, the show databases; command doesn't list all of my databases with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
Which version of PostgreSQL am I running?
Learn which version of postgresql am i running? with practical examples, diagrams, and best practices. Covers linux, database, postgresql development techniques with visual explanations.
Categories:
Get table names using SELECT statement in MySQL
Learn get table names using select statement in mysql with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
What is difference between primary index and secondary index exactly?
Learn what is difference between primary index and secondary index exactly? with practical examples, diagrams, and best practices. Covers mysql, database, oracle-database development techniques wit...
How to delete mysql database through shell command
Learn how to delete mysql database through shell command with practical examples, diagrams, and best practices. Covers mysql, database, linux development techniques with visual explanations.
sql query with multiple where statements
Learn sql query with multiple where statements with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
MySQL root password change
Learn mysql root password change with practical examples, diagrams, and best practices. Covers mysql, database, passwords development techniques with visual explanations.
Describe all tables in the database with a single statement?
Learn describe all tables in the database with a single statement? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
how to concat two columns into one with the existing column name in mysql?
Learn how to concat two columns into one with the existing column name in mysql? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
Open and read .abs database files in python
Learn open and read .abs database files in python with practical examples, diagrams, and best practices. Covers python, database, delphi development techniques with visual explanations.
Categories:
Dynamically structured mySQL database for an Airline Reservation App
Learn dynamically structured mysql database for an airline reservation app with practical examples, diagrams, and best practices. Covers mysql, sql, database development techniques with visual expl...
If table exists drop table then create it, if it does not exist just create it
Learn if table exists drop table then create it, if it does not exist just create it with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanati...
Can a table have multiple Primary keys?
Learn can a table have multiple primary keys? with practical examples, diagrams, and best practices. Covers mysql, sql, sql-server development techniques with visual explanations.
Query gives #1305 - FUNCTION database-name.LEN does not exist; WHY?
Learn query gives #1305 - function database-name.len does not exist; why? with practical examples, diagrams, and best practices. Covers mysql development techniques with visual explanations.
Using an Alias in SQL Calculations
Learn using an alias in sql calculations with practical examples, diagrams, and best practices. Covers mysql, sql, database development techniques with visual explanations.
Query on top N rows in mongodb
Learn query on top n rows in mongodb with practical examples, diagrams, and best practices. Covers mongodb development techniques with visual explanations.
How to save object variables after closing my program?
Learn how to save object variables after closing my program? with practical examples, diagrams, and best practices. Covers java, database, variables development techniques with visual explanations.
Categories:
What exactly is a CRUD table
Learn what exactly is a crud table with practical examples, diagrams, and best practices. Covers java, database, crud development techniques with visual explanations.
Categories:
MongoDB Aggregation: How to get total records count?
Learn mongodb aggregation: how to get total records count? with practical examples, diagrams, and best practices. Covers mongodb development techniques with visual explanations.
Query with Type not Equal in mongodb
Learn query with type not equal in mongodb with practical examples, diagrams, and best practices. Covers mongodb development techniques with visual explanations.
PostgreSQL "DESCRIBE TABLE"
Learn postgresql "describe table" with practical examples, diagrams, and best practices. Covers database, postgresql, command development techniques with visual explanations.
Categories:
How can I start PostgreSQL on Windows?
Learn how can i start postgresql on windows? with practical examples, diagrams, and best practices. Covers postgresql development techniques with visual explanations.
Categories:
How to list databases in terminal in PostgresSQL?
Learn how to list databases in terminal in postgressql? with practical examples, diagrams, and best practices. Covers database, postgresql, terminal development techniques with visual explanations.
Categories:
Payroll System Design, Business Logic in SPs or Application Layer (C#.Net), Maintainability - Repost
Learn payroll system design, business logic in sps or application layer (c#.net), maintainability - repost with practical examples, diagrams, and best practices. Covers c#, database, oop developmen...
Categories:
How to do an update + join in PostgreSQL?
Learn how to do an update + join in postgresql? with practical examples, diagrams, and best practices. Covers postgresql development techniques with visual explanations.
Categories:
How to show tables in PostgreSQL?
Learn how to show tables in postgresql? with practical examples, diagrams, and best practices. Covers database, postgresql, command development techniques with visual explanations.
Categories:
Postgresql : Connection refused. Check that the hostname and port are correct and that the postma...
Learn postgresql : connection refused. check that the hostname and port are correct and that the postmaster is accepting tcp/ip connections with practical examples, diagrams, and best practices. Co...
Categories:
What’s the difference between a dataStore and a database?
Learn what’s the difference between a datastore and a database? with practical examples, diagrams, and best practices. Covers database, postgresql, datastore development techniques with visual expl...
Categories:
PDOException SQLSTATE[HY000] [2002] No such file or directory
Learn pdoexception sqlstate[hy000] [2002] no such file or directory with practical examples, diagrams, and best practices. Covers php, mysql, laravel development techniques with visual explanations.
Categories:
How to empty my destination table before inserting new records in SSIS?
Learn how to empty my destination table before inserting new records in ssis? with practical examples, diagrams, and best practices. Covers sql-server, database, ssis development techniques with vi...
Categories:
How to pass data.frame for UPDATE with R DBI
Learn how to pass data.frame for update with r dbi with practical examples, diagrams, and best practices. Covers database, r, dataframe development techniques with visual explanations.
Categories:
Getting execute permission to xp_cmdshell
Learn getting execute permission to xp_cmdshell with practical examples, diagrams, and best practices. Covers sql-server, database, xp-cmdshell development techniques with visual explanations.
Categories:
What is an example of a non-relational database? Where/how are they used?
Learn what is an example of a non-relational database? where/how are they used? with practical examples, diagrams, and best practices. Covers database, non-relational-database development technique...
Categories:
What is an MDF file?
Learn what is an mdf file? with practical examples, diagrams, and best practices. Covers mdf, sql-server, database development techniques with visual explanations.
Categories:
Difference between scaling horizontally and vertically for databases
Learn difference between scaling horizontally and vertically for databases with practical examples, diagrams, and best practices. Covers database, database-design, nosql development techniques with...
Categories:
What is an ORM, how does it work, and how should I use one?
Learn what is an orm, how does it work, and how should i use one? with practical examples, diagrams, and best practices. Covers database, orm, language-agnostic development techniques with visual e...
Categories:
Significance of ROW KEY in a database table
Learn significance of row key in a database table with practical examples, diagrams, and best practices. Covers database, primary-key, rows development techniques with visual explanations.
Categories:
List of standard lengths for database fields
Learn list of standard lengths for database fields with practical examples, diagrams, and best practices. Covers database, standards development techniques with visual explanations.
Categories:
Where to get a Database of Spanish <-> English Translations?
Learn where to get a database of spanish <-> english translations? with practical examples, diagrams, and best practices. Covers database, language-agnostic, translation development techniques with...
Categories:
Best design for a changelog / auditing database table?
Learn best design for a changelog / auditing database table? with practical examples, diagrams, and best practices. Covers database, database-design, audit development techniques with visual explan...
Categories:
In Drupal should I use content-types or database abstraction layer?
Learn in drupal should i use content-types or database abstraction layer? with practical examples, diagrams, and best practices. Covers database, drupal-7, methodology development techniques with v...
Categories:
Backend as a service (BaaS) or old school SQL server for Mobile APP Remote Database
Learn backend as a service (baas) or old school sql server for mobile app remote database with practical examples, diagrams, and best practices. Covers sql-server, database, mobile development tech...
Categories:
Difference between Fact table and Dimension table?
Learn difference between fact table and dimension table? with practical examples, diagrams, and best practices. Covers database, data-warehouse, business-intelligence development techniques with vi...
Categories:
Difference between a theta join, equijoin and natural join
Learn difference between a theta join, equijoin and natural join with practical examples, diagrams, and best practices. Covers database, relational-database, relational-algebra development techniqu...
Categories:
what is meaning partial resynchronization of redis?
Learn what is meaning partial resynchronization of redis? with practical examples, diagrams, and best practices. Covers redis development techniques with visual explanations.
Categories:
Database partitioning - Horizontal vs Vertical - Difference between Normalization and Row Splitting?
Learn database partitioning - horizontal vs vertical - difference between normalization and row splitting? with practical examples, diagrams, and best practices. Covers database, database-design, d...
Categories:
accessing cloud storage directly from an android application
Learn accessing cloud storage directly from an android application with practical examples, diagrams, and best practices. Covers android, database, google-app-engine development techniques with vis...
Categories:
Does Anyone Use Address Line 2
Learn does anyone use address line 2 with practical examples, diagrams, and best practices. Covers database, database-design, schema development techniques with visual explanations.
Categories:
Best practice selecting database for mobile app
Learn best practice selecting database for mobile app with practical examples, diagrams, and best practices. Covers android, ios, database development techniques with visual explanations.
Categories:
Is it a good practice to encapsulate the database access
Learn is it a good practice to encapsulate the database access with practical examples, diagrams, and best practices. Covers database, language-agnostic, encapsulation development techniques with v...
Categories:
What is the most clever and easy approach to sync data between multiple entities?
Learn what is the most clever and easy approach to sync data between multiple entities? with practical examples, diagrams, and best practices. Covers database, algorithm, mobile development techniq...
Categories:
Non-Repeatable Read vs Phantom Read?
Learn non-repeatable read vs phantom read? with practical examples, diagrams, and best practices. Covers database, oracle-database, transactions development techniques with visual explanations.
Categories:
Alternative to "master" and "slave" in entity relationship?
Learn alternative to "master" and "slave" in entity relationship? with practical examples, diagrams, and best practices. Covers database, architecture, entity development techniques with visual exp...
Categories:
Dropping a role in a SQL Server database returns Error: 15138 - The database principal owns a sch...
Learn dropping a role in a sql server database returns error: 15138 - the database principal owns a schema int he database, and cannot be dropped with practical examples, diagrams, and best practic...
Categories:
Boyce-Codd Normal Form
Learn boyce-codd normal form with practical examples, diagrams, and best practices. Covers database, relational-database, bcnf development techniques with visual explanations.
Categories:
What's the "best" database for embedded?
Learn what's the "best" database for embedded? with practical examples, diagrams, and best practices. Covers database, embedded, embedded-database development techniques with visual explanations.
Categories:
How to create an empty SQLite db with command?
Learn how to create an empty sqlite db with command? with practical examples, diagrams, and best practices. Covers database, sqlite, command development techniques with visual explanations.