Tricks and issues Part 1
Today was browsing the Blog http://blog.sqlauthority.com/ Pinal Dave expert on Sql server and great Blog writer. Got surprise to see...
2009-10-23
636 reads
Vinay Thakur
Some useful commands and sp I use for Transaction Replication:
I write several blog about replication and mansion commands and stored procedure related to transaction replication, but I would like...
2009-10-23
1,325 reads
Some useful commands and sp for Transaction Replication
This blog is having some useful commands we use for replication and troubleshooting.
>>Some useful commands and stored procedures
How it works:
Log...
2009-10-23
18,480 reads
Logins no longer exists.
Today while checking the logins, just want to clear/clean logins which are no longer exists on NT domain.
To get...
2009-10-22
553 reads
Table Variable and Temp Table
Today I come across the great blog by Wayne Sheffield on Sqlservercentral.com about temp table and table variable so I...
2009-10-16
578 reads
Network backup Access via Query Analyzer
Hi,
Today while working on query analyzer found very interesting thing about security.
My sql server A is running with service account...
2009-10-14
612 reads
Blogging
Hi,
Yesterday while talking to my friend, he reviewed my blog and suggested that I was having so many spelling...
2009-10-13
431 reads
Reindex and Update stats.
Today I was reading blog by Ben Nevarez it is great... (I am impressed with ben now a days) that's...
2009-10-09
755 reads
Select count(*)
Today I was reading(I always read Paul Randal).
http://www.sqlskills.com/BLOGS/PAUL/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx
I learned that whenever you query select count(*) it will select the the...
2009-10-09
1,949 reads
Impact of uninstall instance on replication.
Hi,Today While playing with replication and instance and DR strategy. Found very interested thing.so though to blog that.I have 6...
2009-09-29
1,658 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