How to find and install common IFilters||For Search||Crawl
Friends, As covered in one of my previous blog:
How crawl works in SharePoint ||How indexing work||Basic concept .
We were...
2013-01-28
1,257 reads
Blog Posts
I’ll Meet You Half Way–Compromising To Win
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
780 reads
Last Weeks Top 10 “Reading” Links #17
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
973 reads
Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
945 reads
New Year Aspirations – Annette Allen – WiT
Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be...
2013-01-28
937 reads
SQL Server
What is SQL Server?Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software...
2013-01-28
435 reads
Why is My New Server Under CPU Pressure?
Signal waits frequently translate to the amount of time that SQLOS is under pressure for CPU resources, as outlined in...
2013-01-28 (first published: 2013-01-24)
2,924 reads
Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC
The end of the day is quickly approaching as I finish this blog post. This is day 22 in my...
2013-01-27
1,437 reads
Windows 8 In 25 Minutes
Here’s a quick plug for The Missing Windows 8 Instructional Video. I watched it and learned quite a few things,...
2013-01-27
739 reads
Cumulative Update – 2 for SQL Server 2012 Service Pack 1 Is Now Available !
The 2nd cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 2 contains all...
2013-01-26
1,100 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers