Viewing 15 posts - 166 through 180 (of 1,199 total)
I think you are into over-engineering when you are considering to have a separate table. That would only make sense, if you are considering to track not only last accessed,...
February 29, 2020 at 8:51 pm
Well, you started three threads, and Lynn replied to them all...
February 17, 2020 at 9:54 pm
The answer is simple: you are not in Kansas anymore.
LIKE does not support regular expressions of any flavour. It supports % to mean 0 or more of any characters. It...
February 17, 2020 at 9:49 pm
I can only give a solution to the problem you state, which was for the update of a single value.
Since I don't know how your more than 100 records are...
January 29, 2020 at 9:44 pm
Sounds like
IF (SELECT COUNT(*)
FROM tbl
WHERE FailedNumber = @FailedNumber
...
January 29, 2020 at 8:57 pm
While I may point out the obvious, when you run the query with TRY_CAST make sure that you also have the result of your massaging included, so that you can...
January 23, 2020 at 1:23 pm
Copy the table to an instance of a newer version of SQL Server. Download and install Express Edition if needed. On that version run a query with try_cast, to see...
January 23, 2020 at 12:51 pm
The first reply is: don't store data like this! Yes, I know you told us that you can't change the model, but pass the bucket: don't store data like this.
Next,...
January 22, 2020 at 8:04 pm
Great to hear that you were able to work it out!
January 3, 2020 at 11:54 am
Not really your everyday scenario, so I don't have a canned answer. 🙂 But use Profiler to spy on SSMS to see what queries it submits. This should give you...
January 3, 2020 at 8:48 am
This sounds like a problem with SSMS. Which version of SSMS do you have? You can download the most recent version here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms. Not that this necessarily helps, as...
January 2, 2020 at 8:19 pm
It is not uncommon that performance changes drastically from day to another in DBMS with a cost-based optimizer. As the data volume grows, the statistics changes, and the optimizer may...
December 22, 2019 at 10:41 pm
I can confirm what John says. I actually have VS 2005 installed (as well as a few later VS versions), and attempts to connect to SQL 2008 or SQL 2014...
December 16, 2019 at 8:02 pm
We don't know your exact context for this arrangements, but it sounds like you have users all over the place that connect to your database. Let's make this clear: this...
December 13, 2019 at 11:02 am
hello, my application with vb.net connect to database though internet, that why ssms can connect though internet. So, i want increase security. I want to disable connect with ssms though...
December 12, 2019 at 3:32 pm
Viewing 15 posts - 166 through 180 (of 1,199 total)