Viewing 15 posts - 46 through 60 (of 583 total)
TheSQLGuru (7/29/2015)
July 29, 2015 at 1:05 pm
Jason A. Long (7/29/2015)
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
DROP TABLE #temp;
CREATE TABLE #temp([term] int,
...
July 29, 2015 at 1:01 pm
Have you tried LAG? This is just a minor twist on a typical running total which is easily solved with LAG. That of course is assuming you are on 2012.
My...
July 29, 2015 at 12:54 pm
I could understand why the BI key would not work, the EVAL edition is essentially enterprise which is a higher version of sql server. Developer is at the same level...
July 27, 2015 at 7:55 am
There isn't any specific wait type(s) to look for when you have slow queries. When you have a slow query, check what it is waiting on and proceed from there.
You...
July 27, 2015 at 7:50 am
SQLAssAS (7/21/2015)
If you have an active and passive node, only the active node needs to be licensed for SQL as only one node will be used at a time.
This is...
July 21, 2015 at 10:13 am
without having the second blade licensed for SQL server, you will not be able to use it for SQL Server. Additionally if you do not have Software assurance, i don't...
July 17, 2015 at 2:49 pm
even something as simple a ping will give you some indication of latency differences.
on the east coast app server ping the east coast DB server, then ping the west...
July 17, 2015 at 2:36 pm
when rebuilding indexes, a new index is created then switched out with the existing index, which is then dropped. your space should only increase as much as your largest index....
July 3, 2015 at 9:17 am
if you limit your access on a per client basis (ie server1 connect to dbserver on port 1433, instead of everybody to dbserver on port 1433) then, if you have...
June 22, 2015 at 12:22 pm
Is the correct version of litespeed installed on the server where you are doing the restore?
June 18, 2015 at 7:41 am
you are not very clear in what your requirements are? you want to determine the lag values in reference to what?
read the post at the link in my signature on...
June 16, 2015 at 12:48 pm
Do you rebuild your indexes over the weekend? Is there a lot of empty space in your datafile?
When you rebuild indexes, a new index structure is created effective doubling...
June 15, 2015 at 10:28 am
This should be what you are looking for. https://msdn.microsoft.com/en-us/library/ms143504(v=sql.130).aspx
I didn't think it would matter what group the service account was in because the installation assigns the appropriate permissions. Has there...
June 12, 2015 at 2:41 pm
Markus (6/4/2015)
June 9, 2015 at 11:15 am
Viewing 15 posts - 46 through 60 (of 583 total)