2008-09-09
1,108 reads
Scripts
2008-09-08 (first published: 2008-07-20)
1,305 reads
Invalid SKU Error when Adding a Node to a SQL 2008 Cluster
When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Error
2008-09-07
3,265 reads
2008-09-05
1,286 reads
generate save, delete, get, and list objects for a table
crates sp and function template for a table
2008-09-05
241 reads
Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,109 reads
Quick and dirty way to make a very large table
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,356 reads
Check Fragmentation on All Indexes on Database
In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-03 (first published: 2008-07-10)
4,732 reads
2008-09-03
280 reads
2008-09-02 (first published: 2008-07-10)
2,722 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...
Kantor Resmi BCA KCU CILACAP Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
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