Use 100% Fill Factor on Insert Only Tables
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page...
2015-06-24
798 reads
Published last week on SQLServerCentral, Sweat Files and Practice Projects is about the need/lack of packaged projects that a newbie...
2015-06-23
336 reads
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
362 reads
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
2015-06-18
173 reads
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
2015-06-17
202 reads
I’ll be driving up to speak to the Jacksonville SQL group on September 16, 2015 on database corruption. Meeting starts...
2015-06-17
365 reads
I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...
2015-06-17
290 reads
I was reading Our Journey to Cloud Cadence, Lessons Learned at Microsoft Developer Division and saw this bit on transparency:
“No incident is...
2015-06-16
460 reads
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
412 reads
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
350 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers