Viewing 15 posts - 23,566 through 23,580 (of 26,490 total)
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
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 four-part column...
November 22, 2008 at 10:58 am
I'm sorry, but I really don't understand the question, but here is a shot at it.
At 12:00 AM a full backup is started that doesn't finish until 5:02 AM. ...
November 22, 2008 at 10:12 am
Can you post the code for your stored procedure?
November 22, 2008 at 10:05 am
Jeff Moden (11/22/2008)
GilaMonster (11/21/2008)
Jeff Moden (11/21/2008)
Another favorite are those that ask things like "which would be faster" and they post the code for both... talk about "lazy". :hehe:
Yeah, but at...
November 22, 2008 at 10:04 am
Matt Miller (11/22/2008)
Lynn Pettis (11/20/2008)
Jeff Moden (11/20/2008)
Adrian Nichols (11/20/2008)
Jeff Moden (11/19/2008)
Boy oh boy do I ever agree with that! Guess that makes us "elitists", huh? 😛
I wouldn't say that...
November 22, 2008 at 9:55 am
Unfortunately, you can't decide what indexes should be created just looking at the table. What is important are the different queries (select/insert/update/delete) that will be run against the table(s)...
November 22, 2008 at 1:34 am
I'm not really sure what you are asking here. With SQL Server 2005 and later, full backups no longer block transaction log backups from running. Any transaction log...
November 22, 2008 at 1:26 am
Gail,
Just checked out your blog and it looks like you had a pretty good and exciting time here in the USA. Have some fun doing the tourist thing in...
November 22, 2008 at 12:31 am
You probably tried to create and use the database at the same time. The CREATE DATABASE statement must be in its own batch. Try this:
create database mytestdb
go
use mytestdb
go
November 22, 2008 at 12:19 am
Ahh geez, Gail, you're taking the fun out of it! :P;)
November 22, 2008 at 12:14 am
Sergiy (11/22/2008)
jsteinbeck (11/21/2008)
No offense, I come here to...
November 22, 2008 at 12:08 am
Viewing 15 posts - 23,566 through 23,580 (of 26,490 total)