Get Currenttime without time
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-10 (first published: 2004-12-28)
94 reads
Additional Articles
Internal SQL Server Diagnostics Tools, Part 1: PSSDiag
Ken Henderson explains how to use PSSDiag, a diagnostics collection tool for SQL Server. PSSDiag is one of several Microsoft Product Support Services tools recently released to the Web that are now available for personal use. (26 printed pages)
2005-01-10
1,490 reads
Current date without the timestamp
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-07 (first published: 2004-12-28)
375 reads
Transactional replication performance tuning and optimization
Transactional replication is a type of replication provided by SQL Server 2000 that allows data modifications to be propagated incrementally between servers in a distributed environment.
2005-01-07
3,834 reads
Date without the time
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-06 (first published: 2004-12-28)
188 reads
A list of the bugs that are fixed in SQL Server 2000 SP 4 Beta
This article contains information about the bugs that are fixed by Microsoft SQL Server 2000 Service Pack 4 Beta. (SP4).
2005-01-06
6,292 reads
Securing Your Microsoft SQL Server Databases in an Enterprise Environm
If you are running Microsoft SQL Server databases to support critical enterprise applications, you are part of a growing trend.
2005-01-06
1,972 reads
Manipulating Microsoft SQL Server Using SQL Injection
Focuses on advanced techniques that can be used in an attack on an application utilizing Microsoft SQL Server as a backend. These techniques demonstrate how an attacker could use a SQL Injection vulnerability to retrieve the database content from behind a firewall and penetrate the internal network. Also provided are recommendations on how to prevent such attacks.
2005-01-05
2,626 reads
Get the Value of a BitMask
This function will take a 64 bitmask string and return the value of bitmask. If you need 128, 256, etc simply change the length of the parameter, being careful to remember you may need to change the return type of int to BigInt if you get too long.
2005-01-04 (first published: 2004-12-30)
234 reads
Common QA for deploying SQL Server in a SAN Environment
Detailed question/answer paper on deploying SQL Server in a Storage Area Network (SAN) Environment.
2005-01-04
2,513 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers