Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Aaron Bertrand
Registered User
member for
1024 days
seen
Oct 21 at 11:03
location
edited
favorite
recent
EXEC dbo.sede_ineachdb @SQLCommand = N'PRINT DB_NAME();',...
/* hi */ EXEC dbo.sede_ineachdb @SQLCommand = N'PRINT DB...
DECLARE @cachebreaker int = ##cachebreaker:int##; EXEC [D...
How long did each Stack Overflow table take (and other info)?
How long did each Stack Overflow table take (and other info)?
CREATE TABLE #results ( db sysname, Id ...
CREATE TABLE #results ( Site NVARCHAR(250), Id INT, Title...
select string_agg(status,', ') [Status of database updates]
First query from 1239509
WITH dbs AS ( SELECT database_id, database_name, made_ava...
Second query from 1239509
/* this will output - Oldest database - Newest database -...
Generate SEDE database markdown for Meta Q359794
Generate SEDE database markdown for Q359794
SELECT * FROM dbo.sede_databases WHERE database_name = N'...
prev
1
…
5
6
7
8
9
next
Data Explorer works best with JavaScript enabled