Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.
2010-12-17
3,557 reads
2010-12-17
655 reads
2010-12-16
11,888 reads
Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed.
2010-12-16
2,928 reads
One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...
2010-12-16
2,289 reads
How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?
2010-12-16
5,016 reads
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-15
3,713 reads
Changes are inevitable and like many other things in life your application will change over time. The question is how to upgrade an already deployed Data Tier Application to a newer version; what are the different methods available for upgrade and what considerations should you take?
2010-12-15
2,360 reads
In this webinar, MVP and noted author, Grant Fritchey shows you how to better keep track of what is happening on your instances by gathering information on performance from SQL Monitor and then using that to interpret the impact on your databases. Dec 14, 2010.
2010-12-14 (first published: 2010-12-07)
2,225 reads
Sharon PruittIn the lead in to this post, I talked about how the plan cache can...
2010-12-14
938 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Pluit Karang Utara Blok I No.36 1. S Kav. 53, Pluit, Kecamatan...
Telp/wa 085169998765 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers