Viewing 15 posts - 6,766 through 6,780 (of 59,070 total)
@Jeffrey Williams...
I think you're on the right track but...
July 13, 2020 at 11:57 pm
To be honest, I've tried several and I prefer the homegrown native backup methods.
July 13, 2020 at 10:10 pm
marty.seed wrote:How does that help?
Because it gives you the distance from every building to every other building.
And, if you use the right measurements, it gives you the actual driving...
July 13, 2020 at 10:06 pm
What version of T-SQL are you actually using? I ask because there's no such thing as "VARCHR" in T-SQL. There is "VARCHAR" but it has two "A"s in it instead...
July 13, 2020 at 4:52 pm
Confusing pricing, limited hardware choices, and a feature mix that is different.
The king is dead, long live the king!
In our case, a feature mix that is inadequate when it...
July 13, 2020 at 4:48 pm
Luis
You have the same column on the left and right of the equality
WHERE fldinfo=ISNULL(@parameter,fldinfo)
...
Happy to stand corrected.
It's actually because of the function usage on a column. Every row must...
July 13, 2020 at 1:35 pm
I think Phil is showing a restore of the database from the snapshot, essentially rewinding time.
Correct. To be honest, I just assumed that the OP had worded their...
July 13, 2020 at 1:23 pm
Hi Jeff, thanks for your reply. The dates will not changes each year they will remain the same. What are your thoughts based on this? Thanks.
My thoughts on this...
July 12, 2020 at 10:24 pm
I forget which movie I saw it in but the quote was "A man's gotta know his limits". To convert that to something more appropriate to this thread, "A DBA's...
July 11, 2020 at 4:58 pm
If I am reading your function correctly - all it is doing is splitting the delimited string and returning the values as rows. There is no reason to do...
July 11, 2020 at 3:52 pm
So I have a table called charges that stores rent and service charges for properties. Some properties pay rent monthly and others in English quarter days which are (March...
July 11, 2020 at 3:48 pm
I'm jumping in early, as I haven't yet read Leonard Lobel's blog post. As a developer I am very interested in NoSQL databases, and in particular CosmosDB. However, there's...
July 10, 2020 at 6:58 pm
Hi,
I tend to copy data from Table1 to Table2.
Table1 will always being refresh & truncate, because it will subsequent load new record into it.
Table2 will be permanent main table.
As...
July 10, 2020 at 3:06 pm
I could not think of a higher compliment and I'm humbled by your words. Thank you again, good Sir!
July 10, 2020 at 2:50 pm
Viewing 15 posts - 6,766 through 6,780 (of 59,070 total)