Forum Replies Created

Viewing 15 posts - 31 through 45 (of 13,460 total)

  • Reply To: built in deadlock information capture

    so deadlock information is capture int eh system health extended event, in the stack of files it saves.

    here's a really good stack of queries i put together and use on...

    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!

    August 12, 2025 at 5:11 pm

    #4634515

  • Reply To: Recommended Extended Event that will send an email

    here's an example i use pretty frequently. it's a stored procedure, that is calling Adam Machanic's sp_whoisactive.

    if there are no long running transactions, It bails out gracefully, but if something...

    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!

    August 6, 2025 at 2:00 pm

    #4631611

  • Reply To: Direct Connection running Fast,Linked Server running Slow

    so as Johan mentioned, linked servers leverage tempdb. so if you are adding a WHERE or an ORDER BY, or joining it to your local data, the whole table goes...

    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!

    August 5, 2025 at 1:45 pm

    #4631056

  • Reply To: When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense

    I happen to be in the middle of a vector project. i downloaded SQL2025, and while i can  use the vector data type, the built in functions related to vectors...

    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!

    July 30, 2025 at 8:49 am

    #4628531

  • Reply To: SQL Server 2025 Excitement

    I've been doing some stuff with the new [vector] data type as a result of some efforts related to AI projects. in both 2025 and Azure, the data type exists,...

    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 20, 2025 at 2:03 pm

    #4610610

  • Reply To: XML_COMPRESSION for existing tables

    hey i found it. the sys.partitions has two new-ish columns xml_compression and xml_compression_desc

    the code below is something i use for scripting indexes, but if i was scripting a table, 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!

    June 20, 2025 at 1:59 pm

    #4610589

  • Reply To: Third party backup softwares

    I agree, San Level snapshots like Veeem and Pure are awesome; they issue the dbcc freeze command, and the backup, even when say, 30TB, takes seconds. And then issues 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!

    April 30, 2025 at 10:41 am

    #4585919

  • Reply To: Third party backup softwares

    so there are a few things you can tweak yourself...and I am under the impression that nothing is faster than a native backup with the optional settings.

    three specific optional flags...

    • This reply was modified 1 years, 1 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!

    April 28, 2025 at 7:57 pm

    #4585183

  • Reply To: Parse XML data from SQL table using temp tables and variables

    yes, it's annoying. you must literally use a string, and not a variable that happens to be a string.

     

    The work around is to build the query string and execute it....

    • This reply was modified 1 years, 1 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!

    April 25, 2025 at 5:55 pm

    #4584181

  • Reply To: Edition features

    You can downgrade or upgrade Enterprise to Standard, and Vice Versa, if you have the key for the target edition.

    I had started grabbing all the enterprise edition objects via a...

    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 22, 2025 at 5:34 pm

    #4582557

  • Reply To: MySQL Help - Beginner

    this is the  educational part about learning to code...working through the errors.

    I am assuming you are using mySQL workbench for development.

    there is an output window that might actually be hidden,...

    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!

    September 14, 2024 at 12:12 pm

    #4457532

  • Reply To: Hierarchical List of All tables

    still based on the same old code from ten years ago, this is what i do today: it's just a handfull of legos/snippets, assembled into the shape of something i...

    • This reply was modified 1 years, 9 months ago by Lowell. Reason: spelling

    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!

    September 14, 2024 at 11:40 am

    #4457526

  • Reply To: Hi any one please help in details about these below 

    that's a decent list of interview questions to test if you have any experience doing any of those steps. i my self ask variants of some of these questions, and...

    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 29, 2024 at 8:30 pm

    #4432416

  • Reply To: Get DDL for any SQL 2005 table

    In Azure, the procedures sp_GetDDL and sp_GetDDLa would have to be installed in each database; so 10 dbs = 10 copies, sorry

    we don't have the ability to leverage ability 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!

    June 19, 2024 at 6:47 pm

    #4429801

  • Reply To: Cabot connect to Prod1

    I believe your error is related to firewall denying your connection.

    it might be technically visible as far as dns/server name resolution, and maybe even allows a ping, but wherever your...

    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:51 am

    #4428789

Viewing 15 posts - 31 through 45 (of 13,460 total)