2014-05-27
1,122 reads
Site Owners
Write for SQLServerCentral
We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published.
2014-05-22 (first published: 2014-04-10)
2,012 reads
2013-07-02
1,752 reads
SQL Server Sample Databases
This is a landing page for the sample SQL Server databases we are aware of.
2013-05-24
8,145 reads
Free eBook: SQL Server Tacklebox
Get a free ebook from Rodney Landrum and Red Gate Software that helps you prepare to deal with the various crisis situations you might encounter with SQL Server.
2013-01-11
4,793 reads
2012-07-04
1,438 reads
2012-05-18
70 reads
How to Build a Resume (that doesn’t suck)
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain key functions are very hard to perform. In this case, not having a resume makes the job-getting difficult.
2011-12-09
2,060 reads
Setup Alerts for PBM
PBM raises errors for policy violations. We can create alerts on those errors to be notified of policy violations. In order to setup alerts on these errors there are three prerequisites. Note that violations for the “On Demand” evaluation mode do not raise errors. A policy must be set to
2011-12-09
1,094 reads
Extended Events - inaccurate_cardinality_estimate
Extended events have been a bit of a personal “Elephant in the room” for me. I know they are there and I should really get on a start using them but never *quite* have a compelling enough reason.
2011-12-08
1,538 reads
Blogs
SQL Server Performance – What IT Leaders Need to Know
By Kevin3NF
IT leaders have a lot on their plates! Budgets, staffing, security, uptime, and keeping...
FREE Window Functions Course (This Month Only!)
Want to really level up your SQL game? I mean, go from good to great? This March...
Tally Table Alternatives: #SQLNewBlogger
By Steve Jones
We published an article recently at SQL Server Central on Tally Tables in Fabric...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Multiple Sequences
Comments posted to this topic are about the item Multiple Sequences
Using SQL Server Stored Procedures with the Django ORM
Comments posted to this topic are about the item Using SQL Server Stored Procedures...
Question of the Day
Multiple Sequences
In SQL Server 2022, I run this code:
CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1; GO CREATE TABLE NewMonthSales (SaleID INT , SecondID int , saleyear INT , salemonth TINYINT , currSales NUMERIC(10, 2)); GO INSERT dbo.NewMonthSales (SaleID, SecondID, saleyear, salemonth, currSales) SELECT NEXT VALUE FOR myseqtest , NEXT VALUE FOR myseqtest , ms.saleyear , ms.salemonth , ms.currMonthSales FROM dbo.MonthSales AS ms; GO SELECT * FROM dbo.NewMonthSales AS nmsAssume the dbo.MonthSales table exists. If I run this, what happens? See possible answers