Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. It originated from the Sybase SQL Server codebase, which is why both products use the extension of SQL called Transact-SQL (T-SQL).
1
vote
2answers
19 views
Multiple “model” DBs — or db creation 'profiles'
I know you can't actually have multiple 'model' DBs on the same server instance. BUT, I'd like to have something almost like it. Basically, we have a business model where each customer is its own DB, ...
0
votes
1answer
66 views
Database Server down
I am an application developer and our firm doesn't have a dedicated DBA. Now, I am asked to see why our database servers were down? I know how to write queries and I want your help in knowing what ...
7
votes
2answers
203 views
Is adding index on bit column significantly slow down inserts?
I have a table with about 1 million to 5 million records. Small part of that records have one of bit column set to 'TRUE'. Need to fast find that records. I think that index can speed up searching on ...
1
vote
0answers
28 views
Deny permissions for master in SQL Server
I created a new database on a SQL Server 2008 R2 instance and a login/user for it. I have set the user to db_owner so he can't view any other databases on that server but he can see and query the ...
1
vote
0answers
16 views
In SQL Server sp_cursorprepare/sp_cursorexecute run extremely slowly
I'm running an application (Pentaho user console with the Saiku Ad-hoc plugin) which creates a query and runs it using sp_cursorprepare & sp_cursorexecute standard stored procedures.
My model is ...
0
votes
0answers
11 views
Master Slave Databases and their architecture
We are currently using Sql Server 2005. We currently have separate databases for different instances of our application. The application is a heavy in terms of data and processing.
We now want to ...
0
votes
0answers
16 views
SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber
In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers
For 2nd subscriber every table data is updating properly
But for 1st ...
3
votes
1answer
48 views
How can I search SQL Server for maintenance plans that execute specific tasks?
Sometimes certain SQL Server maintenance plan tasks can be problematic, like Shrink Database, Rebuild Index, Update Statistics, etc. I'd like to search for the use of one or more of these tasks on an ...
20
votes
2answers
691 views
Why does query error with empty result set in SQL Server 2012?
When running the following queries in MS SQL Server 2012 the second query fails but not the first. Also, when run without the where clauses both queries will fail. I am at a loss why either would fail ...
-2
votes
0answers
53 views
Is there an effective method for sql database recovery? [on hold]
Databases in my MS SQL Server 2014 have a condition - suspend, according to SQL Management Studio. I can't bring them into a work state through standard procedures. I used third-party tools, but they ...
0
votes
0answers
33 views
Looking for package with stored procedures for drop, create, disable, enable operations [on hold]
I become tired to write stored procedures for mass drop, create operations, e.g drop all from table, schema, drop with scripting and follow recreation, etc. Even enable/disable all triggers on table ...
2
votes
1answer
45 views
How to allow connections to SQL Server with 2 differents ip
I have a small issue here: I have a SQL Server instance 2012 (let's call it INSTANCE) on a cluster. I also have 2 network interfaces for this instance:
SQLINSTANCE.my.metwork
...
1
vote
0answers
44 views
Script to see running jobs in SQL Server with Job Start Time
how to write script to see running jobs in SQL Server with Job Start Time?
SELECT sj.name,
sja.run_requested_date,
CONVERT(VARCHAR(12), sja.stop_execution_date-sja.start_execution_date, 114) ...
-1
votes
2answers
32 views
How to Create users in sql server for accessing only one database using Management Studio
How to Create users in sql server 2008 R2 for accessing only one database using Management Studio.
regards,
salman
1
vote
1answer
88 views
DB Locks - How would one handle long transactions and maintain high concurrency?
We're maintaining a POS/WMS Application built in powerbuilder that runs on SQL Server 2008 R2 backend. Recently, we've been having a lot of locking issues and I believe it has to do with how we handle ...
