Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 13,460 total)

  • RE: Show data toEnd User Un-Interrupted.

    vineet_dubey1975 (2/7/2014)

    I am serving data to the end user(WebPage) via table 'ATABLE'. The data in the table got refreshed after every 1 hr. through a SQL Job (Truncate and refill)...

    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 7, 2014 at 5:38 am

    #1686986

  • RE: 1 Simple Question

    New Born DBA (2/6/2014)

    So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not...

    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 6, 2014 at 1:26 pm

    #1686754

  • RE: High CPU with many DB connections Prod almost down

    if it went a way after altering the proc, and then came back after a few hours, i'd start suspecting that stale statistics were affecting performance of the existing plans;

    if...

    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 6, 2014 at 10:28 am

    #1686688

  • RE: Query Help : pull Store Procedure name from Command

    wah.... this is the first time i saw this new highlighting and "this worked for the OP";

    cute ehnacement!

    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 6, 2014 at 10:22 am

    #1686685

  • RE: SQL Jobs

    make step 2 test for a specific time window as part of it's process.

    i start a trace @7am if it's not running, and turn it off at 5pm for example:

    --###############################################################################################

    --startup...

    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 6, 2014 at 6:56 am

    #1686584

  • RE: Database mail alert fails for group account

    group accounts via SMTP have to be explicitly opened by your exchange administrator, i believe; it's to avoid things like spammers sending to staff@microsoft.com anf getting viagra information to 80K...

    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 6, 2014 at 6:42 am

    #1686578

  • RE: Index with a column varchar(50)

    the usual answer is it depends on how you are searching;

    if you are searching on last name (WHERE LName = 'McArther')

    then yes, an index would help a query like that.

    anything...

    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 6, 2014 at 6:38 am

    #1686574

  • RE: How to make a function a system function.

    misspoke on "functions", sorry. unfortunately functions don't follow those nifty abilities like procs.

    views can be immediately referenced if they start witk sp_, so i have things like sp_Trace02 in my...

    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 6, 2014 at 6:25 am

    #1686571

  • RE: List DB users

    ok this might get you started: if you enumerate the permissions for your windows group, and then join this query of active directory for gorup members, you cna get 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!

    February 6, 2014 at 6:14 am

    #1686566

  • RE: How to make a function a system function.

    i actually make things system functions , system procedures, and stuff quite a bit i have a ton of developer tools i've created and adapted that go in master.

    they all...

    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 6, 2014 at 5:52 am

    #1686552

  • RE: Getting extended properties from every database

    this is just a variation on what you posted, butI see the delay is the WHERE Clause, 18 seconds for a server with 62 databases

    but i don't have very many...

    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 6, 2014 at 5:43 am

    #1686546

  • RE: Window function on different date ranges

    i think a field with a SUM+CASE statement would do the job:

    SUM(CASE WHEN order_date > 2012-01-15 THEN amount ELSE 0 END ) OVER (PARTITION BY customerid )

    --this passes 2012...

    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 5, 2014 at 3:27 pm

    #1686375

  • RE: Scripting objects into TFS automatically

    here's what i think you could do:

    use powershell to check out a folder, and then script out any objects.

    then use powershell again to add any new items, and check in...

    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 5, 2014 at 2:04 pm

    #1686358

  • RE: How To Capture ALL Data Retrieval Actions Regardless of Method

    YSL i just created one and scripted it out for you.

    This example is filtering for a specific databaseID (18) , for a specific user, and ignoring any '%exec sp_reset_connection%' commands...

    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 5, 2014 at 1:50 pm

    #1686354

  • RE: OS Disk Capacity Information

    would you consider adding a CLR procedure that gets the data instead? that seems like a much better way to go.

    http://www.mssqltips.com/sqlservertip/1986/sqlclr-function-to-return-free-space-for-all-drives-on-a-server/

    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 5, 2014 at 7:05 am

    #1686189

Viewing 15 posts - 2,551 through 2,565 (of 13,460 total)