How to pause execution for particular time or interval ? TIP #71
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...
2014-11-09
309 reads
SQL PASS 2014 Summit Diary – Day 6
Today is the last official day of the PASS Summit. The sessions will wrap up at the end of the...
2014-11-08
853 reads
Working with Very Large Tables Like a Pro in SQL Server 2014
I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....
2014-11-08
1,048 reads
PASS Summit: Blogger Q&A with Board of Directors Executive Committee
On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...
2014-11-07
798 reads
Determine size of the file using T-SQL/Powershell/Ole Objects
There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...
2014-11-07
1,115 reads
How to find all running SQL Server Instance on a machine ? TIP #70
Hello friends,
Many times it happened with me I forgot the instance name of SQL Server.
So here is a small trick...
2014-11-07
313 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has been good so far. It has been very busy...
2014-11-07
14 reads
Summit 2014 – Next Impressions
As Summit 2014 begins to wind down, it is time for some more impressions from the week. The week has...
2014-11-07
630 reads
SQL PASS Summit 2014 Diary – Days 3-5
The last two days have been an absolute blur. As I first posted this week, I had planned to blog...
2014-11-07
820 reads
Reblog: October 31 to November 6
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-11-07
1,063 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Rembang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.3 C, Tawangsari, Leteh, Kec. Rembang, Kabupaten Rembang, Jawa Tengah 59217
Layanan BCA KCP Blora Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Pemuda No.57B, Blora, Tempelan, Kec. Blora, Kabupaten Blora, Jawa Tengah 58211
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