Forum Replies Created
Viewing 15 posts - 1,636 through 1,650 (of 59,066 total)
-
Reply To: Shrink Database Log Files One by One
I've just started reading your article, Manie. I don't believe you'll find many experts that would crucify anyone for using a cursor for process control. RBAR process of rows? Yeah,...
-
Reply To: Usage of #TempTables and an Index in Stored Procedure
Jonathan AC Roberts wrote:To fix it I had to create the temporary table first with the clustered index then insert the data.
When I said "we", I should have said "they". What you...
-
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:For Jeff, because I was having fun...
Heh... if you want to have some real fun, have someone successfully answer the question...
-
Reply To: Outsourcing Operations
Heh... wait for it...
-
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...
Viewing 15 posts - 1,636 through 1,650 (of 59,066 total)