2004-10-01 (first published: 2004-02-16)
152 reads
2004-10-01 (first published: 2004-02-16)
152 reads
This is a UDF that counts the days between two dates ignoring weekends and corporate holidays (as supplied in a lookup table). This ignores the time component but could be adjusted should you need to. If both days are on the same work day then the elapsed days is considered 1. If started Monday and […]
2004-09-30
467 reads
2004-09-30 (first published: 2004-02-16)
108 reads
Two Method for Return the Count of Weekday between two date!
2004-09-30
357 reads
This article focuses on a common problem associated with conflicting locks: blocking. When blocking occurs, a single connection blocks all other connections from reading or modifying a particular piece of data. Learn here how to resolve these issues.
2004-09-30
3,955 reads
playyuer@Microshaoft.com inventhttp://www.Microshaoft.com2004-09-29 updatethere is NOT any relation with global variable: @@DATEFIRSTyou can set datefirst any value from 0 to 7 and result can not be affected!
2004-09-29
182 reads
This article looks at the basics of storage design for cubes using Analysis services. A good starting point for those getting into the use of analysis services.
2004-09-29
2,390 reads
Akeel Din has written an introductory SQL book that is available for free in PDF form. It's also available in print from Amazon if you like holding something real in your hands.
2004-09-28
6,070 reads
This function returns the difference between dates in the HH:MM:SS format.
2004-09-27 (first published: 2004-03-08)
131 reads
A basic look at how you can start to build a data warehouse. This has some basics you need to do the design of the various fact and dimension tables.
2004-09-27
5,004 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers