2009-06-11 (first published: 2009-05-25)
788 reads
Scripts
Automated Script to Partition Tables
This script is used to print the alter statement and also partition the table with the respective partition Scheme and Partition Function.
2009-06-10 (first published: 2009-05-22)
2,420 reads
Dynamic Columns with PIVOT Operator
Script to convert to N Columns the rows in a table with PIVOT Operator
2009-06-05 (first published: 2009-05-15)
2,037 reads
Create Your Own Batch Runs Composed Of Existing Jobs
Here is a stored procedure that start a job, and then waits until the jobs is finished
2009-06-02 (first published: 2009-05-14)
1,083 reads
The Ultimate Dupe Finder & Performance Test Parameter Set Researcher
Finds the largest dupe-sets of one or more columns of a single table or derived table. Great for finding hoggy parameter combinations for perf-testing queries within stored procedures!
2009-05-29 (first published: 2009-05-05)
957 reads
2009-05-27 (first published: 2009-04-30)
2,627 reads
2009-05-22 (first published: 2009-04-28)
3,854 reads
Function to find non-printable characters
The function is used to find non-printable ASCII characters in an input string.
2009-05-21 (first published: 2009-04-24)
3,025 reads
SQL Server Database Backup Status
Lists the Databases and their Backups status in a neatly formatted HTML Email
2009-05-19 (first published: 2009-04-23)
3,018 reads
2009-05-14 (first published: 2009-04-08)
2,019 reads
Blogs
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...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Magetan Hub/Wa. 0817-819-444
Jl. A. Yani No.25 B, Dusun Onggoprayan, Kepolorejo, Kec. Magetan, Kabupaten Magetan, Jawa Timur...
Layanan BCA KCU MADIUN Hub/Wa. 0817-819-444
9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132
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