I have the below query working properly by but very slow, the sub-query is the cause of slow…
3 weeks, 4 days ago
I have an issue with one job in SSMS which uses some SSIS Package.
I'm receiving the error …
2 months ago
By: Erland Sommarskog
I have a query that performs differently depending upon the user executing it. This was…
3 months, 2 weeks ago
By: Grant Fritchey
CREATE TABLE #DETAIL ( IDR INT, ID INT, AMOUNT FLOAT, BALANC…
3 months, 3 weeks ago
By: Jeff Moden
I want to discuss about your experience what is better.
for example. I have procedure …
4 months, 1 week ago
I am writing a stored procedure with optional variables, but am not sure the best way to represent …
5 months ago
I am having trouble with a CASE statement like this.
The All Cars doesn't work.
Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running the disc and uprading? O…
5 months, 3 weeks ago
By: Johan Bijnens
What property value do I need to set so that the header row I created displays on subsequent pages?
6 months, 1 week ago
I need to insert sp_spaceused output of DATABASE into temp table.
How can I do this?
6 months, 2 weeks ago
SELECT sqltext.TEXT FROM sys.dm_exec_query_stats AS CP
CROSS APPLY sys.dm_exec_sql_text(sql_handle)…
8 months ago
When I double click on a .sql file, it starts up SSMS and loads my file. When I click on a second …
9 months, 2 weeks ago
I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of th…
I have the following trigger:
Create trigger [dbo].[new_Location]
10 months ago
When I copy/paste grid results from SQL Server Management Studio --> an Excel file, the WORD "NU…
Viewing 15 topics - 1 through 15 (of 30,210 total)
You must be logged in to create new topics.