Forum Replies Created
Viewing 15 posts - 766 through 780 (of 59,066 total)
-
Reply To: Announcing the first Microsoft Fabric Community Conference!
I'd much rather they spent their time making SQL Server 2022 run as fast as it used to in 2017. They "broke" it in 2019 and still haven't fixed it...
-
Reply To: Data Archiving
Do any of the tables that you want to delete from have IDENTITY columns in them? I don't see IDENTITY anywhere in your CREATE TABLE scripts but just need to...
-
Reply To: More Private Clouds
Elon Musk moved "X" back to on-prem with, reportedly, a substantial savings.
There are a ton of other companies that have or are considering moving back to on-prem. Here's a decent...
-
Reply To: cursor not getting next values
LJMoss wrote:There are legitimate reasons to use a cursor..
Just an opinion here...
While I agree with the statement quoted above (because "It Depends" is always a consideration), I've found that a...
-
Reply To: Adding an AI Policy for Authors
Heh... speaking of AI...
Could you use the AI to suggest to you good folks how to fix all the problems with the forum software and the article submission software?
Those two...
-
Reply To: Replace double quotes in derieved column SSIS
lokesh.hyperion@gmail.com wrote:No, it did not work and that was the reason I took time to post it here. I have tried many options including substring.
Yeah... sorry... admittedly, I only took...
-
Reply To: How fast can SQL Server Insert data into table - 40 Million plus
Just to encourage you, I have a table of the following "specs"...
52.1 GB
100 Million Rows
529 Bytes Average Row Size
With the Clustered Index in place, it only took 1 minute and...
-
Reply To: How to substract value from its own column in same tabl through condition basis
manojsemwal1 40990 wrote:table data is like this and out put of the data is mentioned in earlier post
You didn't read the article at the...
-
Reply To: Teams meeting Required to explain a list that has a table embedded in it.
robertukoli22 wrote:Sorry this is an SSRS Reporting services problem
IIRC, you can edit the title of your own original post.
And, are you seriously stuck with SSRS 2008?
-
Reply To: How to substract value from its own column in same tabl through condition basis
Phil Parkin wrote:Once again, if you want coding assistance, please provide consumable sample data for us to experiment with.
In other words, do like I previously suggested... read'n'heed the article at the...
-
Reply To: Replace double quotes in derieved column SSIS
If you're using >= 2017, the TRIM function in T-SQL will handle the removal of double quotes and spaces and whatever other leading/trailing characters you may have to work with. ...
-
Reply To: SQL Query requirements
jcelko212 32090 wrote:You're still writing SQL as if you were in BASIC or Fortran. Let's start off with the create table statement. By definition, and not as an option, table must...
-
Reply To: How to substract value from its own column in same tabl through condition basis
Sorry... originally missed the meaning here and took the post down and replacing it with the following...
Just use a WHERE NOT IN. If something more sophisticated is desired, we'd need...
-
Reply To: Mind Over Milkshake (Thoughts Matter)
Rod at work wrote:Resistance to any change in systems, until they break beyond repair, is a bad practice.
I strongly disagree... especially when someone claims that such a thing is a "practice", either...
Viewing 15 posts - 766 through 780 (of 59,066 total)