Viewing 15 posts - 1,966 through 1,980 (of 5,393 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....
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
February 3, 2012 at 5:53 am
February 3, 2012 at 2:01 am
Looks like a good scenario for transactional replication.
-- Gianluca Sartori
January 31, 2012 at 3:14 am
Oracle user, right? 🙂
The equivalent of imp/exp is BCP. Look it up in Books Online.
-- Gianluca Sartori
January 31, 2012 at 3:13 am
Rowles (1/30/2012)
-- Gianluca Sartori
January 31, 2012 at 2:31 am
Here it is: http://www.microsoft.com/download/en/details.aspx?id=7593
-- Gianluca Sartori
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?
-- Gianluca Sartori
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.
-- Gianluca Sartori
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.
-- Gianluca Sartori
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?
-- Gianluca Sartori
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...
-- Gianluca Sartori
January 30, 2012 at 3:44 pm
Viewing 15 posts - 1,966 through 1,980 (of 5,393 total)