Viewing 15 posts - 5,161 through 5,175 (of 8,731 total)
You have 2 main issues in here which cause performance problems.
1. Multi-statement table-valued function
2. (Nested) while loops
Those two can (and will) kill performance severely.
February 27, 2015 at 11:57 am
You actually posted the way to export a query and the link specifies all the options available.
Maybe you found this version more readable.
To copy the previous version is really easy....
February 27, 2015 at 11:14 am
It would be something like
EXEC xp_cmdshell 'BCP.exe "Test.dbo.Table" Out "C:\Table.csv" -c -t"****%*****" -SMyTestServer -T -m10 -e"C:\Table.err" -o"C:\Table.out"'
I linked the article on bcp utility in my previous post. It will...
February 27, 2015 at 10:41 am
That code is from Sybase.
To export to csv, you need to use the bcp utility. If you want to call it from SSMS, you have to use xp_cmdshell.
February 27, 2015 at 10:24 am
Lynn Pettis (2/26/2015)
... Mark one off, 1 day on the calendar to go. 1 day on the calendar to go, 1 day to go, ...
Enjoy the trip as you might...
February 27, 2015 at 9:59 am
Jeff Moden (2/26/2015)
Moin Ul Haque (2/26/2015)
Jeff Moden (2/25/2015)
Moin Ul Haque (2/25/2015)
February 26, 2015 at 6:33 pm
Something like this?
WITH SampleData AS(
SELECT 'DANIEL SHAFFERS, INCORPORATED.' AS CompanyName UNION ALL
SELECT 'BUFFETS, INCORPOR. ' UNION ALL
SELECT 'WAYNE,...
February 26, 2015 at 6:20 pm
ANn -425914 (2/26/2015)
For SQL performance tuning for a query, does the order of columns in where filter clause matters?
No, column order is irrelevant.
Also does order of columns matter in join...
February 26, 2015 at 6:13 pm
When you included the column from table2 in the WHERE clause, you converted your OUTER JOIN into an INNER JOIN.
This articles explains what happened: http://www.sqlservercentral.com/articles/T-SQL/93039/
And here's an example of how...
February 26, 2015 at 6:06 pm
Lynn Pettis (2/26/2015)
Sean Lange (2/26/2015)
Speaking of funny shirts. Here is one that I just got in the mail. I know that Lynn will appreciate this one.
Yes, I should get one...
February 26, 2015 at 3:19 pm
I'm not sure what you're talking about. Can you be more explicit? Where do you want to display the column alias?
February 26, 2015 at 3:15 pm
Sean Lange (2/26/2015)
Stewart "Arturius" Campbell (2/26/2015)
Sean Lange (2/26/2015)
BWFC (2/26/2015)
Sean Lange (2/26/2015)
February 26, 2015 at 8:37 am
I'm not sure what you're doing or how you're getting that. Maybe you have an empty column at the end which simulates a trailing comma.
Using this code, I didn't got...
February 25, 2015 at 6:30 pm
Are you using a format file?
Could you post the bcp command that you're using (obfuscating paths and filenames)?
February 25, 2015 at 4:17 pm
This is a possible option.
CREATE TABLE SetsItems(
SetId int,
ItemCode varchar(10))
INSERT INTO SetsItems
SELECT 1,'A' UNION ALL
...
February 25, 2015 at 12:14 pm
Viewing 15 posts - 5,161 through 5,175 (of 8,731 total)