Forum Replies Created

Viewing 15 posts - 46 through 60 (of 13,460 total)

  • Reply To: Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps

    change the database compatibility to SQL2019 prior to the items below.

    the optimizer is different between versions, so it's pretty standard to have to, at a minimum, rebuild statistics with full...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2024 at 11:48 am

    #4428788

  • Reply To: How to run custom python module on SQL Server?

    my knee jerk reaction is two fold.

    did you run pip import compute_tau on the server itself? all your libraries you have need to be accessible to SQL's version of python,...

    • This reply was modified 2 years ago by Lowell.
    • This reply was modified 2 years ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 16, 2024 at 11:37 am

    #4428785

  • Reply To: SQL Server Encrypt data into a file, send it and then decrypt

    i would suggest two things here. python can grab data into a dataframe, and then export out parquet files.

    once the file is created, use GnuPG to create an encrypted version...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 12, 2024 at 1:52 am

    #4420605

  • Reply To: Get DDL for any SQL 2005 table

    oh yeah, and stubborn old me only likes varchars..so if you have a table that has a name with nvarchar, like  below, you'd have to find and replace all the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 7, 2024 at 10:31 am

    #4419313

  • Reply To: Get DDL for any SQL 2005 table

    spcghst440 / Tim C, thank you very much for pointing out that gap!

    I've been using this for literally a decade or more, and so far , in my environment, i...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 7, 2024 at 10:25 am

    #4419312

  • Reply To: can i query roles and users from my various tabular databases

    if you are comfortable with PowerShell, this example command will get all end users, including those that are members via a group-within-a-group:

     

    here i am assuming you found a group named...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 21, 2024 at 1:42 pm

    #4399515

  • Reply To: Troubleshooting sql issue where multiple sessions are involved

    see if this script can help you visualize the actual blocker(s).

    this is what I use, I am sure I picked it up here on SSC and further enhanced it. for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 24, 2024 at 3:19 pm

    #4384147

  • Reply To: xp_cmdshell giving error error browsing Sharepoint Online directory files

    it's permissions.

    you have permissions, but the account running the SQL service does not.

    regardless of who is running the SQL command executing xp_cmdshell, once outside of SQL server, xp_cmdshell runs as...

    • This reply was modified 2 years, 3 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 18, 2024 at 6:49 pm

    #4380738

  • Reply To: migrating to the latest version of sql server

    a piece of the puzzle here is connectivity. are you already using cnames to point to the server, so with a simple DNS change, you can say PRODSERVER points to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 18, 2024 at 11:07 am

    #4380604

  • Reply To: upgrade order of components

    the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:

    1. if you use UNC paths for your backup directory, you must...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 18, 2024 at 10:44 am

    #4380591

  • Reply To: How to find the root cause for log .ldf file increased suddenly to 500 gb

    start at the basics:  can we narrow it down to see if it could have been a DBA process or a Business process?

    did you have a scheduled job for statistics,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    February 15, 2024 at 11:43 am

    #4379096

  • Reply To: database schema and permissions

    In my environment, i have a very similar need, but much more robust.

    • I need to script out the current permissions from a development database
    •  restore a database from prod,

      • ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 15, 2023 at 2:36 pm

    #4174503

  • Reply To: OPENROWSET DNR

    On SQL2019, i get an error trying to compile the code.

    Msg 13822, Level 16, State 1, Procedure MyOpenRowSetTest4, Line 4 [Batch Start Line 7]

    File 'd:\downloadedfiles\filethatdoesntexist.txt' cannot be opened...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 15, 2023 at 2:21 pm

    #4174497

  • Reply To: Trouble moving from a 2017 SQL Express DB on one HP laptop to another HP laptop

    Login failed for user 'brainiac' is the key.

    EXECUTE xp_readerrorlog

    and find out the specific reason why the login failed. it will tell you exactly the problem on the next line AFTER ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    January 31, 2023 at 11:39 am

    #4143663

  • Reply To: Transaction Logs and Service Stop

    if the SQL Service is stopped, one of the things it does is puts a pointer in  thelog, to track what is committed or not committed as far as transactions...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 8, 2022 at 12:09 pm

    #4110026

Viewing 15 posts - 46 through 60 (of 13,460 total)