Viewing 15 posts - 9,661 through 9,675 (of 26,489 total)
sandeep rawat (9/11/2012)
if your data is changing daily then it will cost u crating index.for more detail there a link
Let us make this easier for others to follow:
September 11, 2012 at 8:14 am
SteveEClarke (9/11/2012)
TopLevel ...
September 11, 2012 at 8:13 am
Sean Lange (9/11/2012)
CELKO (9/11/2012)
I have a two articles on this topic at Simple Talk. There is no need to throw away performance, maintainabilty and portability to do this.http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists/
http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists---part-ii/
If portability...
September 11, 2012 at 8:11 am
CELKO (9/11/2012)
I have a two articles on this topic at Simple Talk. There is no need to throw away performance, maintainabilty and portability to do this.http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists/
http://www.simple-talk.com/sql/learn-sql-server/values()-and-long-parameter-lists---part-ii/
You do know that...
September 11, 2012 at 8:08 am
SteveEClarke (9/11/2012)
I am exploring the possibility of changing an inherited stored procedure to use Recursive CTE.
Basically I have 2 tables - "InventoryMaster" and "Bomstructure" - the BomStructure contains...
September 11, 2012 at 8:02 am
You would have to create the indexed view in the same database as the source table.
September 11, 2012 at 7:52 am
CELKO (9/11/2012)
Comments deleted.
Really Mr. Celko? Your entire post is inappropriate, rude, and unprofessional. I personally would like to see you just leave this site and not come back.
September 11, 2012 at 7:50 am
You are going to have to identify the data that won't convert.
Modify as needed and run this:
select
*
from
dbo.YourTable
where
ColumnToConvert like...
September 11, 2012 at 7:43 am
chrismat (9/10/2012)
A SELECT query returns four columns from...
September 10, 2012 at 7:24 pm
Mark Eckeard (9/10/2012)
Look at except:http://msdn.microsoft.com/en-us/library/ms188055.aspx
Mark
If you are going to post a url, at least make it usuable.
September 10, 2012 at 5:58 pm
ScottPletcher (9/10/2012)
Lynn Pettis (9/10/2012)
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said,...
September 10, 2012 at 5:04 pm
ScottPletcher (9/10/2012)
Greg Snidow (9/10/2012)
ScottPletcher (9/10/2012)
The UNPIVOT (one table scan) looks much better to me than fully scanning the table once for every grade column.
Yep, as I said, I put that...
September 10, 2012 at 4:24 pm
Oracle_91 (9/10/2012)
I have 2 sql sevr 2005 instances with same build no,same edition.
I restored the database from one insatnce to another instance. But when i execute the...
September 10, 2012 at 4:14 pm
Since the log and data files are in separate directories and disks. It shouldn't hurt to rename the log file to the .mdf file name and then start SQL...
September 10, 2012 at 4:05 pm
Viewing 15 posts - 9,661 through 9,675 (of 26,489 total)