Forum Replies Created

Viewing 15 posts - 3,091 through 3,105 (of 13,460 total)

  • RE: Force SQL jobs to run serially, not in parallel

    I'd say if you have 14 separate jobs, they should not be scheduled to execute at all. i'd actually remove them to avoid confusion.

    instead,

    shouldn't you create one single...

    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 18, 2013 at 5:36 am

    #1633599

  • RE: using the default trace

    no, not the default trace; you'd need to use the dmvs instead.

    the default trace only tracks DDL or database settings changes...create/drop, alter, stuff like that; nothing related to Data access...

    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 17, 2013 at 9:38 am

    #1633351

  • RE: capture currently logged in users from sql

    huum (7/17/2013)

    I want to capture users logged int o my database from 9-5 and then get the average per day.

    can i please have the guidence

    users don't actually login at 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!

    July 17, 2013 at 8:14 am

    #1633306

  • RE: Find Data Source

    an example of checkign the references HanShi mentioned:

    --Objects:

    SELECT objz.name,

    fn.*

    FROM sys.objects objz

    CROSS APPLY sys.dm_sql_referenced_entities(schema_name(schema_id) + '.' + objz.name,'OBJECT')fn

    WHERE referenced_entity_name ='all_data'

    and just in case, you can check 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!

    July 17, 2013 at 5:58 am

    #1633198

  • RE: Drop a database user on a linked server.

    Charles Deaton (7/15/2013)

    That wprk fine for dropping the user from the master database. Is it possible to specify the database I need?

    just a a USE DatabaseName to the command, 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!

    July 15, 2013 at 7:27 am

    #1632459

  • RE: If Statement in a View/Query

    ok ray, this looks like a business "fiscal year" question, right?

    ie my biz year goes from july1 to jun30 of the next year?

    substitue MyDate for GETDATE() in this query, 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!

    July 11, 2013 at 8:46 am

    #1631616

  • RE: If Statement in a View/Query

    rayh 98086 (7/11/2013)

    Hello,

    I would like to create a SQL query that will make a decision based on date. For example, if the date is Jun 30,2013 or greater, then...

    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 11, 2013 at 8:22 am

    #1631602

  • RE: SQL Express Tools

    http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx

    go to this page, and click on the red button that says "Download SQL Server 2012 Express"

    a div will appear with various downloads, so just click the one that says...

    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 11, 2013 at 5:39 am

    #1631523

  • RE: How do you manage your code snippets/documentation?

    erikd (7/10/2013)

    Thanks, Lowell. Is your library at all portable? I find myself working from several computers, and several more term servers, so it's helpful for me to be able 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!

    July 10, 2013 at 12:04 pm

    #1631342

  • RE: find session

    newbieuser (7/10/2013)

    OH really? I thought its in MB?

    yes it is, but that's what's so tricky! it's not obvious!

    how much is 2147483647 MegaBytes?

    2147483+ Gigabytes!

    2147+ TeraBytes!

    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 10, 2013 at 12:00 pm

    #1631338

  • RE: How to defrag tables by filegroup

    i thought it was pretty straight forward from there;

    you would simply modify my example with a WHERE statement...

    WHERE filz.[name]='XXX_2012'

    if you need a fulls cript, i'm pretty sure if you search...

    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 10, 2013 at 11:58 am

    #1631337

  • RE: find session

    newbieuser (7/10/2013)

    Thanks. I'm confused with this one.. I set the maximum server memory(in MB): 2147483647 on the database server. But i the task manager sqlservr.exe is using 3349316K memory. So...

    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 10, 2013 at 11:17 am

    #1631315

  • RE: How do you manage your code snippets/documentation?

    i'll throw my two cents in;

    I use a combination of saved scripts in a specific folder(lazily using C:\Users\<username>\Documents\SQL Server Management Studio\Projects, and that folder has subfolders and hundreds, probably thousands...

    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 10, 2013 at 10:49 am

    #1631311

  • RE: OpenRowSet works locally but not over networked drives

    most likely permissions, because the startup account of SQL server doesn't have access to the network share.

    When you touch anything outside of a database, SQL server does not 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!

    July 10, 2013 at 10:30 am

    #1631305

  • RE: How to defrag tables by filegroup

    well, i've got this saved in my snippets to find tables by filegroup:

    SELECT

    objz.[name] As TableName,

    objz.[type],

    idxz.[name] As IndexName,

    ...

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

    #1631297

Viewing 15 posts - 3,091 through 3,105 (of 13,460 total)