You have to give the query a name and then create it as a view. For example suppose I have the fallowing query:

SELECT Name, ProductNumber, ListPrice AS...

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...

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...

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...

J-F Bergeron (7/27/2009)

---

Hi, I built this procedure for you, hope that it helps you understand how you can easily nullify the results, or return everything, based on the parameters.

USE TEMPDB

GO

CREATE...

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...

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...

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...

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...

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...

This is a shot in the dark, but could it be that someone restored the database between the full backup and differential backup?

Adi

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). ...

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

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...

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. ...