Tagged Questions
-3
votes
0answers
46 views
SQL Server Partitioning…Really? [closed]
I was just looking at SQL Server's (2008) implementation of partitioning. Is it me or when compared to other RDBMSs (Oracle, Greenplum, etc), is SQL Server's implementation kind of a disaster from a ...
1
vote
3answers
52 views
Copy database to local from server [duplicate]
As I show , I have server database version-10.50.1600 and local database version-10.0.1600 .
How can I copy database (with all tables and data(s)) from server to local which has different version ? ...
4
votes
2answers
158 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
151 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
70 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
133 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
73 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.
2
votes
1answer
149 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
368 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
2k 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
361 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
733 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
154 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
50 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
62 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: ...
