What is Page Life Expectancy (PLE) in SQL Server
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know...
2013-03-08
4,411 reads
Being a production DBA means having to quickly look at a SQL Server and diagnose issue with it. We know...
2013-03-08
4,411 reads
On Thursday March 14th (PI Day) in Duluth GA, Audrey Hammonds and Julie Smith will put on a spectacular SSIS training...
2013-02-12
575 reads
I have been working with a client recently who purchased a nice top of the line de-duplication backup device in...
2013-02-08
1,084 reads
I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and...
2013-02-05
534 reads
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over...
2013-02-04
636 reads
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,951 reads
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle...
2012-11-20
677 reads
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...
2012-11-13
950 reads
Many of us know the importance of scripting out our users on a regular bases in order to be able...
2012-11-02
1,981 reads
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very...
2012-11-01
565 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
hi i was hoping for a more elegant way of setting a pkg level...
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers