SQL Server Express

RE: Automation of table update and Adminstration of it

• by Site Owners

• Database Journal

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

2003-05-19

RE: Procedure cache - recompile problem

• by jpipes

• Database Journal

• Reply

Interesting. Could you post the test script? Thanks, Jay

2003-05-15

2 reads

RE: Repeated SQL Alerts

• by MarkusB

• Database Journal

• Reply

The reason why you still get this alert is the way SQL Server detects these situations. What the alert is doing is it looks in the sysperfinfo table. If you look into that table you will see that the value for deadlocks/sec = 1. Once anther deadlock occurs the value will be increased to 2. […]

2003-05-14

RE: converting unique identifier.

• by pttsusa

• Database Journal

• Reply

Thanks it works

2003-05-09

1 reads

RE: Failover Clustering

• by Brian Kelley

• Database Journal

• Reply

The hardware can be dissimilar. You tend to want to get the same servers, but this isn't a requirement (we have a 4/700 and a 4/900 clustered, for instance). As long as the lowest end server is capable of handling the load, that's what you're looking for. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish […]

2003-05-08

RE: Failover Clustering

• by Brian Kelley

• Database Journal

• Reply

That is correct, but here are some of the cons. This isn't to say tran log shipping isn't a good high-reliability solution. If it wasn't, no one would have figured out how to put things together in SQL Server 7.0 (and Microsoft wouldn't have implemented in SQL Server 2000 EE). With log shipping, one database […]

2003-05-08

RE: Must declare the variable ...

• by Roust_m

• Database Journal

• Reply

For this I get: INSERT INTO ##all_logins SELECT name, saturn FROM saturn.master.dbo.sysxlogins WHERE CONTAINS(name,'Ivanov') and an error: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'saturn'. But I need: INSERT INTO ##all_logins SELECT name, 'saturn' FROM saturn.master.dbo.sysxlogins WHERE CONTAINS(name,'Ivanov') How can I do this?

2003-05-08

RE: Creating global procs

• by dgermundson

• Database Journal

• Reply

OK, I got that working but I now have another issue. The new proc can run from any database but returns results only from the master database. Like this statement in the proc returns master db info: Its looking at sysfiles in master not my database. select sum(convert(dec(15,2),size)) from dbo.sysfiles where (status & 64 = […]

2003-05-07

RE: Need Help Soon..... Last Record in a Huge Table???

• by mybid2003

• Database Journal

• Reply

Thanks for all the replies... especially racosta & guarddata. We do not have any primary key, Identity, Date_Entered fields on this table. I pulled the required records with this query.... SELECT * from table1 where field1code = (select max(field1code) from table1) I have a Clustered Index on field field1code. As racosta and guarddata pointed, I […]

2003-05-02

RE: Expressions and aggregate function in SELECT list

• by winash

• Database Journal

• Reply

I think you might be able to get by with a derived table...i.e put in the aggregate function in the derived table and join it up with the original query.... this link : http://qa.sqlservercentral.com/columnists/nboyle/speed_select.asp gives examples of how to use derived tables..

2003-05-02