Viewing 15 posts - 1,966 through 1,980 (of 5,394 total)
I'm not sure that a static port is strictly needed here.
JDBC tests the dynamic port for named instances using the SQL Server Browser service, which listens on UDP 1434....
February 7, 2012 at 4:15 pm
Cadavre (2/7/2012)
erikpoker (2/7/2012)
Cadavre (2/7/2012)
In the slow running query, your statistics look out of date (e.g. you have a hash match operator that is estimating 7 rows but the actual number...
February 7, 2012 at 5:12 am
The main difference I see is how the distinct sort is performed.
In the "fast" plan the distinct sort is performed before the hash join and operates on 163508 rows.
In the...
February 7, 2012 at 5:11 am
No issues AFAIK.
Keep in mind this is a one-way path: you will not be able to restore the database in SQL 2000 from a backup set taken in SQL 2005.
Hope...
February 7, 2012 at 4:57 am
You could script out all the procedures and use a text editor to replace "ALTER PROCEDURE" with your header + "ALTER PROCEDURE" in all the files.
February 3, 2012 at 5:53 am
February 3, 2012 at 2:01 am
Looks like a good scenario for transactional replication.
January 31, 2012 at 3:14 am
Oracle user, right? 🙂
The equivalent of imp/exp is BCP. Look it up in Books Online.
January 31, 2012 at 3:13 am
Rowles (1/30/2012)
January 31, 2012 at 2:31 am
January 30, 2012 at 5:23 pm
Run the setup and select just the client tools.
I don't see how you can get confused with this. Am I missing something?
January 30, 2012 at 5:01 pm
No way to do this AFAIK.
You'd better DROP/CREATE all the temporary objects you are using, which is a best practice anyway.
January 30, 2012 at 4:59 pm
A simple SQLServerAgent job would do the trick.
How to set up a job: http://www.dailycoding.com/Posts/step_by_step_guide_to_add_a_sql_job_in_sql_server_2005.aspx
You will also need dbmail: http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm
Hope this helps.
January 30, 2012 at 3:52 pm
jshahan (1/30/2012)
in order to completely refresh the query window
I don't understand what you mean with this. Can you please clarify?
January 30, 2012 at 3:48 pm
ROW_NUMBER() OVER (PARTITION BY id ORDER BY [item_ordered?] DESC, id ASC)
means "give each row in the table a row number (rank) sorting rows by [item_ordered?] in reverse order (so that...
January 30, 2012 at 3:44 pm
Viewing 15 posts - 1,966 through 1,980 (of 5,394 total)