Viewing 15 posts - 436 through 450 (of 605 total)
Yeah, I've been reading through stuff like that. I have been running online defrags as well as updating statistics.
It's a bit of a pain. For some reason, Auto Update Statistics...
March 31, 2005 at 3:16 am
Reindexing is a big issue here. I'm new to the company and the database is a vendor supplied system. I'm working with them at the moment.
The clustered index looks good...
March 31, 2005 at 2:23 am
Sorry, typo in there.
Columns A & B contain no NULLS. Only column C contains NULL values.
March 17, 2005 at 6:18 am
Nice one Rick. I'll be sure to try that out over the next couple weeks!
March 11, 2005 at 5:48 am
I saw one system some time ago. I can't find any pictures on the net at the moment. Some guy got hold of an old single seater cockpit and bolted...
March 11, 2005 at 5:16 am
I've seen some things in my time, but that is impressive.......
Not only would I have to persuade her to let me spend what I would imagine to be a fair...
March 10, 2005 at 3:34 pm
Not sure if there is a last accessed column or similar in any system tables.
Like you, I will be in a new job next week and will be in a...
March 10, 2005 at 3:17 pm
If you right click on the design page, are Task Toolbar and Connection Toolbar checked?
Do you not even have the MMC menu options (Console, Window & Help)?
March 9, 2005 at 5:00 am
You could use something like this.
SELECT
SUM(CASE WHEN DATEPART(YY, SaleDate) = 2003 THEN TOTAL ELSE 0 END) AS [2003],
SUM(CASE WHEN DATEPART(YY, SaleDate) = 2004 THEN TOTAL ELSE 0 END) AS [2004],
SUM(CASE WHEN DATEPART(YY,...
March 9, 2005 at 4:51 am
Alternatively, if the data column must include a value why not update the column to 7.45 where you have NULLS. Will make the actual query easier!
March 9, 2005 at 4:36 am
Hey,
6GB isn't a huge database by any means and SQL Server can easily handle DB's of that size. As was mentioned, the space is more a factor.
You mentioned creating a...
March 1, 2005 at 4:57 am
Absolutely not a single clue what that code would do. Aside from the comments, I'd really be struggling.
Tweaking the code is interesting though. How many of you would allow developers...
February 28, 2005 at 5:57 am
Yes, this is possible. To query two servers you will need to create a linked server. You would need to fully qualify the table on the second server. For example...
SELECT...
February 28, 2005 at 5:43 am
David,
You will also need to change the name of the server within SQL Server itself. This is stored in the master database.
Here is a recent forum posting.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163802
February 28, 2005 at 5:40 am
Hi,
The basic syntax is the same. You will just need to modify a couple of parameters for each statement. Following your structure, here is a couple of statements to get...
February 28, 2005 at 5:34 am
Viewing 15 posts - 436 through 450 (of 605 total)