Installing Windows Server 2016 Nano on a Physical Server
Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard...
2017-02-27
864 reads
Temporary Post Used For Theme Detection (34836190-9a25-42fe-be54-415469756264 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (4211c8dc-abcd-4ab4-b505-10f305aa9533 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-12-14
534 reads
2011-12-14
608 reads
WAN Optimization–Part 2
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far....
2011-12-05
674 reads
WAN Optimization Evaluation Review–Part 1
We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s...
2011-11-30
1,897 reads
WAN Optimization Solutions–Input Needed Please!
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few...
2011-11-02
756 reads
Fatal Error Emails This Morning…
So every morning I check my email on my phone. Normally, I don’t see any error emails from SQL Server...
2011-11-01
706 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,966 reads
An Update To My Previous Post
I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve...
2011-05-13
559 reads
My Partitioning And Compression Quest! (Continued)
Thank you, David C, for your comment! Please see below to the answers to
your questions.
The table structure is:
CREATE TABLE...
2011-05-05
901 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
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;See possible answers