Forum Replies Created

Viewing 15 posts - 11,356 through 11,370 (of 13,460 total)

  • RE: SQL Server internal network traffic. Is it encrypted?

    if someone is on your network, they could put in a packet sniffer, and copy packets back and forth from a server to any machine. with some work, they could...

    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!

    March 26, 2009 at 10:25 am

    #966829

  • RE: SELECT from table variable takes long

    the rule of thimb I've heard around SSC is table variable is fine for 1000 rows or less, more than that it's recommended to use a temp table, and explicitly...

    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!

    March 26, 2009 at 10:08 am

    #966807

  • RE: Fastest way to fetch 10 milion records in a Desktop application that uses SqlServer2005 as Database

    i like Florians idea; I'd suggest something like he says, showing top 500 or something,and then a message like "171,432 records match this criteria...click next to review the next 500"

    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!

    March 26, 2009 at 7:42 am

    #966658

  • RE: Fastest way to fetch 10 milion records in a Desktop application that uses SqlServer2005 as Database

    well, bandwidth and local machines' capacity is going to be the limiting problems...download 10 million records locally, manipulate them in local client side memory, them send back changes to 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!

    March 26, 2009 at 7:20 am

    #966637

  • RE: How to insert 1000 rows in table

    that depends on the assignment your teacher gave you right?

    the easiest is to simply use the built in wizards from SSMS: right click...Tasks..Import/Export.

    Other options are to use the SSIS todo...

    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!

    March 26, 2009 at 7:08 am

    #966621

  • RE: Scripting out all Stored Procedures

    sql server management studio has that ability built in(right click on database...Tasks...Generate Scripts,

    Also since you can sp_helptext any proc/view/function, you could do something like this as well:

    SET NOCOUNT 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!

    March 26, 2009 at 6:59 am

    #966610

  • RE: log of query fired on particular database

    unless you have a trace already set up and running, you cannot find out who deleted data, and aside from that, will most likely NOT be able to recover data...

    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!

    March 26, 2009 at 6:30 am

    #966573

  • RE: Read Registry

    well, if you run the script below, it will read the registry and tell you teh listening port...

    i duoubt this will work over a linked server, which is what 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!

    March 25, 2009 at 6:03 pm

    #966380

  • RE: How to insert 1000 rows in table

    a bit xolumn is still an integer value...it's just limited to 0 or 1.

    does that help? i assume your excel file has that value in one of the columns?

    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!

    March 25, 2009 at 6:00 pm

    #966379

  • RE: Trigger after Insert - Multiple tables

    Florian, i used a smtp dll...not the built in. nowadays program that runs the job handleds it , but i've done it all in SQL as well.

    so i might...

    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!

    March 25, 2009 at 5:56 pm

    #966377

  • RE: Find this week's Friday in integer

    force of habit for me snuck into the code;

    SET DATEFIRST allows you to decide what day of the week is your "start of the week"; when you are fiddling with...

    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!

    March 25, 2009 at 1:43 pm

    #966243

  • RE: Trigger after Insert - Multiple tables

    yes exactly just a scheduled job for a stored proc that ran every minute....it looped thru every row in the table where a flag SentSuccessfully = 0; it was nothing...

    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!

    March 25, 2009 at 1:19 pm

    #966227

  • RE: Find this week's Friday in integer

    ok two steps, here's how I find "this weeks" monday and friday:

    SET DATEFIRST 1

    SELECT

    DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) Monday,

    DATEADD(wk,...

    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!

    March 25, 2009 at 12:11 pm

    #966182

  • RE: Trigger after Insert - Multiple tables

    Florian i recently found out that the procedure sp_send_dbmail is asychronous, so it does not wait for the preocdure to execute before returning control tot eh calling procedure;

    in 2000, 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!

    March 25, 2009 at 12:04 pm

    #966176

  • RE: restoring a table from a temp table

    adding a WHERE clause to check if any of the columns changed might be beneficial, but it's going to do a table scan regardless. like

    WHERE A.Col1 <> B.Col1

    ...

    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!

    March 25, 2009 at 11:57 am

    #966170

Viewing 15 posts - 11,356 through 11,370 (of 13,460 total)