Viewing 15 posts - 23,551 through 23,565 (of 26,486 total)
What it means is that you will have purchase SQL Server 2008 for the server that you are installing SSAS, SSIS, SSRS on seperately from your database server. You...
November 24, 2008 at 9:46 am
Congratulations. Maybe some day I'll go for the certs. I've been working with SQL Server for 12 years, but never really had the time to do it.
November 24, 2008 at 9:01 am
As you are pulling the data from a table, I'm at a loss as to why you are using a cursor for this process. Below is the code I...
November 24, 2008 at 8:35 am
Please note, I corrected the code in my post above. I didn't quite cut and paste correctly while rewriting it.
Sorry.
November 23, 2008 at 11:46 pm
Considering there isn't a MCDBA certification for SQL Server 2005. It has been broken out into 3 different certifications. As Jeff said, check the Microsoft Web site. ...
November 23, 2008 at 11:41 pm
kevin van (11/23/2008)
The query should work in SQL 2005, let me if it does not work
If the database is still in compatibility mode 80, yes, but if the database has...
November 23, 2008 at 11:34 pm
Here is my untested rewrite of your query. As rewritten, this query will also work on SQL Server 2000. I could have written the derived table as a...
November 23, 2008 at 11:32 pm
Here's the question you haven't answered. You have a loan with a monthly payment, the first payment is due on January 30th, when is the March payment due, since...
November 23, 2008 at 10:49 pm
Jeff Moden (11/22/2008)
GAAAA!!!http://www.sqlservercentral.com/Forums/Topic606992-65-1.aspx
Yep, the record's stuck, the record's stuck, the record's stuck, the record's stuck...
November 22, 2008 at 5:01 pm
teddunaveen (11/22/2008)
1)How to do the Defragmentation?
2)how to check the free space in server?
3)my application developer deleted 10 records how can i...
November 22, 2008 at 4:59 pm
I feel like I'm chasing a moving target myself. Everytime I think I'm close to understanding the problem, it changes (or the water gets muddier, pick your own metaphor...).
November 22, 2008 at 4:01 pm
Garadin (11/22/2008)
MyServer.AdventureWorks.dbo.Products.ProductID
Server.Database.Schema.Table.Column
You use it in linked server queries.
I have used linked servers, but I have never done that in queries.
I would use the four part name (server.database.schema.table) in the...
November 22, 2008 at 3:57 pm
Garadin (11/22/2008)
Just to clarify though, 3/4/5 part naming in the FROM clause isn't being touched, this just seems to imply that they want you to alias the...
November 22, 2008 at 12:50 pm
GilaMonster (11/22/2008)
Lynn's been doing an absolutely heroic job of keeping things under control while some of us have been lounging around in Seattle.
Yeh, it has been a killer week telling...
November 22, 2008 at 12:40 pm
Lynn Pettis (11/22/2008)
Garadin (11/22/2008)
Lynn,Where did you read this? Everything I've ever read suggests 3 part naming due to different schemas.
Here it is:
Transact-SQL
Three-part and...
November 22, 2008 at 10:59 am
Viewing 15 posts - 23,551 through 23,565 (of 26,486 total)