Modern Data Warehousing Presentation
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
648 reads
T-SQL Tuesday #57 – SQL Family and Community
Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday. TSQL Tuesday is a recurring blog party that...
2014-08-12
10 reads
T-SQL Tuesday #57 – SQL Family and Community
Look at that, it is once again that time of the month that has come to be known as TSQL...
2014-08-12
755 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
311 reads
Snippet Alert: Useful dates (eom, bom, etc)
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,061 reads
Generate Random Date With Starting Point
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
536 reads
T-SQL Tuesday #57: SQL Family
This month’s T-SQL Tuesday topic is SQL Family and is brought to us by Jeffrey Verheul (b/t). It’s an amazing...
2014-08-12
606 reads
T-SQL Tuesday #57–SQL Family and Community
It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.
The topic this month is hosted by...
2014-08-12
713 reads
Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast
Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...
2014-08-12
621 reads
SUM() function in SQL Server
Sum():- This function is used to get the sum of values of the specified numeric column.
Syntax:-
Select Sum (column_name) from tablename
Example:-...
2014-08-12
729 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
Question of the Day
Adding Bits I
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