How to configure tempdb alert in SQL server
May 5, 2018 · I need scrpit to configure tempdb database log and data alert reached 50% of restricted size and i want automate. e:g If tempdb log/data file is reached 50 % and i want get that session …
Access Queries vs SQL run by VBA - social.msdn.microsoft.com
Sep 16, 2020 · The query optimization from saved queries is pretty much no longer apparent because of current hardware. Go back to the 80's and it was something to ponder, but now, not so much.
How do you troubleshoot a slow running query?
Feb 14, 2014 · Query running slow can have lots of reason behind it.What i will do is first find out is only particular query runnig slow or whole server performance is slow (might be user just got slowness for …
Update Query Error - social.msdn.microsoft.com
Aug 28, 2013 · SQL is orthogonal, so you can use any predicate where you can use any other predicate. --CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / …
Impact of creating a non-clusterd index on a huge transaction table?
Apr 17, 2015 · Also if possible create clustered index. One more option, you can horizontally partitioned the table and move data to multiple filegroups. Based of range of data your query performance also …
Linked Server to IBM iSeries - social.msdn.microsoft.com
May 8, 2019 · The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider.Cannot create …
How do I aggregate on more than one column within a PIVOT
Mar 6, 2015 · On SQL Server pivot query using UNION ALL of two pivot queries multiple aggregations can be implemented easily.
Cyclic table - social.msdn.microsoft.com
Jan 21, 2012 · Probably it would scale better if you just run a nightly purge job (SQL Server Agent) of records over 2 months. You can implement it as a stored procedure. With proper index maintenance, …
Concatenate nvarchar (max) with nvarchar (max) yields null
Aug 2, 2010 · I tried to concatenate two nvarchar (max) fields but the column came out being null. What is the recommended solution?
How to pass a variable for a SQL query in OLEDB source?
Feb 23, 2015 · When trying to retrieve the data from source using the variable (i.e. SQL Query with variable), I am not able to add the query as the SQL statement box is disabled. How to filter the data …