I have some tables and I want to check if I need to put an index on them. I am not sure how to determine if the index will help or not. Is there a tool that I can use to determine this?
I am using ms sql 2008
I have a Web/DB Hosting client that has 750+ customer databases with the same number of tables (162) and same table structures. Combined, all of my client's customer data total 524GB (95% InnoDB)
Imagine all of these databases competing for 13G of innodb buffer pool on nine DB servers via circul...
Rolando says in that answer to stay away from SSDs in high-write environments
@Gonsalu you need to look carefully at MTBF for SSDs - they all have a limited lifetime measured in writes. I know opinion varies on this but for my money you still absolutely need RAID as well. Things are changing all the time though and high end SSDs are far longer-lasting than they were.
I have a database with three "levels" of objects: A, B, and C. Table A has around 100000 rows, B has 500000, and C has 2 million.
In a fit of stupidity, I designed the database to use joining tables AB and BC, even though these are 1:m and could have been represented as an ParentA attribute in B...
the current table doesn't use the PK from the original table, I had to tape on an identity column just for it to work with my framework. I'm not even sure if I should include the original PK since the old app didn't, I'm trying to figure out how it even kept things unique
they used app code instead of DB logic so finding out what's going on in the table is a mess
@Gonsalu SSDs have moved on leaps and bounds. Consumer spec drives will fail more often than their mechanical equivalents but weighed against the benefits, I'm a BIG fan!
As I was reading article I came across IBM's site about object Server. What actually is Object Server and what are it's uses? Can this be explained for a beginner?
This different companies thing is a nightmare. Turns out our IT dept is also basically the IT dept for a "competitor" we own 49% stake in. They use half their own IT infrastructure and half our own and there's no consistency.
I just found out about their major database server and it's in Pervasive SQL so I don't even have software to access it
@BenBrocka You should use their other tools. We use a mapper they wrote that works OK but the UI is terrible. You have to drag icons in a certain direction sometimes for them to work properly
I use a stored procedure to copy the tables from one database to the other database. Right now it does
insert into copy
select * from original
I would like to copy the index from the original table as well. What would be the best way to go about this ?
I see a lot of undocumented stuff being used in the SQL Server world; do you guys keep a list of useful undocumented stuff or is there some sort of list in the wild?
I am writing a powershell script to backup and restore databases. I am using forms to gather user input. At any point in the information gathering process, the user can hit "cancel".
To keep things tidy, I moved the form logic into separate functions. Is there a way to "exit" the entire scrip...
I recently saw the question "where 1=1 statement"; a SQL construct I have used often in constructing dynamic SQL in an effort to write cleaner code (from the perspective of the host language).
Generally speaking, does this addition to a SQL statment negatively affect query performance? I'm not l...
To create an indexed view in SS do I have to use SCHEMABINDING? I'm trying to create an optimal view for a table without affecting the underlying table at all
@JNK We have a program that's using sort of a precomputed view, it copies only relevant data from a large table into a physical "work" table, data's only one way
I've been trying to replace the physical table with a view, but the performance is horrible
can't add indexes on the underlying table/ect as it's a vendor table
@BenBrocka - Feel your pain, I dealt with that a lot at a prev job. If the data doesn't update regularly that might be a good workaround for now. If you are limited in changes you can make to the underlying tables then there isn't much you can do.
Sorting isn't a problem, can do that client side. In fact I could totally omit ORDER BY if it would help (it doesn't) I just need to fetch a massive pile of data
Oh hell, this is less than 10 columns, the underlying table has like 50 though
I'm a liar, 15 columns, only 4 search fields. It shouldn't be this much of a nightmare
A whole bunch of these indexes are called "webindex"+number and are duplicates. Think something is doing that automatically or someone was really unimaginative with names?
As I was reading article I came across IBM's site about object Server. What actually is Object Server and what are it's uses? Can this be explained for a beginner?
I use a stored procedure to copy the tables from one database to the other database. Right now it does
insert into copy
select * from original
I would like to copy the index from the original table as well. What would be the best way to go about this ?
I am writing a powershell script to backup and restore databases. I am using forms to gather user input. At any point in the information gathering process, the user can hit "cancel".
To keep things tidy, I moved the form logic into separate functions. Is there a way to "exit" the entire scrip...
