Viewing 15 posts - 736 through 750 (of 1,478 total)
You can use the function fn_trace_gettable in order to insert the data from the trace’s files into table. You can look in BOL (Books On Line the help...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2009 at 4:02 am
No you can’t. You have to use an instance of SQL Server in order to work with the databases.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2009 at 3:51 am
Loose the first per of parentheses that surround the whole view definition (the one that starts after vDimBooks and ends the view definition. If this won’t fix...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 10:41 am
Yes it is done only once. The fact that you ask this question shows that you didn’t understand my explanation, so I’ll try to explain in another way....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 7:22 am
There is a contradiction between the explanation and the example. I fallowed the explanation. In my code check for difference that is above 60 seconds. I...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 7:01 am
What about an explanation about how to know which values should be discarded and which values should be on the same records?
Adi
EDIT - Posted the question before I saw Hal's...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 5:19 am
Can you be more specific and explain how you decide which values to show and which values not to show? How do you decide which records should be grouped...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 5:00 am
I hope you've taken a backup of Service Master Key also and restored the same on the Prodn. along with the certificate?
If not, kindly restore the Service Master key on...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 14, 2009 at 4:46 am
It isn't accurate because I didn't convert the numbers to a data type that supports fractions, so I might be off by a little bit. If this is...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 13, 2009 at 8:19 am
Maybe something like this will do the trick for you:
select file_id, name, physical_name, size * 8 / 1024 as SizeInMB,
fileproperty(name, 'SpaceUsed') * 8 / 1024 as UsedInMB
from sys.database_files
where type...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 13, 2009 at 7:57 am
I’m sorry, but I’m not a good source when it comes to SSIS. I suggest that you’ll post a new question about how replace characters in a file before...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2009 at 8:07 am
Bellow is an SQL code that shows you how to use the replace function. The first select shows you how the XML looks (you will see the escape characters)...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2009 at 6:44 am
You can have a step that opens it as text file and replaces all ampersands with the escape characters that is used for ampersand (& a m p 😉 -...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2009 at 6:10 am
Pleas don't double post the questions. This question was already answered here:
http://www.sqlservercentral.com/Forums/Topic829664-149-1.aspx
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2009 at 6:03 am
The problem is that ampersand is a reserved symbol in XML. It is used as part of escape characters and if it is used as part of text...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 7, 2009 at 5:57 am
Viewing 15 posts - 736 through 750 (of 1,478 total)