Table Valued Function to factorize numbers up to 100 trillion
This table valued function will quickly find the prime factors of any number up to 10 trillion
2017-04-26 (first published: 2017-04-06)
342 reads
Prime Numbers
2018-11-30 (first published: 2017-04-01)
859 reads
Table Valued Function to return a range of prime numbers
A fast table valued function to generate a list of prime numbers within the range specified by the parameters.
2017-04-12 (first published: 2017-03-30)
377 reads
RE: Select Distinct
(weird, the system just deleted PART of my post!)If your data is not consistent, it's either going to have to be cleaned up so that it is or you're going to have to live with problems. Data being different lengths is not always a problem as long as the left-aligned significant parts are consistent.Assuming the data […]
2005-05-06
cookies/ session
I am in the process of building a web site using asp.net and a sql database. I have my login page set up using cookies. I will have several different pages the user will fill out - something like an extensive survey. How can I set up a stored procedure to grab the user's ID […]
2005-03-01
1 reads
RE: Datatype question. Need to exceed varchar(8000) in stored proc.
Bert,Thank-you! This worked perfectly! I didn't realize you could use your suggested syntax for the insert statement. This is exactly what I was looking for!Thanks again!-Jason
2005-01-13
RE: Creating a Database from a SP
I need to generate full db script every week as DBA documentation. Want to do it automatically on schedule.
2005-01-13
RE: Diff backup and Tran Log at the same time
We tend to disable our transaction log backups during full and differential backups (also reindex jobs and DBCC checks), but that's mainly due to a set of jobs we have to notify us if there's any blocking going on in the database, obviously you can't do two backups at the same time so the one […]
2005-01-13
RE: Secure communication
Yes, you can use a certificate provided by your internal certificate server. However, both SQL Server and the clients will have to trust the root CA. Of course, this should go without saying. Yes, IPSec, especially when combined with AD, can be used for secure communications. The simplest solution for most folks is going to […]
2005-01-12
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers