Tagged Questions
3
votes
2answers
83 views
One filegroup, multiple datafiles, how to get list of tables in each file
In one of my production databases, I have a filegroup with 3 data files sitting on 3 different disks. There are over 50 tables on this filegroup.
How do I identify the location of each of the 50 ...
1
vote
2answers
86 views
Database running out of space
My database has 16MB of space left.
I used to just truncate as I was taught but I found these links that advise against truncating:
...
-1
votes
1answer
58 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
2
votes
1answer
37 views
SQL Server database schema (and likely, some data changes) - how to auto-distribute over many database instances
Our development involves a SQL Server database (also might be Oracle or Postgres later) and we would sometimes make database schema changes or some other interventions in database.
What solutions ...
3
votes
2answers
87 views
Reducing Log Impact During Re-Indexing
We use Ola's maintenance solution and its great.
Regardless of method for re-indexing a major friction point with IT is the amount of log generated during the weekly re-indexing process. For a 1TB ...
0
votes
0answers
43 views
Linked server performace issue?
I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
-3
votes
2answers
107 views
read multiple values from same column [closed]
how to read multiple values in same column and campare it with the same table id and other table to get its record..
i have a table with column name
pid ,authors ,citing papers
...
2
votes
4answers
69 views
What is the best permissions to set for only creating and managing own databases?
I want to create a login for a new user who could only create and manage their own databases. Other databases on the server should be read-only to that user. What would be a good set of ...
1
vote
0answers
38 views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
0
votes
1answer
59 views
How to deny access to see the logins in a database
I create a login in SQL Server 2008 R2, and when that user connects to a database, it can see all the logins in the security logins. Can I deny access to watch the logins of the database?
0
votes
0answers
39 views
Prices for database administration tools [closed]
What should be the optimum price of an SQL database administration tool with 16 features including backup status review, server and data configurations, server statistics, disk space review, ...
6
votes
1answer
190 views
Role of Database Administrators
I am currently working as an application developer on a project which involves the creation of a new SQL Server database. I am actively working with a group of DBAs who will play some role in the ...
3
votes
1answer
116 views
SQL Server Restore from one database to another
One of our devs backed up a dev database, and then restored it in production. It's a new database for a new app that was deployed last night intentionally to prod.
Now in the backupset table ...
0
votes
2answers
134 views
Secure Linked Server - Non privledged user possible? Registry corruption?
Is it possible to use a non privledged Windows domain account to impersonate itself in a linked server?
And why would it be unable to read the registry for available network protocols?
Overview: ...
1
vote
2answers
172 views
SQL Server 2012, restore database
I am using MS SQL Management Studio 2012 to restore the database from a .bak file. (That file is from the backup of the database on server)
In my new database, the triggers are missing. Why did I ...
3
votes
2answers
87 views
Two corrupted indexes found by DBCC CheckTable
I'm wondering if this problem is solvable by dropping/recreating the two indexes. Both are rarely used, nonclustered, non PK, non FK indexes.
Here is the dbcc output:
Table error: table ...
1
vote
1answer
68 views
Public Database for Mobile Application
What are the proper steps to hosting a public database. Currently I a building a mobile application with Adobe Flash Builder. I have used Microsoft SQL Server, My SQL as well as WAMP Server. All of ...
1
vote
1answer
170 views
how to add attachment(text file) to database mail?
I have scenario
Daily i run a sql job to apply a new updates to one table - this job will create one text file daily - text file contains all new updates
I can send a mail to client that job is ...
3
votes
2answers
69 views
Load Testing Crash Course
Can someone point me at a good resource to get a crash course in load testing. I have a sql server machine that I need to load test but I havent been thruogh the process before. Also we do not have ...
2
votes
1answer
138 views
Will a primary key be added as a clustered index?
I've inherited a database where no primary keys were defined on the tables. There are also no clustered indexes assigned to the tables.
If I perform an alter table to assign a primary key will this ...
1
vote
0answers
78 views
SSMS produces error if query returns too many rows
We are having an issue with a server that we linked to our sql server 2012 instance.
The server that we linked through an odbc or oledb connection is Pervasive SQL.
Selecting from the linked server ...
1
vote
3answers
308 views
Detecting SQL Server Utilization with a query
My current project will send queries to an sql server constantly and It may use 100% of the memory or CPU.
How can I check if the server is nearing full utilization in a stored procedure so that I ...
1
vote
2answers
101 views
Database Is In InRecovery Mode.
I have a database that has entered "Recovery Mode". It was working fine, but ended up in this status a few days ago.
I have been told that a cause can be the partition holding the datafiles running ...
2
votes
1answer
83 views
How can I rename a table, but also all FK etc. references to that table?
I would like to e.g. rename my Applicant table to ApplicantProfile, as applicant is an abstract entity that has a profile. The profile is not the applicant.
Simply renaming the table is hopelessly ...
0
votes
1answer
196 views
Connecting to a SQL Server database from a Flash program
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
2
votes
2answers
136 views
How to login in database if we have lost password? [duplicate]
Possible Duplicate:
gain admin access to sql express 2008
Is there any idea if we lost our password to login in database using sql express management studio?
Is there any place where ...
4
votes
1answer
75 views
Expanding a partitioned table
I have a table that holds four years of data, where for each month I have a partition that is based on a filegroup with two files. Unexpectedly, I received eight more years of data and prepared the ...
4
votes
1answer
461 views
Appending backups while overwriting expired sets
I've been reading up on this, but the online documentation is a bit difficult to understand and seems awkwardly written. For example the INIT, NOINIT. One says it will try to overwrite everything. ...
-4
votes
1answer
97 views
Advice for designing a complex/multipart application [closed]
I'm designing a software application for my medical carrier.
It is very complicated, with many parts and many small details.
Some experts advised me to divide it to parts, then design the database ...
3
votes
1answer
840 views
How to connect multiple users/schemas in Oracle 11g?
I'm almost new user to databases, so I think I'm doing something wrong.
I have the database created.
I created 3 users, 1 it's an Admin, 2 are just users.
I created 2 roles, 1 for the Admin and 2 ...
1
vote
1answer
101 views
a question in tables relations
Table A is linked to Table B , and Table B is linked to Table C using primary and foreign keys
My questions:
Should i link Table A to Table C too?? Or Table B can act as intermediate link between ...
2
votes
3answers
1k views
Unable to start SQL Server Instance 2008 R2 - DB file corrupt
I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is
" The log scan number passed to log scan in database ‘master’ is not valid. This ...
1
vote
1answer
286 views
Data dictionary best practices in SQL Server 2008 r2 [closed]
We are interested in sharing the meta data and data dictionary among the team. I know that we can use the Extended Properties for this purpose, but based on my experience I've seen it gets out of date ...
0
votes
1answer
105 views
TSQL query for viewing start/end of all SQL Agent jobs yesterday
See this related query: What's a good tool for visualizing SQL Agent jobs?
I'm not after a visual tool however, since I am looking to build my own visualisation. This is my starting point, but ...
3
votes
1answer
85 views
How can I copy specific tables into one SQL Server Table into a separate table automatically?
I'm not sure if this is possible. Looking for some help with a specific issue. I am building an iPhone application with a data layer written in Ruby that will connect to SQL Server 2008. For various ...
3
votes
3answers
127 views
What is a good guideline for sampling for statistics updates
Scope: A billion record table that is indexed in 10 ways. Rate of change per day is 1/2 a percent.
Some of the indexes are monotonously increasing (datetime/timestamp), yet the common queries most ...
2
votes
2answers
975 views
Disabling Checking of Schema On Function/Stored Procedure Creation
I'm trying to automate the process that executes changes to the SQL Server 2008 R2 database. The process I put in place drops and recreates my stored procedures and functions, as well as run scripts ...
5
votes
1answer
323 views
Does dropping a Primary Key constraint from a Partitioned Table break the partition?
We have a table partitioned on a date column. The Primary Key for the table is a composite key of this date column and 4 other columns.
We are thinking about dropping the Primary Key constraint from ...
0
votes
1answer
535 views
How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week
I´m new to SQL Server administration.
I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary).
Is there some way ...
2
votes
2answers
485 views
Why database diagrams are not working when domain account is attached to database owner?
I was trying to use Database diagrams is SQL Server and got following error:
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
4
votes
4answers
186 views
Recommendation for free event monitoring software
I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough.
There are some interesting suggestions in this ...
4
votes
3answers
117 views
Can anyone describe the step by step process of recovery , backup and restore in sql server
Can anyone describe the step by step process of recovery via backup and restore in SQL Server 2008.
If possible please include some examples.
-3
votes
1answer
213 views
Single query to copy data from 3 tables into a single empty table
In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table.
I started saying "I will use a temp table or table variables", ...
2
votes
0answers
139 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
6
votes
3answers
162 views
Can I check the services currently running through SSMS?
I want to check which services has started and which has not by running a script/query on SSMS.
3
votes
1answer
149 views
Can I check what the allocation unit size is on my drives via a query?
Assuming that I do not have access to windows server, can I run a script from SSMS that would allow me to check whether allocation unit size is formatted with 64K?
9
votes
1answer
332 views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
2
votes
1answer
173 views
Active Directory domain being shutdown— Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
3
votes
1answer
79 views
Inconsistent information from different DMVs
I've a server with 12 GB of physical RAM. I just lowered its 'Max Server Memory (MB)' setting from 10 GB to 8 GB.
If I look at the processes' committed memory in Perfmon, I see:
select *
from ...
-2
votes
1answer
194 views
Sharing MS Excel Sheet over network? [closed]
Is it possible to have a Server PC running a MS Excel Sheet to which several Thin Clients will be connected via TCP/IP having Barcode Scanners? The scanner's should dump their Data in the MS Excel ...
