Useful tips for everyday
What is cylinders in hard disk? A cylinder is any set of all of tracks of equal diameter in a hard disk drive (HDD). It…
How do you read extended event data? In the Object Explorer pane, you can expand the nodes and then right-click: Management > Extended Events >…
Does TRUNCATE table reset sequence? The TRUNCATE statement has an additional option RESTART IDENTITY which resets the sequences associated with the table columns. TRUNCATE sch.…
How to select column depending on the value of? Consider the following table. I want to write a query that selects either the blue_player_id or…
How to restart PostgreSQL stack overflow in Linux? You can also restart postgresql by using this command, should work on both the versions: 3-Search Postgres…
Can a relation have multiple foreign keys? A table may have multiple foreign keys, and each foreign key can have a different parent table. Therefore,…
What are conditional statements in MySQL? In this article we will describe how to use Conditional Statements in MySQL. Use IF in select clause: The…
How do I monitor SQL Server log shipping? To monitor a log shipping configuration, you must add the monitor server when you enable log shipping.…
How do I save SSIS package to file system? Save a package to the file system In SQL Server Data Tools (SSDT), open the Integration…
What is max allowed packet MySQL? The largest possible packet that can be transmitted to or from a MySQL 8.0 server or client is 1GB.…