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
1answer
40 views
SSRS 2008 R2 setup issue
I have installed SSRS 2008 R2 on my desktop and server. When I hit the reports link on my desktop
http://mypc/Reports_mypc/Pages/Folder.aspx
all I get to see is this
I cant create a new folder ...
1
vote
1answer
33 views
SQL Server Import Job Removed Data After Job Failed
I have a SQL Server Job set up to import data from a table to a table on another server, using the Import/Export data wizard.
In one instance, the job failed (with, I believe a SQL connection issue), ...
0
votes
0answers
30 views
SSMS 2012 error message: evaluation period expired despite Edition Upgrade
Problem similar to this one only with SQL Server 2012. None of the suggested registry edits have worked. This problem was supposed to have been fixed back in 2008 SP1.
Here's the sequence of ...
1
vote
1answer
66 views
Use a condition to limit the databases a policy checks
I'd like to create a Policy that checks, on demand, one database in an instance for tables that have no index. I can see how to create a Condition, linked to the 'Database' Facet and checks for my ...
1
vote
1answer
51 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
1
vote
0answers
39 views
Concurrent Access causing deadlock on the same table
Transaction 1 : SELECT distinct column_id from grid where row_id = @P0
Transaction 2 : INSERT INTO grid (grid_id, row_id, column_id)
In this table grid grid_id is primary key clustered.
...
-1
votes
2answers
93 views
Validate every client has a valid gender
I have table CLIENT which have columns are
COLUMN_NAME DATA_TYPE DESCRIPTION SOURCE TABLE
ClientPK int Identity column
ClientID int Client ID PARTY ...
0
votes
0answers
41 views
Hierarchical data best practices
I'm looking for a best practicies\databases to solve our problem:
Currently we are using SQL Server 2008 R2 with HierarchyId. It works ok, but we have a lot of performance penalties due to this ...
2
votes
2answers
29 views
sysjobhistory “sql_severity” codes
Where can I find out what the different "sql_severity" codes mean in the sysjobhistory table?
Eg what does 0 mean?
I've inherited a report that excludes ones with a 0 as "0 is not a real error"?
I ...
1
vote
1answer
28 views
Full-text search migration 2005 -> 2012 (.ndf file?)
So I'm trying to figure out the details for migrating from SQL Server 2005 to SQL Server 2012.
I tried to do restore and backup of a DB from 2005 to 2012. This worked well and for the text search ...
1
vote
1answer
47 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
6
votes
2answers
186 views
If I fail over one database, do the others that share the same mirror endpoint fail over as well?
We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints.
If I go into ...
3
votes
1answer
47 views
What is the safest way to run SSIS on Multiple Named SQL Server Instances?
I have an Active/Active SQL Server 2008 R2 cluster. There are two named instances on each node and no default instance.
I need to deploy SSIS packages to the different instances. To do this, I ...
0
votes
1answer
37 views
SSIS convert DT_WSTR to date
I'm new to SSIS trying to covert data types. I'm pulling data from Google Analytics and loading data into a SQL 2008 database. The date column from Google analytics appears as "DT_WSTR" and the values ...
3
votes
0answers
53 views
SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
Using SQL Server 2012 on Windows 2008 R2
I have been getting errors in SQL Logs for failed login for NT AUTHORITY\SYSTEM.
All of SQL Server's services are running under their own Domain accounts, ...
1
vote
3answers
52 views
Restore database with zero size log file [duplicate]
SQL Server backups contain meta-data about the size of the original log (LDF) file.
So if you backup a database that has a 5GB LDF file, when you restore it, you will get an (empty) 5GB LDF file. ...
4
votes
2answers
110 views
How can I reliably track stored procedure ( and functions ) use over time?
I have a lot of stored procedures and functions in database, many are not used any more and I want to remove them. How can I find them reliably ?
I have seen answer that suggests looking into plan ...
0
votes
0answers
75 views
DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS'
I have inherited a few scripts that are pumped through a c#.NET custom app to update a SQL2005 SP3 database. One of these scripts does a deletion on a user table called msw_timer_task, based on a ...
1
vote
1answer
32 views
Startup procedure for availability replica becoming primary
Is there any way how to create a startup T-SQL script/procedure for starting availability replica (when state has changed from secondary to primary)?
I want to disable SSIS jobs specific for related ...
1
vote
1answer
26 views
mdw_purge_data_ long runtime
I have a SQL Server 2008 R2 that is running several databases and has also been configured as our central MDW.
When the management data warehouse is created it creates a number of agent jobs one of ...
0
votes
0answers
55 views
Table Constraint causing deadlock
I have a table. When two transactions are inserting a large no of rows into table grid I am getting a deadlock due to INSERT/SELECT. So INSERT query has X lock on clustered index but since i am doing ...
0
votes
1answer
34 views
IIS Application pool running under network service can't connect to SQL Server
I just deployed an ASP.NET MVC 4 application to IIS 7 but when I browse it i get the following error:
Cannot open database "PCSPI" requested by the login. The login failed.
Login failed for user 'NT ...
6
votes
3answers
156 views
Are SQL Server statistics stored in database or buffer pool?
Just wondering are statistics kept in the database but not in the memory? If I backup/restore the database from a prod server to a development server, would it keep the same statistics so that ...
3
votes
0answers
56 views
General tool to load dump files
I am a big fan of Postgres both for its price but also for its features.
I am going to have to need to upload into it both Oracle dump and SQL Server files.
I will try to ask and beg for plain .csv ...
5
votes
4answers
342 views
Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure
I received a .bak file from a customer that I need to Restore, but the Restore exceeds licensed limit of SQL Server 2008 R2 10240 MB per database. All I really need is the DB structure. Is there a ...
-2
votes
2answers
66 views
Export complete database to a remote server including (Tables, Stored Procedures, Triggers)
How do we "export" a complete Microsoft SQL server database from one server to a "remote" server (including all the "stored procedures" and "triggers"). The export facility provided in the management ...
4
votes
1answer
54 views
How can I minimize SQL Server data loss in AWS in the event of failure?
If I am running a SQL Server in AWS. What is a low cost solution to minimize my risk of data loss in the event of failure at the database level?
Lets assume I am performing backups every 6 hours so ...
0
votes
1answer
36 views
Should I favor using a param or a scalar function result within a SELECT?
I have a select statement in SQL Server that must compare a large set of rows against a single calculated date.
The calculation itself is negligible; just looking for the prior Monday. Given that the ...
3
votes
2answers
67 views
How can I search the full text of a stored procedure for a value?
I use the following script to search the text of all stored procedures when I want to find specific values.
SELECT ROUTINE_NAME, ROUTINE_TYPE
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION ...
1
vote
2answers
76 views
Saving a SQL Server database to a file and opening it on another server under any database name
I am trying to find an efficient way of being able to physically save and open a SQL Server database like how it's done with Access. I would like to be able to save my entire database into a file ...
2
votes
0answers
23 views
Combining full-text-search queries
I have two tables in a SQL Server database with basic fulltext indexes:
CREATE FULLTEXT CATALOG table1_catalog;
CREATE FULLTEXT INDEX ON table1
(
name1
)
KEY INDEX pk_table1
ON ...
7
votes
1answer
118 views
Automatic decimal rounding issue
The question is relatively simple. I need to calculate 3 columns where the mid results are huge decimals, and I'm running into a problem early on with SQL Server basically rounding the decimals ...
-4
votes
0answers
43 views
How to group by the data by monday to sunday as a week? [closed]
How to group by the data by monday to sunday as a week ?
lets take one example :
take month march 2013, if i use the week function then it will group by
week 1 (3 days data)
week 2 (5 days data)
...
-4
votes
1answer
40 views
Update date Column values? any please help? [closed]
I Want to copy and data in same Table and Update date Column values? any please help?
-1
votes
2answers
109 views
Retrieve 5th highest salary in table [closed]
How to get the 5th highest salary from the table. Suppose, I have 100 rows and I want to display details of 5th highest salary of the individual then how to write that query in T-SQL using SQL Server ...
0
votes
0answers
25 views
Displaying Hexadecimal Characters in Reporting Services Report
How do I properly display hexadecimal characters in an SSRS report?
These characters: http://www.htmlhelp.com/reference/html40/entities/special.html
E.g., “ should display as left double ...
1
vote
2answers
40 views
Auto Disable a SQL Server User
I have a SQL Authentication User: JOHNDOE
I would like this account to auto-expire or auto-disable after X days or at a certain date/time. Any suggestions or best practices to do this?
4
votes
1answer
67 views
When performing a cross-database transaction, in which transaction log(s) is the information stored?
Given the following snippet:
-- error checking omitted for brevity
begin tran
exec database1..my_stored_procedure
exec database2..my_other_stored_procedure
if (@@error <> 0)
rollback
...
5
votes
4answers
62 views
How do I check if a certain SQL statement is being run?
Using SQL Server Management Studio, how can check or see who is running a certain SQL statement?
1
vote
1answer
54 views
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?)
I have 2 seperate SQL databases on the same SQL instance. Database1 references tables on Database2 in its views and stored procedures. Everything was working fine until we had to create a fresh ...
2
votes
1answer
62 views
WorldWide site - should I save UTC or in fixed time?
Let's say I have a world wide website ( I mean it has uses from all around the world).
I have 1 server which is in germany ( at some city). it will never be moved from germany - ever.
My question ...
1
vote
1answer
17 views
Inhibit Sql Server Log Shipping Alerts during certain times
There are batch jobs that occur in the middle of the night, which cause log shipping backups to be delayed such that they exceed the alert threshold, and alerts are then emailed.
How can I disable ...
2
votes
2answers
102 views
Is there a difference in performance between @date and getdate()?
Usually I use the getdate() function in my where clauses to go back in time.
Something like:
DOC.DATUM >= DATEADD(DD,-1*SSN_SDO.DANA_ZA_POVRAT,GETDATE())
Will SQL Server 2008R2 perform faster ...
0
votes
1answer
63 views
Tool to view intermediate query results
I am using SQL Server 2008 Express edition and I've worked two days on a problem where seems to be a cross join in running a query.
I would want to know the set returned per join operation visually.
...
0
votes
2answers
33 views
Can I recover CDC tables from transaction logs?
Is there anyway to restore CDC tables from transaction logs? My basic understanding is that CDC reads these logs, and entries that are specially marked, are grabbed by CDC. Once this has happened ...
0
votes
0answers
31 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
3
votes
3answers
68 views
pros/cons of different ways to store whether a record is one of two options?
I am trying to store whether an address is a Work address or a Home address. There will never be another type of address.
I'm wondering what the pros/cons are of the different ways to store this, ...
2
votes
3answers
95 views
How can I query data from a linked server, and pass it parameters to filter by?
I have a really big query that needs to be run on multiple databases, and the results appended to a temp table and returned.
The basic syntax looks something like this:
INSERT INTO #tmpTable (Id, ...
2
votes
1answer
56 views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
1
vote
1answer
82 views
Total Memory used by SQL Server (64 bit)
My knowledge on the subject suggests that perf counter SQL Server:Memory Manager: Total Server Memory only gives you buffer pool memory. There is a column called physical_memory_in_use in a DMV named ...
