Forum Replies Created

Viewing 15 posts - 811 through 825 (of 13,460 total)

  • RE: Creating a database is slow based on role held, what am I missing?

    maybe the databases they are creating have large space assignments?

    i know if you have not set up instant file initialization, you can see some delays, right?

    https://blogs.msdn.microsoft.com/sql_pfe_blog/2009/12/22/how-and-why-to-enable-instant-file-initialization/

    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 21, 2016 at 9:33 am

    #1913787

  • RE: Registered Servers do not allow SQL Server Authentication in SQL 2016?

    glad you've got it sorted out.

    I have to use both in my environment;

    we have some tunnels to another domain where the AD accounts are not trusted, so I've got 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!

    November 21, 2016 at 9:04 am

    #1913774

  • RE: Registered Servers do not allow SQL Server Authentication in SQL 2016?

    ElementZero (11/21/2016)

    I don't see where it says that you may use Windows Authentication only...? In fact on the "Create a Registered Server" Page it even says you can use...

    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 21, 2016 at 8:50 am

    #1913763

  • RE: how to retrieve numbers from a string

    sqlinterset (11/21/2016)

    i dont have it in my sql library .. is there any other way using traditional sql?

    without reinventing the wheel?

    it's much easier to add it:

    it's in the zip...

    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 21, 2016 at 8:41 am

    #1913752

  • RE: how to retrieve numbers from a string

    sqlinterset (11/21/2016)

    i want to write a tsql query for it.

    DelimitedSplit8K is a TSQL function.

    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 21, 2016 at 7:40 am

    #1913709

  • RE: how to retrieve numbers from a string

    Find the article with the string splitter named DelimitedSplit8K here on SSC and download it;

    it makes spitting things like this a lot easier.

    once split, you just filter for items that...

    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 21, 2016 at 7:22 am

    #1913697

  • RE: Easier Way to Access Extended Events?

    here's the script i use to generate the CREATE VIEW scripts for all extended events on the server:;

    it has a reference to master.dbo.DelimitedSplit, which is a version i made of...

    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 21, 2016 at 7:14 am

    #1913694

  • RE: Easier Way to Access Extended Events?

    I've created views for all my Extended Events, so they are a little slow, but orders of magnitude easier to use.

    yes the views shread the XML, but once written they...

    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 21, 2016 at 7:08 am

    #1913693

  • RE: Registered Servers do not allow SQL Server Authentication in SQL 2016?

    In Registered Servers, "Local Server Groups", save Credentials with either SQL or Windows;the data is stored in your %appdata% folder, so it is user specific and not shared.

    Central Management...

    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 21, 2016 at 7:04 am

    #1913691

  • RE: Unable to complete login process due to delay in opening server connection

    I've seen this happen recently on a Web/WPF app where the SQL Instance was using SQL Express;

    as a resource conservation attempt, the express version defaults databases to auto close,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!

    November 18, 2016 at 1:26 pm

    #1913521

  • RE: How To Get System Uptime via T-SQL

    this is what i've used for quite a long time:

    I wanted both server uptime and the SQLService uptime.

    i made a simple stored proc, sp_help_uptime and put it in master,...

    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 18, 2016 at 8:44 am

    #1913461

  • RE: Disabling SSRS

    well, sp_who/sp_who2 should at l least show what is connecting to that database, I would just force the database off line then.

    in 2005 and above, i know we could do...

    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 16, 2016 at 6:13 am

    #1912762

  • RE: Disabling SSRS

    The SSRS Service is always active in the database, even when it's not really doing anything.

    SQL Server Reporting Services has two parts:

    The Service and the Databases it points to 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!

    November 16, 2016 at 3:43 am

    #1912733

  • RE: How can automate report from sqlserver to be sent on email everyday.

    Luis Cazares (11/15/2016)

    I wonder why an SSRS subscription wasn't considered. Too late for that, I suppose.

    at the time i was answering, i had tunnel vision.

    i swear, it looked like...

    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 15, 2016 at 11:16 am

    #1912621

  • RE: All SQL JOBS Status

    since this is more of an in your face dashboard, you'll need to build the pieces, failed jobs vs next scheduled jobs.

    this site has a nice query for the next...

    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 15, 2016 at 10:00 am

    #1912604

Viewing 15 posts - 811 through 825 (of 13,460 total)