SQL Server Admin 2014 :: Crystal Report Cannot Select Into Temp Table
Jul 30, 2015I know select * into ##tmp1 should work but I get a database connection error.
View 9 Replies
ADVERTISEMENT
SQL Server Admin 2014 :: How To Grant Access To Crystal Report User
Feb 24, 2015My sa account can not see the tables in the db. but can connect to the server
View 2 Replies View RelatedSQL Server Admin 2014 :: Create Dynamic Columns In Temp Table?
Jun 9, 2014I want to generate dynamic temp table so, from one strored procedure am getting an some feilds as shown below
CM_id,CM_Name,[Transaction_Month],[Transaction_Year],''[Invoice raised date],''[Payment Received date],''[Payout date],''[Payroll lock date]
for i want to generate table for the above feilds with datatype
SQL Server Admin 2014 :: Select Certain Column To CSV File
Jun 25, 2014I have a database it is 50 gb with hundreds of columns. I would like to choose a certain column and convert the data in it to .csv or excel file. How can I do that I am very new to MSSQL...
View 1 Replies View RelatedSQL Server Admin 2014 :: DB Growth Report With Compression Turned On?
Apr 14, 2015I got into confusion while working on DB Growth report for 2012 databases which has compression on.I am analyzing the DB Growth based on MSDB..dbo.backupset table which stores the backup information.
But here it gets tricky, In Previous versions we use "backup_size" column to get actual backup size and estimate the db growth based on the previous all backup file info. But now since compression is on in 2012 the "backup_size" colmuns gives a compressed file size(If i am right) so how do you know the actual backup size to estimate the db growth over a period of time??
SQL Server Admin 2014 :: How To Convert Float To Timestamp In Single Select Query
Mar 18, 2015How to convert float to timestamp in single select query
E.g., i have float as 1.251152515236 ,
I want to convert this to datetime and from datetime to timestamp... i.e. 26:11:00
SQL Server Admin 2014 :: Upgrade Adviser Report Identifies Proxy As Deprecated
Apr 16, 2015I ran the Upgrade Adviser Report on a Server and it identifies the Proxy's as being deprecated.
What action is needed?
Object Type: ProxyObject Name: sa-apro-cms
Object Type: ProxyObject Name: sa-apro-payroll
Object Type: ProxyObject Name: sa-pi-sql-agent
SQL Server Admin 2014 :: Find Report Server Database Name?
May 8, 2015Is there any way to find Report server database name using T-SQL?
I have SQL server report server instance and authentication credentials.
I can use sys.databases but in case of user had changed ReportDb name at the time of configuration this approach will not work then How I can find?
SQL Server 2014 :: UNION ALL In View With Temp Table
May 8, 2015I have a performance issue with one of the views when I join the view with a temp table
I have 2 Views - View1 and View2.
There is a third view - view_UNION where the
view_UNION =
SELECT * FROM View1
UNION ALL
SELECT * FROM View2
If I have a query like -
Select view_UNION.* FROM
view_UNION INNER JOIN #TMP ON #TMP.ID = view_UNION.ID
the execution is too slow.
But if I execute the views separately, I get good performance.
How to improve the performance of the view_Union
SQL Server Admin 2014 :: Insert A Row To A Table Based On Table Values?
Jun 10, 2015Here is my table:
My question is: How can I insert a row for each unique TemplateId. So let's say I have templateIds like, 2,5,6,7... For each unique templateId, how can I insert one more row?
SQL Server Admin 2014 :: Add New Column To A Table
Aug 24, 2015I am new in SQL Server, What to check ,what action do i need to take while adding a new column to a table.
View 5 Replies View RelatedSQL Server Admin 2014 :: Few Record Loss In Table Primary Key Where Same Records Exists In Foreign Key Table?
Jun 21, 2015Previously same records exists in table having primary key and table having foreign key . we have faced 7 records were lost from primary key table but same record exists in foreign key table.
View 3 Replies View RelatedSQL Server Admin 2014 :: Backup Of Indexes For A Particular Table?
Aug 9, 2014how to take backup of indexes for a particular table.
View 1 Replies View RelatedSQL Server Admin 2014 :: Backup Of Indexes For A Particular Table
Aug 9, 2014How to take backup of indexes for a particular table.
View 5 Replies View RelatedSQL Server Admin 2014 :: TDE Table Data Encryption?
Jun 8, 2015I'm having problems with the following code:
--DROP MASTER KEY
--GO
USE master;
CREATE MASTER KEY
ENCRYPTION BY PASSWORD = 'Pass@word1';
GO
USE master;
[code]....
What am I missing? What do I have to do if I get in a situation where I need to back out and start over?
[URL]
SQL Server Admin 2014 :: Identify Who Dropped A Table
Jun 30, 2015I'm getting a replication error that an object (Table) was not found. Any script that can capture this information?
View 3 Replies View RelatedSQL Server Admin 2014 :: Filegroup By Table Category
Oct 14, 2015I'm being asked to create multiple filegroups for a new database based on the table type, transaction, lookup, misc... From what i'm reading this doesn't make sense. I'm reading either large tables get file groups, nonclustered indexes when they are about the same size of the data, or a few other reasons...
First of all, we are talking about the same disk (please don't ask me about how it is configured) and I'm not sure yet if restoring separate file groups is even going to be necessary.
So here are my questions (beyond, the test and see what happens) because in the end I'm going to probably have to do what i'm told. So this is for my professional knowledge.
1. Does file groups separated by table type make sense?
2. Should you put tables that are queried often together in the same or different file groups.
3. I'm pretty sure you can't restore single file group for write access, am I correct?
SQL Server Admin 2014 :: Replicating Data To A Table Via A View
Aug 11, 2014I am trying to replicate data from a view in the publisher to a table in the subscriber (transaction replication). I do not need the view's base table, or the view itself, replicated to the subscriber. I only want to data from the view to feed a table in the subscriber.
Is this possible?
Running SQL Server 2008 R2 Enterprise.
SQL Server Admin 2014 :: Heap Table Fragmentation Is Higher Than 50
Dec 1, 2014I have bunch of heap tables and the fragmentation seems to be high, i am not sure whether i shall add index for them, as these tables are inserted and updated every day.
View 4 Replies View RelatedSQL Server Admin 2014 :: Restoring A Single Table From Backup
Dec 12, 2014With all the new functionality, can 2014 now restore a single table from a standard backup without using any third party tools? I have looked, but can't see this listed as a feature (though that doesn't mean it's not there, maybe I've just missed it).
View 6 Replies View RelatedSQL Server Admin 2014 :: Master Table With Insert Trigger
Feb 4, 2015I have a master table with after insert trigger on it.. When record is inserted into master table, the trigger fires and is captured in the backoffice table. In case the trigger fails, my record is neither in the master table nor in the back office table..
Is there anyway to capture the record either in the master table or in a separate table.
SQL Server Admin 2014 :: Table Size Difference In Two Database
Jul 20, 2015I am having an issue in determining the correct size of a table.
I have a tableA in some DB on transaction server (Enterprise Edition), this table is being replicated in reporting server DB (Standard edition).
When I check the space used by this table in both the databases i see noticeable difference.
I am using EXEC sp_spaceused 'tableA' to determine the space.
Transaction Server
------------------------------------------------------------------------------
name rows reserveddata index_size unused
TableA1439999 695416 KB507048 KB182912 KB 5456 KB
Reporting Server
-------------------------------------------------------------------------------
name rows reserveddata index_size unused
TableA1439999 656904 KB483664 KB172680 KB 560 KB
So I wanted to know what could be the possible reasons for this difference ?
SQL Server Admin 2014 :: List Of Users That Accessed A Table
Jul 22, 2015I'm trying to find out what tables are being used in a Database.
I don't want the last User but the User and the Dates.
I have a script that return the last user but that is not going to work.
The following script returns the last user but not all users and the Login Name:
ITH LastActivity (ObjectID, LastAction) AS
(
SELECT object_id AS TableName,
last_user_seek as LastAction
FROM sys.dm_db_index_usage_stats u
WHERE database_id = db_id(db_name())
[Code] .....
SQL Server Admin 2014 :: Create Temporary Table With Dynamics Column
Jun 10, 2014I have created a stored procedure for retrieving column name, as shown below
CM_id, CM_Name, [Transaction_Month], [Transaction_Year], [Invoice raised date],[Payment Received date],[Payout date],[Payroll lock date]
Now I am trying to create a temporary table using the above generated coluimns from Stored Procedure with datatype.
SQL Server Admin 2014 :: Can Lock Table Only For Specific User For Some Seconds
Apr 8, 2015I need to do some operations on a table when any user dont work with it.How do i do it?Do i lock the table? and is it possible?
View 8 Replies View RelatedSQL Server Admin 2014 :: Scheduled Job Runs Successfully But Table Does Not Update
Jun 25, 2015I have a job scheduled that imports a table from a Oracle database. The job runs at 3am and reports success. But for some reason when i query the table to see how many records there are, I see the same row count as the day before (it should increase everyday- student enrollment). When i execute the package manually, the table updates fine.
SQL Server 2014/Win7 x64.
SQL Server Admin 2014 :: Identify Table Made On Temporary Basis Are Not Used?
Sep 9, 2015In the Operating environment databases, may be made tables in the database on a temporary basis but they are still yet and they are not removed, how to identify tables that have been made on a temporary basis are not used (don’t have any read & write records)?
View 4 Replies View RelatedSQL Server Admin 2014 :: Table Does Not Exist - Error Occurred When Loading The Model
Jul 22, 2014The error is "The table with Name of 'Table Name' does not exist.An error occurred when loading the Model."
We get this error when we try to check the properties of an analysis server using SQL Server Management studio. We have resolved this issue twice by Stopping the SQL Server analysis service,removing db folders from Analysis Server Data folder and starting the services back on. The db folder that we removed was advised by the BI team.
The SQL Server Analysis Server is 2012 SP1
SQL Server Admin 2014 :: Policy Management - Table References In Stored Procedures
Feb 3, 2015Is there any way to enforce table references in stored procedures? For Example, we have stored procedures with a ton of different formats, "dbo.table", "table", "db.dbo.table", etc. Can we make it so that for every stored procedure, the reference must be at least "dbo.table"?
View 1 Replies View RelatedSQL Server Admin 2014 :: How To Read And Load Extended Events Into A Table For Querying
Jun 19, 2015I am setting up extended events more or less just fine, however I am a bit confused as to how to read and load them into a table for querying. In particular the offset part - is there a way to load just a given dates worth in?
I've got the files configured to be 20MB before rolling over, the XE is running all the time.
So if i load in the full file now, say that covers 2.5 days worth, when I load it again tomorrow to get the updated data I'm also reloading today, which is a waste?
I presume I am going about this wrong, but lack an example that really goes into detail of practicalities of loading this data.
SQL Server Admin 2014 :: Schema Change History - Identify Who Dropped A Table?
Jun 30, 2015How can I easily identify who dropped a table?
View 8 Replies View RelatedSQL Server Admin 2014 :: Does Security-admin Role Plus Deny Alter Any Login Cancel Each Other Out
Aug 27, 2015I want to set up a database role so that users can use sp_readerrorlog through SSMS. It does a check on membership in the securityadmin role.
I have tested it and can see you can grant execute on xp_readerrorlog but the SSMS GUI uses sp_readerrorlog.
I thought I could create a user/certificate and add the signature to sp_readerrorlog but it's not permitted (likely because it's not a normal database object).
So the other solution is to add the users to the securityadmin role but then explicitly deny alter any login (best done with a custom server role in 2012+ but otherwise just manually in 2008). I tested this out and it works, I'm not able to alter any logins or increase my own permissions, I also did a check of what's reported from fn_my_permissions(null, null) and it shows minimal permissions like I'd expect.
SQL Server Admin 2014 :: Giant Logfiles (LDF) During Loading Data Into Memory Optimized Table
Aug 26, 2013I try to load data into a memOpt table (INSERT INTO ... SELECT ... FROM ...). The source table has a size about 1 Gb and 13 Mio Rows. During this load the LDF File grows to size of 350 GB (until the space if the disk is run out of space). The Server has about 110 GB Memory for the SQL Server reserved. The tempdB doesn't grow. The Bucket Size in the create statement has a size of 262144. The Hash key as 4 fields`(2 fields have the datatype int,1 has smallint, 1 has varchar(200). ) The disk for the datafiles has still space for the datafiles (incl. the hekaton files).
How can I reduce the size of the ldf files during the load of the data ?