Tagged Questions
3
votes
2answers
76 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
85 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:
...
0
votes
1answer
44 views
Generic SQL Job Scheduler for multiple RDBMS's?
I have been searching for an answer to this, but can't seem to find anything. So my problem is this - we have an environment with MS SQL Server 2008, MySQL, and RedShift, and have some complex ...
-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
...
0
votes
1answer
68 views
What is the maximum number of rows in a clustered index on datetime column?
I would like know what the max no of rows is in a clustered index (non-unique) on a datetime column table in SQL Server 2008R2.
1
vote
1answer
133 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
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 ...
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 ...
5
votes
1answer
322 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 ...
3
votes
2answers
623 views
Rebuilding index has impact on mdf/ldf files SQL Server 2008
While rebuilding index have used option 'SORT_IN_TEMPDB = ON' in order to avoid unnecessary growing your user database files.
What does it exactly means?
Is complete process done on TempDB and does ...
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
...
0
votes
1answer
49 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
2
votes
2answers
60 views
Data Backup and Restoring the same if requried in SQL SERVER 2008
In Multi-tenancy , Shared Database Shared Schema.
How to take Tenant level backup and restored the tenant data when required? Can any one guide me or point me to the right direction.
Thanks!!!
NB: ...
1
vote
1answer
825 views
How can I move LOB_DATA ( varbinary/image/text) to different Filegroups
LOB_DATA : varbinary(max),varchar(max), image , text columns.
I have 4 tables with large amount of LOB_DATA in it. I would like to move LOB_DATA in these tables to different File group in a different ...
1
vote
2answers
1k views
How to deny drop permission for a table?
Is there a way to deny drop permissions for a specific table from a user or role?
