Conversion Precedence
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
10 reads
Recently I talked about the difference between implicit and explicit datatype conversions. In it I ran this code: With the ... Continue reading
2022-09-20
10 reads
I know this is way off my usual content but the other day someone was mentioning how easy it is ... Continue reading
2022-09-15
18 reads
It’s not all that unusual, or unreasonable to put a counter in a name. For example let’s say you need ... Continue reading
2022-10-03 (first published: 2022-09-13)
541 reads
It’s now been about two and a half months since I was given notice and decided to blog about my ... Continue reading
2022-09-28 (first published: 2022-09-08)
201 reads
One of my co-workers came to me the other day and told me that they found their network id as ... Continue reading
2022-09-21 (first published: 2022-09-06)
321 reads
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will ... Continue reading
2022-09-14 (first published: 2022-09-01)
316 reads
Any time I’ve learned about the optimizer there is always one important thing that’s brought up. The optimizer is not ... Continue reading
2022-08-30
18 reads
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
26 reads
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve ... Continue reading
2022-09-05 (first published: 2022-08-23)
223 reads
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in ... Continue reading
2022-08-31 (first published: 2022-08-18)
423 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers