Viewing 15 posts - 466 through 480 (of 824 total)
In terms of performance, also keep in mind that not all SAN's are created equal. A former employer switched from one brand to another (Xiotech to EMC) and immediately we...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 3:54 pm
In terms of performance, also keep in mind that not all SAN's are created equal. A former employer switched from one brand to another (Xiotech to EMC) and immediately we...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 3:52 pm
In terms of performance, also keep in mind that not all SAN's are created equal. A former employer switched from one brand to another (Xiotech to EMC) and immediately we...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 3:51 pm
I'm always a bit hesitant to get too much into these kinds of discussions. I don't know enough about the business requirements to make any detailed recommendations, but from what...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 1:39 pm
So basically the CompanySeasonTemplate overrides the CompanyEventTemplate? In other words, normally Company A wants 45 days lead time for event 1, but in summer they want 30.
Another way of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 1:14 pm
Yes, and no. The 8060 limit still applies to tables with fixed width columns, but if you have variable length data types in your table you can get around this...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 12:58 pm
All the time. I've never met an AD admin that did like the idea of delegation, so this leaves you with SQL authentication. However, you don't need to use sa...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 12:48 pm
You can use the net start <instanceName> to start SQL Server from within a batch file. Then you could osql to attach the database and run some queries spooling the results...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 12:44 pm
For the purpose of future functionality I would use the ObjectProperty function with the CnstIsUpdateCascade or CnstIsDeleteCascade argument to determine cascade properties.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 22, 2005 at 9:20 am
Generally, SQL does a good job of recovering after a sudden outage like that. However, some IO systems can cause real problems. Most modern IO systems contain significant amounts of...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 21, 2005 at 10:17 am
If I understand your question correctly..., there are several ways to determine if SQL Server is running.
Check the Services to see if the MSSQL service is running.
You can register an...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 21, 2005 at 8:30 am
The INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS view supplies this information.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 20, 2005 at 4:18 pm
Specifically, a Latch is a lightweight lock, used by SQL Server as pages are read from disk into memory.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 20, 2005 at 11:07 am
Check out Books Online for an article entitled "Displaying Locking Information"
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 20, 2005 at 11:02 am
I'd start out by verifying that the volume is available to that node. Check with your SAN administrator to be sure that it was offered to that server, and then...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 20, 2005 at 9:20 am
Viewing 15 posts - 466 through 480 (of 824 total)