Viewing 15 posts - 7,546 through 7,560 (of 22,213 total)
GilaMonster (8/22/2014)
Robert Frasca (8/22/2014)
I have one filter to include my specific database name, i.e. LIKE 'DatabaseName'
There's the problem.
Take that filter out, the event will then show up and you...
August 22, 2014 at 8:06 am
You should absolutely see a command like:
SELECT * FROM HumanResources.vEmployee AS ve
within a server side trace if you're capturing SQL:BatchStarting. The only reason you wouldn't see that command is because...
August 22, 2014 at 7:37 am
If you're doing log shipping, by definition you're backing up the transaction logs. That's how you can move them to another location.
August 22, 2014 at 6:52 am
Full backups and log backups, after the very first log backup, are not in any way connected. You're safe to take those backups. Now, if you start introducing differential backups,...
August 22, 2014 at 6:00 am
Yep, go to your backups. That's the safest road to recovery here.
August 22, 2014 at 5:57 am
And I was thinking the opposite, that the T-SQL would be under the user account while the GUI would be otherwise.
August 21, 2014 at 7:42 am
It sounds like a security problem. The GUI works just fine in 2012 (not that I use it or advocate for it). Access denied is a very specific error suggesting...
August 21, 2014 at 5:53 am
Sounds like it might be fixed, but if not, no, you shouldn't need to update statistics. When you create an index for the first time, and same thing goes for...
August 21, 2014 at 3:25 am
I would suggest looking at the wait statistics by querying sys.dm_os_wait_stats before and after you run your query in order to understand why things are running slowly. I'd also look...
August 21, 2014 at 3:22 am
I'm pretty sure most of the projects are backwards compatible within Visual Studio, but only across two-three versions. Database projects where that way within SSDT. Not sure about SSIS, etc.
August 21, 2014 at 3:19 am
Paresh Motiwala (8/20/2014)
I have been reading too much good stuff about CSI. hence I have been pushing our datawarehouse be upgraded to sql 2014.
Citing this as one of...
August 21, 2014 at 3:17 am
MJ-1115929 (8/20/2014)
Thanks for shedding some light and highly appreciate the help provided, and nice to meet you , I have read your book on performance tuning and I...
August 20, 2014 at 3:36 pm
I'm with Jack, I'd suggest getting in direct touch with Microsoft. A crash of the instance is not something simply changing a setting or tuning a query is going to...
August 20, 2014 at 9:17 am
er.mayankshukla (8/20/2014)
The page compression on Table reduces the size of table as well as size of Clustered Index without any change in size to NonClustered Index.
Now My...
August 20, 2014 at 6:24 am
MJ-1115929 (8/20/2014)
We have a new project that requires some modeling ,design changes and performance tuning , as of now I am Administration side which I have only basic idea...
August 20, 2014 at 4:31 am
Viewing 15 posts - 7,546 through 7,560 (of 22,213 total)