2016-10-28 (first published: 2016-10-05)
23,125 reads
2016-10-28 (first published: 2016-10-05)
23,125 reads
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
849 reads
If you want to extract only deadlock details, use the script.
2016-10-24 (first published: 2014-12-03)
3,956 reads
2016-10-21 (first published: 2015-05-12)
2,446 reads
2016-10-20 (first published: 2015-05-15)
1,684 reads
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2016-10-19 (first published: 2016-10-03)
540 reads
If you have a requirement where you need to copy all your backup files to any remote shared location from your local folder/drive and after that you need to do a periodic cleanup of the backup files, you can use my script.
2016-10-18 (first published: 2015-06-01)
2,140 reads
2016-10-17 (first published: 2016-10-03)
903 reads
When code is getting stall, sometimes the execution plans are point to the wrong or out dated or old objects. You would need to recompile all the stored procedures
2016-10-14 (first published: 2016-09-26)
4,468 reads
This stored procedure extracts template variable names and values from a SQL result set in order to process the template.
2016-10-13 (first published: 2016-09-14)
396 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...
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