This is a follow-on to info's script to strip the time portion of a datetime or smalldatetime, leaving only the date. I found info's script interesting! When I had to do this I converted the date to varchar and back again instead of to float. Seems to work fine for me.
2003-04-03
123 reads
2003-04-03
83 reads
This script shows the way, how to remove a time from datetimes.Do not move this code to UDF, it would run at least 6 times slower.
2003-04-03
87 reads
This query will solve problems related to Table structure. Using this query you can have the complete table structure for all the user tables with Table Name, Column Name, Data Type, and Null attributes of a column.You can run this script in Query Analyzer or make use of it in your front-end to give table […]
2003-04-02
5,161 reads
Gives you a list with name of all the tables, number of rows, row length of each table, total reserved space, space used by data, space used by index and unused space.
2003-04-02
193 reads
For performance concerns or when the need arises to do some data manipulation/updates/inserts or any other code that requires a loop, use a table variable instead of the ever expensive cursor.
2003-04-01
521 reads
Finds the last available backup for a specified database (local or remote server), then restores the backup onto an existing database on the local server.The script will kill all non-system processes in the destination database to allow the script to be scheduled at night regardless is anyone is still connected.The logical and physical names are […]
2003-03-31
774 reads
Some time you need to know only Date without Time.This is simple function that allows you truncate datetime field to date only.This function can help you to construct dynamic T-SQL for select date period. P.S. Thanks for ispaleny! Conversion only for real not enough! It is necessary convert to real that correct errors near the […]
2003-03-28
409 reads
Modified the sp_who2 proc provided by Microsoft. This proc takes a dbname or dbid for input, and lists current processes in that database. If no database is provided, the current database is used.
2003-03-28
197 reads
This is a sp_password enhanced by Dmitri Bobkov (see http://www.sqlservercentral.com/scripts/contributions/718.asp) and re-enhanced with a small changes from SQL2kSP3.For SQL Server in Mixed Authentication mode this stored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit […]
2003-03-27
465 reads
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Comments posted to this topic are about the item 25 Years of SQL Server...
Comments posted to this topic are about the item The Decoded Value
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers