Viewing 15 posts - 35,611 through 35,625 (of 39,803 total)
I have to admit that I tend to use single character, sometimes 2 char aliases, but they have some bearing to the tables. For example, I might use
select *
...
December 17, 2003 at 11:22 am
Anytime, and please continue the thread if you have more questions. IF you get it working, please drop the print script in our library. I'm sure someone else will appreciate...
December 17, 2003 at 9:54 am
The new Ken Henderson book on internals points out nicely that page splits cause nonclustered indexes to move because there is no "key" in the nonclustered index that points to...
December 17, 2003 at 9:53 am
Interesting. This could easily get confusing to read. Are you looking for a query that reports all jobs that "potentially" will run between some time frame?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
December 16, 2003 at 3:47 pm
Short answer:http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
Controlling access is the first thing you have to implement.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 3:45 pm
OK, to log in as the sql server agent, you need to check the account under which SQL server Agent runs. This in in the Control Panel | Admin Tools...
December 16, 2003 at 3:43 pm
How do you create the report? Is it some batch job?
Will the server "print" the report automatically? If so, you need to log in as the SQL Server Agent account...
December 16, 2003 at 10:44 am
We're looking at ways to do this. International is a challenge as is the print v web model.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:43 am
I'd say the core products (all 3) Are about the same. there is higher scalability in Oracle, but I'm not sure the vast majority if people need it. Cost is...
December 16, 2003 at 10:42 am
Depends on how you lay out the SAN. More spindles usually means more performance, but if you carve out a slice of disks for SQL and carve out another slice...
December 16, 2003 at 10:39 am
Tend to agree with above unless you have good reasons (like privacy) for separating the BU data.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:37 am
You could also move to differential backups, but it sounds like log shipping might be the best solution for you.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:35 am
I suspect that the "restore" creates a new db first with the log of that size. An interesting problem.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:34 am
It's somewhat true. A certification shows that you have proven you know something about the product and that you've spent some time learning about it.
Doesn't measure practical experience, nor whether...
December 16, 2003 at 10:30 am
If you change each DB, it should get saved fo the next time.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:27 am
Viewing 15 posts - 35,611 through 35,625 (of 39,803 total)