Viewing 15 posts - 886 through 900 (of 1,478 total)
You can invoke your function with a simple select statement. When you want to use a user defined function, you have to specify the function’s schema. Assuming...
--------------------------------------------------------------
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/
August 4, 2009 at 5:08 am
Can you check that your code doesn’t run dbcc checkident that reseeds the table? Also can you check if the code doesn’t insert the zero by enabling identity insert...
--------------------------------------------------------------
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/
July 30, 2009 at 6:34 am
Next time pleas create a small script that creates that table and insert the test data into it. This will save some time for anyone that wants to show...
--------------------------------------------------------------
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/
July 30, 2009 at 6:30 am
J-F Bergeron (7/27/2009)
USE TEMPDB
GO
CREATE...
--------------------------------------------------------------
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/
July 27, 2009 at 1:54 pm
It doesn’t necessarily mean that you have memory pressure. You need to check other counters such as page life expency, page reads/sec, page write/sec (all of them are...
--------------------------------------------------------------
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/
July 27, 2009 at 1:44 pm
I’d go with Jeff’s approach and go a bit farther. In a place that I’ve worked in the past we had a UserLog table that we had to keep...
--------------------------------------------------------------
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/
July 23, 2009 at 11:53 pm
It is possible, but most of times I wouldn’t do it. I would only do it if I know that the data will not change and cause the ranking...
--------------------------------------------------------------
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/
July 23, 2009 at 11:11 pm
I’m sorry, but I don’t understand what you need. There is a good chance that there are other readers that wanted to help you, but didn’t understand what you...
--------------------------------------------------------------
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/
July 23, 2009 at 1:13 pm
There isn’t a tool or a formula that will tell you how much memory the server needs. The database’s size is only one parameter, but you also need...
--------------------------------------------------------------
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/
July 21, 2009 at 7:38 am
This is a shot in the dark, but could it be that someone restored the database between the full backup and differential backup?
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/
July 20, 2009 at 1:45 pm
You can see the statistics by running dbcc show_statistics (you can read about it BOL which is the help that is installed when you install SQL Server’s client tools). ...
--------------------------------------------------------------
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/
July 20, 2009 at 1:37 pm
Can you delete other files from that drive? If not can you add another file for this file group and place it on a different drive?
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/
July 20, 2009 at 6:25 am
Hi Mel
I have to admit that I discovered SSC less then a year ago. By discover I mean started using it on a daily basis. I knew...
--------------------------------------------------------------
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/
July 17, 2009 at 9:32 am
Hi Mel
Thank you for your response. I usually use this site a lot, but few weeks ago I went on vacation, and didn’t login to SSC. ...
--------------------------------------------------------------
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/
July 16, 2009 at 8:28 am
In your code you are working with 3 data types. The first data type is the parameter’s data type - char(8) . The second data type is the...
--------------------------------------------------------------
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/
July 16, 2009 at 1:24 am
Viewing 15 posts - 886 through 900 (of 1,478 total)