Forum Replies Created
Viewing 15 posts - 1,636 through 1,650 (of 59,061 total)
-
Reply To: ChatGPT in SQL Server - Practical examples
I did find a question that it answered mostly correctly...
On the "simple" question of how to combine a DATE and a TIME...
-
Reply To: Importing 7.4gb csv ssis
Kev Wisbey-443237 wrote:Thanks everyone. I passed on suggestions up the food chain but they decided to let it run, 7 hours later...........
I agree with the others... they're doing something seriously wrong. ...
-
Reply To: Usage of #TempTables and an Index in Stored Procedure
ScottPletcher wrote:The DBA's right about the concurrency issue.
Please be specific as to what kind of blocking occurs and how long it actually lasts.
Then, let's see some proof or an article...
-
Reply To: Importing 7.4gb csv ssis
daytonbrown2 wrote:If you are familiar with SSIS, then use that. According to MS and others, SSIS is actually faster than BCP. Although, I've never fully tested myself. That being said,...
-
Reply To: script to find the frequent used login information in the sql
pols wrote:Hi,
Kindly some one share the script or query to get the login information used for the sql database in the instance.
InstanceName,DatabaseName,HostName,LoginName,Program,date used etc
Thanks,
Jo
Why? What actual problem are you trying...
-
Reply To: Importing 7.4gb csv ssis
Kev Wisbey-443237 wrote:I am tasked with writing a package to import a series of files. One of the files is 7.4gb and has 229 columns (look I didn't design this). From...
-
Reply To: how to write a query by using some filter patterns in SQL Server?
Everybody wants to search for things like Google does. Go buy a product that will do this for you in SQL server... it'll be cheaper that you trying to build...
-
Reply To: Grouping the first letter in a string
sathishkm wrote:This was the error message
Msg 8144, Level 16, State 3, Line 12 Procedure or function string_split has too many arguments specified.
Completion time: 2023-03-24T13:47:00.0877172+05:30
That probably means that you're not actually...
-
Reply To: How do you Sprint?
Johan Bijnens wrote:What I "love" about these scrum sprint agile and the newer cicd developments is that most managers think it will speed up their sloppy work.
They still don't have a...
-
Reply To: Query based on sorting based on month
Phil Parkin wrote:Also, why not just use
ORDER BY BusinessEntityID, OrderDate
?
It might perform better.
+1000
-
Reply To: How do you Sprint?
I'm the same way. I've been at the same place coming up on 12 years. Great people, interesting work, good pay and bennies, a commute that I could make on...
Viewing 15 posts - 1,636 through 1,650 (of 59,061 total)