logo
down
shadow

SQL-SERVER QUESTIONS

How do you handle audit logging with SSRS?
How do you handle audit logging with SSRS?
I wish this helpful for you The previous comments were dead on accurate that you can mine the data from the ReportServer ExecutionLog table in SQL Server 2000/2005 or the ExecutionLogStorage table in SQL Server 2008. If you are using form-based authe
TAG : sql-server
Date : January 25 2021, 03:26 PM , By : Joshua Johnson
SQL Server Recovery States
SQL Server Recovery States
it should still fix some issue GateKiller,In simple terms (and not a copy-paste out of the SQLBOL) so you can understand the concepts:
TAG : sql-server
Date : January 25 2021, 07:01 AM , By : Sigfrieg
Reorganise index vs Rebuild Index in Sql Server Maintenance plan
Reorganise index vs Rebuild Index in Sql Server Maintenance plan
will be helpful for those in need Doing a REORGANIZE and then a REBUILD on the same indexes is pointless, as any changes by the REORGANIZE would be lost by doing the REBUILD.Worse than that is that in the maintenance plan diagram from SSW, it perform
TAG : sql-server
Date : January 25 2021, 07:01 AM , By : user130518
SQL Server 2008 compatibility with SQL Server 2005
SQL Server 2008 compatibility with SQL Server 2005
I wish this helpful for you What is the best way to use SQL Server 2008 as a development database, but ensure that the database is compatible with SQL Server 2005? , This can be done via SQL Enterprise Manager or like this:
TAG : sql-server
Date : January 25 2021, 07:01 AM , By : ck1
Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performance?
Does running a SQL Server 2005 database in compatibility level 80 have a negative impact on performance?
Any of those help I think i read somewhere, that the SQL Server 2005 database engine should be about 30% faster than the SQL Server 2000 engine. It might be, that you have to run your database in compatibility mode 90 to get these benefits.But i stum
TAG : sql-server
Date : January 24 2021, 02:01 AM , By : Salikh
User access log to SQL Server
User access log to SQL Server
Does that help In SQL Server 2005, go to tree view on the left and select Server (name of the actual server) > Management > Activity Monitor. Hope this helps.
TAG : sql-server
Date : January 22 2021, 07:23 PM , By : Chris Hanley
SQL Server Escape an Underscore
SQL Server Escape an Underscore
this will help T-SQL Reference for LIKE for SQL Server 2000:
TAG : sql-server
Date : January 22 2021, 07:23 PM , By : tjh0001
Tables with no Primary Key
Tables with no Primary Key
like below fixes the issue When dealing with indexes, you have to determine what your table is going to be used for. If you are primarily inserting 1000 rows a second and not doing any querying, then a clustered index is a hit to performance. If you
TAG : sql-server
Date : January 22 2021, 07:23 PM , By : Ted Leung
SQL Server 2008 FileStream on a Web Server
SQL Server 2008 FileStream on a Web Server
hop of those help? Take a look at this article. I don't know a whole lot about FileStreaming and security, but there are a couple of interesting options in the FileStreaming setup such as allowing remote connections and allow remote clients to access
TAG : sql-server
Date : January 22 2021, 07:05 PM , By : Paulh
SQL Server Management Studio alternatives to browse/edit tables and run queries
SQL Server Management Studio alternatives to browse/edit tables and run queries
around this issue I've started using LinqPad. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!
TAG : sql-server
Date : January 22 2021, 07:05 PM , By : rixtertech
How much database performance overhead when using LINQ?
How much database performance overhead when using LINQ?
Any of those help In my experience the overhead is minimal, provided that the person writing the queries knows what he/she is doing, and take the usual precautions to ensure the generated queries are optimal, that the necessary indexes are in place e
TAG : sql-server
Date : January 22 2021, 04:47 PM , By : antonio
MOSS SSP Issue - Failed database logons from deleted SSP
MOSS SSP Issue - Failed database logons from deleted SSP
I wish this help you As Daniel McPherson said, this is caused when SSPs are deleted but the associated job are not and attempt to communicate with the deleted database.If the SSP database has been deleted or a problem occurred when deleting an SSP, t
TAG : sql-server
Date : January 22 2021, 04:47 PM , By : orneka
What is best practice for FTP from a SQL Server 2005 stored procedure?
What is best practice for FTP from a SQL Server 2005 stored procedure?
may help you . If you're running SQL 2005 you could do this in a CLR integration assembly and use the FTP classes in the System.Net namespace to build a simple FTP client.You'd benefit from being able to trap and handle exceptions and reduce the secu
TAG : sql-server
Date : January 22 2021, 04:45 PM , By : Salikh
How to enable Full-text Indexing in SQL Server 2005 Express?
How to enable Full-text Indexing in SQL Server 2005 Express?
fixed the issue. Will look into that further I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate.
TAG : sql-server
Date : January 22 2021, 04:45 PM , By : kuba53280
How do I know which SQL Server 2005 index recommendations to implement, if any?
How do I know which SQL Server 2005 index recommendations to implement, if any?
wish help you to fix your issue First thing to be aware of:When you upgrade from 2000 to 2005 (by using detach and attach) make sure that you:
TAG : sql-server
Date : January 22 2021, 04:45 PM , By : Edwin
T-Sql Remove Decimal Point From Money Data Type
T-Sql Remove Decimal Point From Money Data Type
To fix the issue you can do Given the constraint of only using T-Sql in Sql Server 2005, is there a better way to remove the decimal point from a money datatype than a conversion to a varchar (here implicitly) and then a replace of the decimal point?
TAG : sql-server
Date : January 22 2021, 04:45 PM , By : Liy
How do I Transform Sql Columns into Rows?
How do I Transform Sql Columns into Rows?
Any of those help You should take a look at the UNPIVOT clause.Update1: GateKiller, strangely enough I read an article (about something unrelated) about it this morning and I'm trying to jog my memory where I saw it again, had some decent looking exa
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : user184975
SQL Client for Mac OS X that works with MS SQL Server
SQL Client for Mac OS X that works with MS SQL Server
I hope this helps . Let's work together on a canonical answer.Native Apps SQLPro for MSSQL Navicat Valentina Studio TablePlus Java-Based Oracle SQL Developer (free) SQuirrel SQL (free, open source) Razor SQL DB Visualizer DBeaver (free, open source)
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : Caleb Ames
SQL Server 2000: Is there a way to tell when a record was last modified?
SQL Server 2000: Is there a way to tell when a record was last modified?
should help you out SQL Server 2000 does not keep track of this information for you. There may be creative / fuzzy ways to guess what this date was depending on your database model. But, if you are talking about 1 table with no relation to other data
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : delphiace
How to remove the time portion of a datetime value (SQL Server)?
How to remove the time portion of a datetime value (SQL Server)?
I hope this helps you . SQL Server 2008 and upIn SQL Server 2008 and up, of course the fastest way is Convert(date, @date). This can be cast back to a datetime or datetime2 if necessary.
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : hlpimfalling
I need to know how much disk space a table is using in SQL Server
I need to know how much disk space a table is using in SQL Server
hop of those help? I think most people know how to do this via the GUI (right click table, properties), but doing this in T-SQL totally rocks.
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : Lior
What's the best way to determine if a temporary table exists in SQL Server?
What's the best way to determine if a temporary table exists in SQL Server?
help you fix your problem When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that table only if it exists (before
TAG : sql-server
Date : January 22 2021, 02:12 PM , By : Blaise Roth
Calculate the row value based on different formula
Calculate the row value based on different formula
this one helps. First thing is your formula is not correct. As I understand there is unique row for each sl. And to do the sum of col1 and col2 correct formula is (col1 + col2). So correct that thing first.After that you may implement this using dyna
TAG : sql-server
Date : January 11 2021, 05:14 PM , By : Kbotei
how to set two variables for the same column?
how to set two variables for the same column?
will help you suppose i have the following statement , This is the right syntax:
TAG : sql-server
Date : January 11 2021, 03:34 PM , By : Jouni
Debezium Error : ConnectException: Data row is smaller than a column index
Debezium Error : ConnectException: Data row is smaller than a column index
seems to work fine I believe your source table schema does not conform tou the change table schema in CDC. Have you updated table schema recently? Have you followed https://debezium.io/docs/connectors/sqlserver/schema-evolution ? If not you should pr
TAG : sql-server
Date : January 11 2021, 03:32 PM , By : DaveF
TSQL -- find records in table with multiples in one column, and at least one specific occurrence of a value in another c
TSQL -- find records in table with multiples in one column, and at least one specific occurrence of a value in another c
will help you You must GROUP BY col1 only and with conditional aggregation you get all the col1 values you need:
TAG : sql-server
Date : January 11 2021, 02:18 PM , By : robinator
Table-Valued Parameter Recieving Invalid Data Type Error
Table-Valued Parameter Recieving Invalid Data Type Error
it should still fix some issue The root cause of appearing the error is the stored Procedure cannot find VeeamTableType because you create it under VeeamBackupResults schema and you are trying to create the Procedure under default schema (dbo at most
TAG : sql-server
Date : January 11 2021, 02:18 PM , By : Saurabh
UPDATE PERMISSION without ALTER permission
UPDATE PERMISSION without ALTER permission
will be helpful for those in need Use QUOTENAME. I also suggest using the appropriate data types for the dynamic objects:
TAG : sql-server
Date : January 11 2021, 11:39 AM , By : user186435
How to determine a table's dependencies?
How to determine a table's dependencies?
wish helps you I need to migrate some data between environments. The data structures are going to be exactly the same, however some of the data is ID dependent on existing data which will have to be adapted, or more precisely, userIds (such as owners
TAG : sql-server
Date : January 10 2021, 02:06 PM , By : Janko
Creating Dynamic Pivot Table Column Names
Creating Dynamic Pivot Table Column Names
hop of those help? Your result is correct above however, you will not have your columns sorted by the correct date...The below would cater for that:
TAG : sql-server
Date : January 10 2021, 02:06 PM , By : mansoor
How to debug CLR database object (stored procedure) using Visual Studio 2019
How to debug CLR database object (stored procedure) using Visual Studio 2019
This might help you I have written a CLR stored procedure (.NET Framework 4.5 and IDE VS 2019) and trying to debug the CLR stored procedure before deploying it to SQL Server 2016. However, I am unable to locate the debug option for CLR DB object. , W
TAG : sql-server
Date : January 10 2021, 02:04 PM , By : Jojo
DROP TABLE fails for temp table
DROP TABLE fails for temp table
With these it helps possibly something is happening in the session in between?Try checking for the existence of the table before it's dropped:
TAG : sql-server
Date : January 10 2021, 01:57 PM , By : David B
Why might SQL execute more quickly on SQL Server 2000 when NOT using a stored procedure?
Why might SQL execute more quickly on SQL Server 2000 when NOT using a stored procedure?
I think the issue was by ths following , Can think of two possible reasons: The stored procedure might be using an outdated execution plan. If you drop and recreate the stored procedure, its execution plan will be recompiled. A stored procedure is op
TAG : sql-server
Date : January 10 2021, 01:57 PM , By : Nougat
cmd line SQL server 2008 express install
cmd line SQL server 2008 express install
it fixes the issue I am trying to install SQL server 2008 express on windows 7 64 bit machine using the following command: , I use this and it works:
TAG : sql-server
Date : January 10 2021, 01:57 PM , By : eataix
Sql server query using function and view is slower
Sql server query using function and view is slower
hop of those help? the point of the view was to pre-compute the XML value into a regular column. To then use that precomputed value in the index on the view, shouldn't you actually query the view?
TAG : sql-server
Date : January 10 2021, 01:57 PM , By : Killercode
Does anyone have a backup strategy for SQL Azure databases?
Does anyone have a backup strategy for SQL Azure databases?
To fix the issue you can do Starting with update 4, SQL Azure now supports database copies. You can make a copy of your database, kept in Azure, and use that to retrieve data in the event of an accidental deletion or schema bugaboo:http://msdn.micros
TAG : sql-server
Date : January 10 2021, 01:57 PM , By : nagre
Accessing SQL Server using an IP Address and Port Number ... Help!
Accessing SQL Server using an IP Address and Port Number ... Help!
should help you out I need to access an SQL Server that is on a machine behind a firewall and you access this machine using an ip address like 95.95.95.33:6930 (not the real ip address) ... But, you get my point that by accessing 95.95.95.33 on port
TAG : sql-server
Date : January 10 2021, 01:49 PM , By : Brianna
how to create simulator for web application for load test and stress test
how to create simulator for web application for load test and stress test
wish help you to fix your issue Build a tool that can parse the log files from the web server and replay the requests again. Then you generate test cases by accessing your site using a normal web browser and record the log files.You can then replay t
TAG : sql-server
Date : January 10 2021, 01:47 PM , By : nobodyzzz
when a sql server agent job is created and scheduled should we start running the job manually for the first time or will
when a sql server agent job is created and scheduled should we start running the job manually for the first time or will
I hope this helps . The job will run on the schedule you provide - there is no need to run it manually to "prime" the schedule.Disabled jobs are never executed by schedule - the scheduled executions will be skipped. They can still be executed manuall
TAG : sql-server
Date : January 10 2021, 01:45 PM , By : Dominique Vocat
Split BulkColumn into Rows
Split BulkColumn into Rows
I think the issue was by ths following , What you thin it's a white space ' ' isn't really a white space. You can use (SELECT SUBSTRING(@results , 12, 1)) as
TAG : sql-server
Date : January 09 2021, 02:14 PM , By : Caleb Ames
Naming a Column using Variable
Naming a Column using Variable
Hope this helps Change your final query section to dynamic sql like this. It can be achieved only by dynamic sql.
TAG : sql-server
Date : January 09 2021, 02:14 PM , By : Ir0nh1de
T-SQL Slowly Changing Dimension - Multiple Updates, Single Action Output?
T-SQL Slowly Changing Dimension - Multiple Updates, Single Action Output?
I wish this helpful for you The MERGE docs says (emphasis mine):
TAG : sql-server
Date : January 09 2021, 05:38 AM , By : besn
SQL Output as XML namespace
SQL Output as XML namespace
will help you I am new to XML so please forgive my ignorance.
TAG : sql-server
Date : January 09 2021, 05:38 AM , By : acolomba
Using Wildcard For Range of Characters In T-SQL
Using Wildcard For Range of Characters In T-SQL
it fixes the issue We don't know the version, but if you're only 2016+ TRANSLATE would likely work well here:
TAG : sql-server
Date : January 09 2021, 05:38 AM , By : can
Azure SQL Server Elastic query with ApplicationIntent ReadOnly
Azure SQL Server Elastic query with ApplicationIntent ReadOnly
should help you out Query across Azure SQL databases completely in T-SQL. This allows for read-only querying of remote databases and provides an option for current on-premises SQL Server customers to migrate applications using three- and four-part na
TAG : sql-server
Date : January 09 2021, 05:38 AM , By : Nulq
How to get date ranges according to date data inside database table
How to get date ranges according to date data inside database table
I wish this helpful for you I have figured it out. to all who posted an answer it gives me a lot of idea.Here is my solution:
TAG : sql-server
Date : January 08 2021, 10:52 AM , By : leorick
How to get those records that contains every items mentioned in where clause
How to get those records that contains every items mentioned in where clause
To fix the issue you can do I have a table (mentioned below): , With EXISTS:
TAG : sql-server
Date : January 08 2021, 03:18 AM , By : Mahyar Sepehr
SQL Trigger on insert, only for new rows
SQL Trigger on insert, only for new rows
wish helps you I would like to run a query when the data in table is inserted. So when a data is inserted in table 1, trigger is executed and it runs a query only on new inserted data, and inserts results of this query into table 2. , I hope this giv
TAG : sql-server
Date : January 08 2021, 03:18 AM , By : JoeKaras
Recursively replace string using a CTE
Recursively replace string using a CTE
wish help you to fix your issue You may try this. Instead of using recursive cte you may use multiple cte to create your expression. Since sql already introduced this string_split function to convert your row cell into rows on particular delimeter, t
TAG : sql-server
Date : January 07 2021, 07:50 AM , By : user121350
How to merge multiple column into one column with same table in SQL Server?
How to merge multiple column into one column with same table in SQL Server?
To fix this issue I need to merge some column value into one column with varchar/nvarchar data type. , The CONCAT function should work here:
TAG : sql-server
Date : January 06 2021, 03:17 PM , By : sgmichelsen
Designing stored procedure to work with Multiple Tables which have different formats and logic
Designing stored procedure to work with Multiple Tables which have different formats and logic
I wish this help you Create one validation per table. The data and rules are clearly not the same so why would you treat them as such? If you have similar sub-validations you can write a function same as a procedural language and factor that into you
TAG : sql-server
Date : January 06 2021, 03:17 PM , By : Antony Briggs
How to select SQL Server table as tab delimited string
How to select SQL Server table as tab delimited string
will be helpful for those in need Notice the _RN is required in the supplying query. Could also be a TVFAlso, the ,ELEMENTS XSINIL is required to keep the "position" of null values, but they will NOT be null, bur rather an empty string
TAG : sql-server
Date : January 03 2021, 08:18 AM , By : msugar
How to delete specific range of records from a GROUP BY query?
How to delete specific range of records from a GROUP BY query?
help you fix your problem Here's what I came up with:Query to check results to be deleted: (col "old" is to identify two oldest records, "new" the two newest, for only those MediaIDs with a count > 10)
TAG : sql-server
Date : January 03 2021, 08:18 AM , By : user179445
SAS dsnless connection to SQL server not working even if OLEDB is installed
SAS dsnless connection to SQL server not working even if OLEDB is installed
it helps some times In Windows environments, clients like SAS can make OLEDB and ODBC connections (two distinct APIs) to relational databases. SAS/ACCESS using libname supports both forms requiring those specific features installed (check: proc setin
TAG : sql-server
Date : January 03 2021, 08:18 AM , By : Moe Skeeto
How to correct an error in SELECT statement
How to correct an error in SELECT statement
help you fix your problem It says what the problem is right in the error message, date is incompatible with int. You're trying to add an integer to a date field.
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : user186012
All cases when check constraints are executed for each row
All cases when check constraints are executed for each row
Hope that helps Don't use a function to check if a value is unique, use a UNIQUE INDEX:
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : user167963
Exporting database data to csv in classic asp
Exporting database data to csv in classic asp
it helps some times You are naming the filesystem object objRS2 and trying to use it as a database recordset. I would name it something like objFSO to make it clear it is a filesystem object and not a recordset.You will need to create a recordset usi
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : janik
Why does this char value not convert to datetime?
Why does this char value not convert to datetime?
Hope this helps I am not certain if the literal '2019-07-02 09:19:46.300' is the text value which is actually crashing your query. If you are using SQL Server 2012 or later, there is a helper function TRY_CONVERT which will attempt to convert an inpu
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : ciops
How to get file type from binary data in SQL Server File table?
How to get file type from binary data in SQL Server File table?
this one helps. The file_type column value is derived from the file name, not the binary contents of the file. SQL Server has no notion of what the actual binary contents represent.
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : Tamizhvendan
Reading derived column expression
Reading derived column expression
I think the issue was by ths following , This is a nested if then else in the format of [Logical test] ? [Do this if true] : [Do this if false]This is the formatted version.
TAG : sql-server
Date : January 02 2021, 06:48 AM , By : Stephen Dewar

shadow
Privacy Policy - Terms - Contact Us © scrbit.com