To comment out lines of code in SQL Server Management Studio (SSMS) Query Window, select lines of code you want to comment out and hit the keyboard shortcut ‘CTRL+K’ followed by ‘CTRL+C’.
https://www.mssqltips.com/sqlservertip/5970/restore-sql-server-database-backup-to-an-aws-rds-instance-of-sql-server/
https://blog.timescale.com/blog/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a/
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15
This SQL query will add up the record count per day based on a column called “Timestamp.” Transact SQL SELECT DATEPART(YEAR, Timestamp) AS ‘Year’, DATEPART(MONTH, Timestamp) AS ‘Month’, DATEPART(DAY, Timestamp) AS ‘Day’, COUNT(*) AS ‘Visits’FROM tblVisitsGROUP BY DATEPART(DAY, Timestamp), DATEPART(MONTH, Timestamp), DATEPART(YEAR, Timestamp)ORDER BY ‘Year’, ‘Month’, ‘Day’ Results The results of this query will appear… Leer más »
I recently came up against a SQL Server instance that wouldnt start, after going through the event log the reason it was having problems was that it had been set to a max memory of 10mb. At this point I was unable to change the max memory setting because I couldnt bring the instance online.… Leer más »
CREATE SYNONYM [dbo].[tbl1] FOR [db1].[dbo].[tbl1] The above code, if run on db2, would create an object tbl1 which would behave as a table under the dbo schema in db2, but would actually reference [db1].[dbo].[tbl1]. If you are on 2000, then no, it’s fully qualified names or nothing, I’m afraid. Nota: –>Ubicarse en la base donde… Leer más »
Rate This martijnh1 15 Jul 2010 1:24 PM 8 Recently, I’ve been involved in a very interesting project in which we need to perform operations on a table containing 3,000,000,000+ rows. For some tooling, I needed a quick and reliable way to count the number of rows contained within this table. Performing a simple SELECT… Leer más »