Forum Replies Created

Viewing 15 posts - 2,686 through 2,700 (of 13,460 total)

  • RE: Max Function Output Mapping to get Description

    since you want date elements that are related to the same row where your max() is found, i think you want to use row_number with partition to organize 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!

    January 6, 2014 at 6:24 am

    #1677730

  • RE: DBCC

    JohnFTamburo (1/3/2014)

    Lowell (1/3/2014)

    DBCC requires db_owner permissions.

    I thought that this was the case, but apparently you need more oomph than that.

    Testing this from a SQL login that is not a sysadmin...

    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 3, 2014 at 1:57 pm

    #1677434

  • RE: how to create admin user by public user in sqlserver 2008?

    tnt750 (1/3/2014)

    hi all

    i have a username and password of the instance sqlserver 2008 in a web server

    i want create a admin user or hack this server

    please help...

    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 3, 2014 at 12:04 pm

    #1677406

  • RE: Trace File Rollover & EndTime

    I believe in that case, you want to load all the files associated to a trace, instead of individual files.

    I typically create a view for every trace i have 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!

    January 3, 2014 at 11:38 am

    #1677397

  • RE: DBCC

    it would be much, much easier to add indexes and modify the code in your trigger to perform better, instead of trying to second guess what the optimizer is doing...

    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 3, 2014 at 11:18 am

    #1677387

  • RE: Where can i find the latest world map shape file

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    http://www.sqlservercentral.com/Forums/Topic1527490-147-1.aspx

    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 3, 2014 at 7:46 am

    #1677284

  • RE: Where can i find the latest world map shape file?

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    http://www.sqlservercentral.com/Forums/Topic1527490-147-1.aspx

    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 3, 2014 at 7:45 am

    #1677283

  • RE: Where can i find the latest geographic world map shape files

    where did you download your current shape files?

    did you check to see if they had updated versions there?

    did you try searching for anything?

    https://www.google.com/search?q=geospatial+shape+files+sudan

    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 3, 2014 at 7:44 am

    #1677279

  • RE: Substring with patindex

    Ok Sean, I'm revisiting your ITVF version of this function, and seem to have a problem with it when the data does not have the data at the assumed index;

    rub...

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

    #1677241

  • RE: Exporting Data directly into Excel from SQL makes it too big to handle

    pujain (1/3/2014)

    Thanks for your replies.

    why I need this much of data : This is the requirement by Higher management for some analysis purpose, I know this much of data is...

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

    #1677229

  • RE: Please define SERVERPROPERTY('ComputerNamePhysicalNetBIOS')!!

    does this query from technet, which purportedly gets cluster information by reading the registry and other items via TSQL help?

    COLLECT CLUSTER INFORMATION USING TSQL

    i see it identifies node names 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!

    January 2, 2014 at 3:07 pm

    #1677068

  • RE: Running Client-side Profiler trace or Server-side trace?

    profiler is resource intensive, no matter the SQL version.

    consider this:

    there is nothing a slow, resource intensive profiler trace can do that a server side trace cannot do.

    EVERY client side trace...

    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 2, 2014 at 3:03 pm

    #1677064

  • RE: Domain Group Login Fails

    that error is normal, because you cannot execute as the context of a windows group, only as a windows user, who happens to be in that group.

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

    #1677030

  • RE: Create new role

    balasach82 (1/2/2014)

    I have to create a new role which should have "Select" permission on all tables created by other users and

    2.should have ability to create tables and have access 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!

    January 2, 2014 at 12:08 pm

    #1677029

  • RE: Stored Procedure Logging

    can you add CLR procedures?

    writing to a file is very, very easy if you add some CLR's;

    i've got a simple example out on codeplex that i wrote as a proof...

    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 2, 2014 at 10:21 am

    #1676993

Viewing 15 posts - 2,686 through 2,700 (of 13,460 total)