This is bad, what I thought I knew about clustering I now am questioning as I research this more.
When I have a multi server (say 4 servers) cluster using Windows 2003 & SQL 2005 Enterprise editions, can they or can they not all access the same resource database? If not, then I need to know how to provide better service to a web app that is heavy on the database access. We have a load balanced front end (web services) but the current SQL Server is now becoming a bottleneck and need to start to spread the workload across multiple sql servers access the same database in real time. Data is not currently partitioned. Regardless of the arrangement I will need to maintain the cluster for failover, but also need to spread the workload.
Thanks
Raymond Laubert
MCITP:Administration, MCT
http://www.rd-webhosting.com
Home Based Business Library and Hosting
My department is switching from a TM1 database to an SQL Server database. With TM1, only a few people had the software necessary to run queries installed on their PCs. Whenever I needed data, one of these people would run the query for me and then I would perform whatever analysis is required. Now however, we all have MS SQL Server (Query Analyzer, Profiler, Enterprise Manager, etc.) installed on our machines and will be able to run our own queries.
I have no prior experience with SQL (my only programming knowledge is with Excel VBA) so I bought the "Teach Yourself SQL in 10 Minutes" book and worked through most of it. I practiced writing queries in MS Access, and feel somewhat comfortable with the language. However, when I try to do anything with SQL Server, I feel kind of overwhelmed with all of the options. I assume that I should be writing and executing my queries from Query Analyzer, but I find the object browser and everything confusing. Also, I'm not sure if I'm even able to create my own database to practice with. It seems like I can only connect to my department's server. Is there any way to work "offline" with a database on my own hard drive?
All of the SQL Server books that I've found seem to be either for DBAs or developers. Anything geared more toward beginners isn't SQL Server specific. Can anyone recommend an appropriate book for me?
Some categories have sub-categories. Therefore, some entries will have null for parentID while others will point to another category.
I need to select all of the categories, but have them returned in the correct parent/child order (parents BEFORE children). I can't seem to get this to work correctly. Is this not possible or am I just being stupid?? :)
I have two tables: 1) Table that holds all available ports. 2) Table that holds users for each port.
There may be times where one user is getting more than one port at a time.
I've built up an ASP .NET page that will display each user its port/s in one table. On another table I want to display all the other available ports which the user doesn't posses and can buy to own.
My problem is where I try to build up the query. I just can't get all the other ports in normal display.
For example, this is what I need:
Ports table: 1/1 1/2 1/3 1/4
Users table: User A , 1/1 User A , 1/2
ASP page display:
------------ User A Holds: 1/1 1/2 ------------
Available: 1/3 1/4 ------------
Of course the Available option is derived from the User Holds query, and just getting the opposit not equal ports, but I just can't get it ! I've tried all kinds of Joins and nesting SELECT queries with no luck.
here is my problem and i am probably just stupid. i need the total amount Transfered minus the Received per barcode. so here i would need to see a total of 3.
I've getting the error message at the time ntbackup starts the backup of the server:
Event Type: Error Event Source: SQLWRITER Event Category: None Event ID: 24579 Date: 22-Aug-07 Time: 20:00:26 User: N/A Computer: DBS Description: Sqllib error: Database DYNAMICS of SQL server instance XXX is stored on multiple volumes, only some of which are being shadowed. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Data: 0000: 53 51 4c 53 4e 41 50 43 SQLSNAPC 0008: 33 36 31 00 00 00 00 00 361..... 0010: 53 51 4c 53 4e 41 50 43 SQLSNAPC 0018: 32 34 36 00 00 00 00 00 246.....
Where is the problem? How to fix this? Does this mean that I would not be able to restore server in the case of failure?
SQL - version SQL Server 9.0.3054 (2005 SP2) OS - 5.2.3790 (W2k3 R2 SP2)
I am trying to insert form data...three form sections into three different tables....i can insert into one table just fine....is this not possible ...or what? If so can someone please send me a small sample... thank you ...by the way i am using visual studio...vb asp.net 2.0 with ajax. Thanks in advance!
I haven't tested it, because at the moment I can't access my SQL database I know this is probably a stupid question, but...How can I test for DBNull when I'm using SqlDataReader.Item(string)? I use to check it using: if(!reader.IsDBNull(2)) ...But I have found that can not count on a particular ordinal reference because some of the stored procedures select the columns in different orders. can I do something like: if(reader["Column1"] != DBNull.Value)or with the reader["Column1"] throw an error because it is not found?? I too hate when people ask questions that they could test themselves...but I can't really test it at the moment. Any input would be greatly appreciated.
I'm trying to backup a database onto a different server within the same SQL Server Group, but the Enterprise Manager only offers the drives on the local server as destination options. Do I have something configured incorrectly or is there a way to do this manually? Thanks in advance.
Ok, I'm trying to understand how the db user corelates to the SqL login. Can one db user have multiple logins attached to it (like dbo with sa and nt admins).
This is in reference to the issue of broken chains of ownership problems that pop up from multiple users creating tables in a single database. I would like to be able to make all the developers be the dbo user of a given database without making them a sysadmin of the entire server. Is this possible?
If not, is there a sp that fixes a db so that all ownership reverts to dbo?
I have a little query in access ..now i must write it in T-Sql
the original... (MSG.IDLINGUA = IIF( EXISTS (SELECT * FROM ESMESSAGGI AS MSG WHERE MSG.IDLINGUA = [@idLingua] AND MSG.IDMESSAGGIO = BITS.IDDESCR), [@idLingua], LDEF.IDLINGUA))
I can't be able to assign a select value at my field... IDLINGUA to perform another select.. Of course I have used the "select case when exists"
I want to run SQL Server 2000 at home, on my PC. I dont have a server. My OS is Windows XP. Is this possible? Or do I have to use something like Access. If so then that sucks.
I use SQL Server at work and I want to practice at home.
I have installed MS SQL server eval edition and read through a lot of BOL, just about got my head around users and authentication etc and have a pretty good grounding on db design and architecture.
I now want to mess around with the sample databases a bit to get used to the SQL server interface before I start creating new ones etc but beyond random simple queries that I make up i'm struggling with what to do. I'm sure there are some microsoft tutorials based on the northwind and pubs databases I just cant seem to find any anywhere.
Dear Sql server experts I am suffering with a stupid problem in login into SQL server using SQL authentication method Well here is the case. When I start SQL server management studio of sql server 2005 A connect to server dialog comes up with 3 enabled combo box's for server type , server name and authentication If I connect to server via windows authentication then every thing goes fine but when I use the damn sql authentication so this alert occurred "Login failed for user 'toolbox', The user is not associater with a trusted SQL Server connection." Even with sa. Does any body has idea what to do? How to fix it? Please.
this is the alert when i use "sa" TITLE: Connect to Server - Cannot connect to myserver - ADDITIONAL INFORMATION: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Hopefully, this is an easy. Does SQL Server use the Windows system dateand time? Or does it keep track of what day/time it is on its own?We were just discussing this in the office today, because we'replanning for the changes in Daylight Savings Time in the United Statesthis year. It's going to start a month earlier and end a month laterthan it used to. Microsoft is apparently putting out patches forWindows so the OS will know to adjust the time by an hour on the rightdays, and we're trying to determine if our SQL and Oracle databases aregoing to be affected at all.--Richard
In sql server 2000, how do you manually go and truncate the logs? Doesthis only occur when you create a backup? all I want to do is manuallyshrink the log files. I have backups, so I don't need them.I actually backup the db once a week and back up the logs every day,yet the logs are getting real big. I thought this was configured inthe backup and/or the maintanance plan. I've done a restore (from thedb backup) manually hundreds of times, but I've never had to restoreto a checkpoint from the transaction log backups, maybe this is whyI'm confused on how to do this.thanks,dave
I have an SSCE database that I did not create. I'd like the app I'm working on to programmatically create said database the first time it runs (if for no other reason than the fact the next version may want to need the schema and not wipe out what's already there.
My idea was to have the Management Studio give me a database creation script like SSDE would and execute the T-SQL commands inside of the app but it doesn't appear that's something the Studio will do for SSCE databases. Is there another/better way to pull this off?
Okay, I really should know the answer to this by now, but the answer escapes me.
--Let's say I have a simple table:
create table #mytable ( id varchar(3) ) go
--Instead of doing this: insert into #mytable values ('ABC') go insert into #mytable values ('DEF') go
select * from #mytable go
drop table #mytable go
/* I'd like to do this (since I might have anywhere from 20 to 50 of these, etc.).
Like:
insert into #mytable values ('ABC','DEF','GHI','JKL') go
(Obviously this doesn't work since I need to repeat the column name however many times) - but isn't there a simpler way to insert multiple rows into an unpopulated table?
Unfortunately, I don't have the data in another table somewhere already, so I need to manually populate, but was wondering if there was a convenient way of doing this.
This is a question concerning query optimisation. Sorry if it's a bit long,but thanks to anyone who has the patience to help - This is my first posthere...If I have two tables: 'tblContact' and 'tblCategory' where categories arelike:Code Name010101 Short010102 Fat010103 StupidThe junction table 'tblConCat' has fields CctConID, CctCatCode to tell mewhich contacts have which category codes. These are nchar(6) fields, if itmakes any difference.If I need to find all people who are short, fat and stupid I can see twoways:Solution One:SELECT tblContact.* FROM tblContact WHEREConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010101') ANDConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010102') ANDConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010103')Solution Two:Build a helper table which contains the codes I'm looking forSELECT tblContact.* FROM tblContactWHERE ConID IN(SELECT CctConIDFROM tblConCat INNER JOIN tblHelperON tblConCat.CctCatCode = tblHelper.HlpCatCodeGROUP BY CctConID HAVING Count(*)=3)I have tried them both out and although I looked at the query analyzer itprovided more information than I knew what to do with. In practise theyboth provide similar working times (I wait about a second) but I thought thefirst looked rather inefficient and thought my helper table might help.There are about 30,000 contact records, 180 category records and 120,000junction table records.All I am looking for comments on any pros and cons of these two approaches -does one look that bad? The database was migrated from Access where thehelper table really did help, but using SQL Server I might not need it.Thanks again, if you got this far!
HiThis is a dumb question as I know it's fairly easy but I cant seem tofind an example after two hours of searching.In a stored procedure I'm trying to build up a string eg,(the following is in a loop)IF @xcount 0BEGINSet @list = @list + @title + ': ' + @xcountENDProblem is when I come to return @list, it's always NULL - when I knowthere should be data returned. Any ideas?ThanksLee
During the installation of Adding node to a SQL Server failover cluster(On passive node) getting error like.. The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.We run the below commands but didn’t get any resolution & got the same above error .
1<sup>st</sup> Method…
1. Open console command (Run->CMD with administrator privileges).
2. net stop winmgmt
3. Rename folder %windir%System32WbemRepository to other one, for backup purposes (for example _Repository).
